JDBC Table Metadata To Grid

JDBC Table Metadata To Grid


This article is specific to the following platforms - Redshift - Snowflake.

JDBC Table Metadata To Grid

The JDBC Table Metadata to Grid component takes the metadata from a JDBC table and uses this data to populate a grid variable with data.

The component can take the following metadata from a JDBC table:

  • Name: the name of the column.
  • Type: column type (as used in Matillion ETL).
  • Size: allowable size (in characters) of data in the column.
  • Precision: the precision of the data in the column. Will be 0 (zero) for non-applicable types.
  • Primary Key: auto-generated keys used to uniquely identify records in the data.
  • Nullable: indicates that NULL values are permissible.
  • Source Type: source type (as used in Matillion ETL).
  • Source Size: the size of the data source.
  • Source Precision: the precision of the source data in the column. Will be 0 (zero) for non-applicable types.

The component can take the following metadata from a JDBC table:

  • Name: the name of the column.
  • Type: column type (as used in Matillion ETL).
  • Size: allowable size (in characters) of data in the column.
  • Precision: the precision of the data in the column. Will be 0 (zero) for non-applicable types.
  • Primary Key: auto-generated keys used to uniquely identify records in the data.
  • Nullable: indicates that NULL values are permissible.
  • Source Type: source type (as used in Matillion ETL).
  • Source Size: the size of the data source.
  • Source Precision: the precision of the source data in the column. Will be 0 (zero) for non-applicable types.

Please Note

When the target table does not exist, the component function is dependent on the database type. Sybase and MySQL return a fail. Other drivers pass with an empty grid returned.



Redshift Properties

Property Setting Description
Name String Input the descriptive name of the component.
Database Type Select Select the type of database to be used. Matillion ETL currently supports the following database types:
Connection URL String Input the connection URL for the chosen database type. The textbox provides a template based on the chosen database type. Users should replace any template information found between < > with their connection URL details.
Username String Enter a valid username to authorise connection to the database.
Password String Enter a valid password to authorise connection to the database. Users can store their passwords within the component; however, Matillion recommends using the Matillion ETL Password Manager feature instead.
Connection Options Parameter A JDBC parameter supported by the Database Driver. The available parameters are determined automatically from the driver, and may change from version to version.
Manual setup is not usually required, since sensible defaults are assumed.
Value A value for the given Parameter.
Schema Select Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on schemas, please see the Azure Synapse documentation.
Table Select Select the table from which metadata will be taken.
Grid Variable Select Select the grid variable to be loaded with data. To learn more about grid variables read our Grid Variables documentation.
Grid Variable Mapping Multiple Selection Map each column in the grid to a particular "type" of metadata by selecting from the available dropdown menus. Columns include: Column Name, Column Type, Size, Precision, Allow Nullable.

Snowflake Properties

Property Setting Description
Name String Input the descriptive name of the component.
Database Type Select Select the type of database to be used. Matillion ETL currently supports the following database types:
Connection URL String Input the connection URL for the chosen database type. The textbox provides a template based on the chosen database type. Users should replace any template information found between < > with their connection URL details.
Username String Enter a valid username to authorise connection to the database.
Password String Enter a valid password to authorise connection to the database. Users can store their passwords within the component; however, Matillion recommends using the Matillion ETL Password Manager feature instead.
Connection Options Parameter A JDBC parameter supported by the Database Driver. The available parameters are determined automatically from the driver, and may change from version to version.
Manual setup is not usually required, since sensible defaults are assumed.
Value A value for the given Parameter.
Schema Select Select the table schema. The special value, [Environment Default], will use the schema defined in the environment. For more information on schemas, please see the Azure Synapse documentation.
Table Select Select the table from which metadata will be taken.
Grid Variable Select Select the grid variable to be loaded with data. To learn more about grid variables read our Grid Variables documentation.
Grid Variable Mapping Multiple Selection Map each column in the grid to a particular "type" of metadata by selecting from the available dropdown menus. Columns include: Column Name, Column Type, Size, Precision, Allow Nullable.