Skip to content

Show To Grid

The Show to Grid component lets you save the results of a SHOW command into a grid variable.


Name = string

A human-readable name for the component.

Basic/Advanced Mode = drop-down

Basic Mode is a low-code methodology for configuring this component. Advanced Mode requires you to write the SQL manually.

Object Type = drop-down

The type of object to run DESCRIBE against.

Like = string

A pattern for case-sensitive matching of strings. Read LIKE to learn more.

In = drop-down

The scope of the object type. Choose from an entire account, or a specific database or schema.

Database = drop-down

The Snowflake database. The special value, [Environment Default], will use the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.

Schema = drop-down

The Snowflake schema. The special value, [Environment Default], will use the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.

Starts with = string

A Snowflake STARTSWITH function.

Limit = integer

The row limit to return. Maximum is 5000.

Grid Variable = drop-down

Drop-down list of grid variables. Read Grid variables to learn more.

Grid Variable Mapping = multiple drop-downs

Map each column in the grid variable to a particular "type" of metadata by selecting from the available drop-down menus.

Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics