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.
Target Table = string
Select the table from which metadata will be taken.
Grid Variable = drop-down
Select the grid variable to be loaded with data. To learn more about grid variables, read our grid variables documentation.
Grid Variable Mapping = column editor
Map each column in the grid to a particular "type" of metadata by selecting from the available dropdown menus. Columns include:
- Name: Column name.
- Type: Column data type (as used in Matillion ETL).
- 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).
Name = string
A human-readable name for the component.
Catalog = drop-down
Select a Databricks Unity Catalog. The special value, [Environment Default], will use the catalog specified in the Matillion ETL environment setup. Selecting a catalog will determine which databases are available in the next parameter.
Database = drop-down
Select the Delta Lake database. The special value, [Environment Default], will use the database specified in the Matillion ETL environment setup.
Table = string
Select the table from which metadata will be taken.
Grid Variable = drop-down
Select the grid variable to be loaded with data. To learn more about grid variables, read our grid variables documentation.
Grid Variable Mapping = column editor
Map each column in the grid to a particular "type" of metadata by selecting from the available dropdown menus. Columns include:
- Name: Column name.
- Type: Column data type (as used in Matillion ETL).
- 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).
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
Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on using multiple schemas, read Schemas.
Table Name = string
Select the table from which metadata will be taken.
Grid Variable = drop-down
Select the grid variable to be loaded with data. To learn more about grid variables, read our grid variables documentation.
Grid Variable Mapping = column editor
Map each column in the grid to a particular "type" of metadata by selecting from the available dropdown menus. Columns include:
- Name: Column name.
- Type: Column data type (as used in Matillion ETL).
- 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).
Name = string
A human-readable name for the component.
Project = drop-down
Select the Google Cloud project. The special value, [Environment Default], will use the project defined in the environment. For more information, read Creating and managing projects.
Dataset = drop-down
Select the Google BigQuery dataset to load data into. The special value, [Environment Default], will use the dataset defined in the environment. For more information, read Introduction to datasets.
Table = string
Select the table from which metadata will be taken.
Grid Variable = drop-down
Select the grid variable to be loaded with data. To learn more about grid variables, read our grid variables documentation.
Grid Variable Mapping = column editor
Map each column in the grid to a particular "type" of metadata by selecting from the available dropdown menus. Columns include:
- Name: Column name.
- Type: Column data type (as used in Matillion ETL).
- 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).
Name = string
A human-readable name for the component.
Schema = drop-down
Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on schemas, read the Azure Synapse documentation.
Table = string
Select the table from which metadata will be taken.
Grid Variable = drop-down
Select the grid variable to be loaded with data. To learn more about grid variables, read our grid variables documentation.
Grid Variable Mapping = column editor
Map each column in the grid to a particular "type" of metadata by selecting from the available dropdown menus. Columns include:
- Name: Column name.
- Type: Column data type (as used in Matillion ETL).
- 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).
| Snowflake | Delta Lake on Databricks | Amazon Redshift | Google BigQuery | Azure Synapse Analytics |
|---|---|---|---|---|
| ✅ | ✅ | ✅ | ✅ | ✅ |