Table Metadata To Grid
Table Metadata To Grid
This component will take the metadata from a table and use this data to populate a grid variable with data. The component can take the following metadata from a table:
- Name: Column Name.
- Type: Column 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.
- Encoding: The name of the encoding type used on this column.
- Name: Column Name.
- Type: Column 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: Column Name.
- Type: Column Type (as used in Matillion ETL).
- Mode: Field mode. Can be NULLABLE, REQUIRED or REPEATED (Columns in BigQuery are NULLABLE by default)
Properties
| Property | Setting | Description |
|---|---|---|
| Name | Text | The descriptive name for the component. |
| Database | Select | Select the database in which to find the table to take metadata from. |
| Schema | Select | Select the schema in which to find the table to take metadata from. |
| Project | Select | Select the project in which to find the table to take metadata from. |
| Dataset | Select | Select the dataset in which to find the table to take metadata from. |
| Table Name | Select | The name of the table from which metadata will be taken |
| Grid Variable | Select | The name of the grid variable to be filled with data. To learn more about grid variables, see the documentation. |
| Grid Variable Mapping | Multiple selection | Map each column in the grid to a particular type of metadata; Name, Type, Database Type, Size, Precision or Encoding |