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] 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.
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 |
|---|---|---|
| ✅ | ❌ | ❌ |
Got feedback or spotted something we can improve?
We'd love to hear from you. Join the conversation in the Documentation forum!