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, select the Use Grid Variable checkbox at the bottom of the dialog. For more information, read grid variables.
Target Table = drop-down
Select the table from which metadata will be taken.
Catalog = drop-down
Select a Databricks Unity Catalog. The special value, [Environment Default], will use the catalog specified in the Data Productivity Cloud environment setup. Selecting a catalog will determine which databases are available in the next parameter.
Schema (Database) = drop-down
Select the Databricks database. The special value, [Environment Default], will use the database specified in the Data Productivity Cloud environment setup.
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, select the Use Grid Variable checkbox at the bottom of the dialog. For more information, read grid variables.
Target Table = string
Choose the table from which metadata will be taken.
Schema = drop-down
The Amazon Redshift schema. The special value [Environment Default] uses the schema defined in the environment. Read Schemas to learn more.
For more information on using multiple schemas, read Schemas.
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.
- Encoding: The encoding used for the column (e.g., UTF-8).
- Primary Key: Whether or not the column is a primary key (Yes/No).
- Allow Null: Whether or not the column allows null values (Yes/No).
To use grid variables, select the Use Grid Variable checkbox at the bottom of the dialog. For more information, read grid variables.
Target Table = string
Choose 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!