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