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 SHOW 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] uses 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] uses 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
✅	❌	❌	❌	❌