The Table Metadata to Grid orchestration component lets you 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
Google BigQuery
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, toggle Use Grid Variable on 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, toggle Use Grid Variable on at the bottom of the dialog. For more information, read Grid variables. Enter 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, toggle Use Grid Variable on at the bottom of the dialog. For more information, read Grid variables. Enter the table from which metadata will be taken.
The Google Cloud project that owns the BigQuery dataset. The special value [Environment Default] uses the Google Cloud project defined in the environment. For more information, read Creating projects. The Google BigQuery dataset containing the table to query. The special value [Environment Default] uses the dataset defined in the environment.
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: The Google BigQuery type name of the column.
- Mode: Whether the column is nullable, required, or repeated.
Click the Text mode toggle at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, toggle Use Grid Variable on at the bottom of the dialog. For more information, read Grid variables. Select the table from which metadata will be taken.
