Table Metadata to Grid

This component will take the metadata from a table and use this data to populate a grid variable with data.

Properties

Name = string

A human-readable name for the component.

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.

Grid Variable = drop-down

Select the grid variable to be loaded with data. To learn more about grid variables, read Grid variables.

Grid Variable Mapping = column editor

Map each column in the grid to a particular "type" of metadata by selecting from the available drop-down menus. Columns include:

Name: Column name.
Type: Column data type (as used in the Data Productivity Cloud).
Database Type: Column type (as reported by the database).
Size: Allowable size (in characters) of the data in the column.
Precision: The precision of the data in the column. Will be 0 (zero) for non-applicable types.
Default Value: The default value in this column.
Not Null: Whether or not the column allows null values (Yes/No).
Unique: Whether or not the column is a unique key (Yes/No).

To use grid variables, tick the Use Grid Variable checkbox at the bottom of the Grid Variable Mapping dialog.

Target Table = drop-down

Select the table from which metadata will be taken.

Snowflake	Databricks	Amazon Redshift
✅	❌	❌