Contents x
JDBC Table Metadata To Grid
  • Dark
    Light
Contents

JDBC Table Metadata To Grid

  • Dark
    Light

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.

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.


Properties

Snowflake Properties

Property Setting Description
Name String A human-readable name for the component.
Database Type Select A dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
Connection URL String Input the connection URL for the chosen database type. The text box 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, or use the Matillion ETL Password Manager 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, because sensible defaults are assumed.
Value A value for the given parameter.
Schema Select Select the table schema.
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 Grid Variables.
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:
  • 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.
  • Allow Null: Select whether the column will allow NULL values.

Redshift Properties

Property Setting Description
Name String A human-readable name for the component.
Database Type Select A dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
Connection URL String Input the connection URL for the chosen database type. The text box 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, or use the Matillion ETL Password Manager 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, because sensible defaults are assumed.
Value A value for the given parameter.
Schema Select Select the table schema.
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 Grid Variables.
Grid Variable Mapping Multiple Selection Map each column in the grid to a particular "type" of metadata by selecting from the available menus. Columns include:
  • 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.
  • Allow Nullable: Select whether the column will allow NULL values.

BigQuery Properties

Property Setting Description
Name String A human-readable name for the component.
Database Type Select A dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
Connection URL String Input the connection URL for the chosen database type. The text box 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, or use the Matillion ETL Password Manager 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, because sensible defaults are assumed.
Value A value for the given parameter.
Schema Select Select the table schema.
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 Grid Variables.
Grid Variable Mapping Multiple Selection Map each column in the grid to a particular "type" of metadata by selecting from the available menu. Columns include:
  • Name: The name of the column.
  • Type: Column type (as used in Matillion ETL).
  • Mode: Set the mode. For more information, read Modes.
  • 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.

Synapse Properties

Property Setting Description
Name String A human-readable name for the component.
Database Type Select A dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
Connection URL String Input the connection URL for the chosen database type. The text box 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, or use the Matillion ETL Password Manager 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, because sensible defaults are assumed.
Value A value for the given parameter.
Schema Select Select the table schema.
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 Grid Variables.
Grid Variable Mapping Multiple Selection Map each column in the grid to a particular "type" of metadata by selecting from the available menus. Columns include:
  • 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.
  • Allow Nullable: Select whether the column will allow NULL values.

Delta Lake Properties

Property Setting Description
Name String A human-readable name for the component.
Database Type Select A dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
Connection URL String Input the connection URL for the chosen database type. The text box 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, or use the Matillion ETL Password Manager 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, because sensible defaults are assumed.
Value A value for the given parameter.
Schema Select Select the table schema.
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 Grid Variables.
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:
  • 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.
  • Allow Null: Select whether the column will allow NULL values.
What's Next

Cookie consent

We use our own and third-party cookies to understand how you interact with our knowledge base. This helps us show you more relevant content based on your browsing and navigation history.