Skip to main content
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
required
A human-readable name for the component.
​
Mode
drop-down
required
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
required
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
required
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
A pattern for case-sensitive matching of strings. For more information, read LIKE.
​
Starts with
string
A Snowflake STARTSWITH function.Depending on the Object Type selected, this property may not be applicable.
​
Limit
integer
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
required
Select a grid variable item from the list. For more information, read Grid variables.
​
Grid Variable Mapping
column editor
required
Map columns from the SHOW query to the columns of the grid variable. For more information, read SHOW.