This component will take the metadata from a table and use this data to populate a grid variable with data.
Properties
A human-readable name for the component.
Snowflake
Databricks
Amazon Redshift
The Snowflake schema. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more. Select the grid variable to be loaded with data. To learn more about grid variables, read Grid variables. 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 ).
- 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. Select the table from which metadata will be taken.
Select a Databricks Unity Catalog. The special value, [Environment Default], will use the catalog specified in the environment setup. Selecting a catalog will determine which databases are available in the next parameter. Select the Databricks database. The special value, [Environment Default], will use the database specified in the environment setup.
Select the grid variable to be loaded with data.To learn more about grid variables, read Grid variables. 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 ).
- 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. Choose the table from which metadata will be taken.
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. Select the grid variable to be loaded with data.To learn more about grid variables, read Grid variables. 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 ).
- 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. Choose the table from which metadata will be taken.
