Show to Grid🔗
The Show to Grid is an orchestration component that lets you save the results of a SHOW command into a grid variable.
Properties🔗
Name = string
A human-readable name for the component.
Mode = drop-down
Select Basic or Advanced. Basic is a low-code methodology for configuring this component. Advanced mode requires you to write the SQL manually.
Depending on the mode selected, different properties will be available for configuration.
Object Type = drop-down
Select from a list of object types that you want to run SHOW against.
This property is only available when Mode is set to Basic.
In Location = drop-down
Choose from Account, Database, or Schema to define the scope of the Object Type.
Depending on your selection, you may need to specify a database or schema in the properties below.
Database = drop-down
The Snowflake database. The special value [Environment Default] uses the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.
Depending on the value selected in the In Location property, this property may be required.
Schema = drop-down
The Snowflake schema. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Depending on the value selected in the In Location property, this property may be required.
Like = string optional
A pattern for case-sensitive matching of strings. For more information, read LIKE.
Starts with = string optional
A Snowflake STARTSWITH function.
Depending on the Object Type selected, this property may not be applicable.
Limit = integer optional
The row limit to return. Maximum is 5000.
Depending on the Object Type selected, this property may not be applicable.
Query = code editor
Input a SHOW command. For more information, read SHOW.
Use Maia to build your query.
This property is only available when Mode is set to Advanced.
Grid Variable = drop-down
Select a grid variable item from the list. For more information, read Grid variables.
Grid Variable Mapping = column editor
Map columns from the SHOW query to the columns of the grid variable. For more information, read SHOW.
| Snowflake | Databricks | Amazon Redshift |
|---|---|---|
| ✅ | ❌ | ❌ |
Got feedback or spotted something we can improve?
We'd love to hear from you. Join the conversation in the Documentation forum!