Skip to content

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.


Grid Variable = drop-down

Select the grid variable to be loaded with data. To learn more about grid variables, read Grid variables.


Grid Variable Mapping = column editor

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 the Data Productivity Cloud).
  • 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, tick the Use Grid Variable checkbox at the bottom of the Grid Variable Mapping dialog.


Target Table = drop-down

Select the table from which metadata will be taken.


Snowflake Databricks Amazon Redshift