Skip to content

Show To Grid

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


Properties

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