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 |
---|---|---|---|---|
✅ | ❌ | ❌ | ❌ | ❌ |