JDBC Table Metadata To Grid
    • Dark
      Light

    JDBC Table Metadata To Grid

    • Dark
      Light

    Article Summary

    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

    PropertySettingDescription
    NameStringA human-readable name for the component.
    Database TypeSelectA dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
    Connection URLStringInput 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.
    UsernameStringEnter a valid username to authorise connection to the database.
    PasswordStringEnter 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 OptionsParameterA 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.
    ValueA value for the given parameter.
    SchemaSelectSelect the table schema.
    TableSelectSelect the table from which metadata will be taken.
    Grid VariableSelectSelect the grid variable to be loaded with data. To learn more about grid variables, read Grid Variables.
    Grid Variable MappingMultiple SelectionMap 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

    PropertySettingDescription
    NameStringA human-readable name for the component.
    Database TypeSelectA dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
    Connection URLStringInput 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.
    UsernameStringEnter a valid username to authorise connection to the database.
    PasswordStringEnter 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 OptionsParameterA 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.
    ValueA value for the given parameter.
    SchemaSelectSelect the table schema.
    TableSelectSelect the table from which metadata will be taken.
    Grid VariableSelectSelect the grid variable to be loaded with data. To learn more about grid variables, read Grid Variables.
    Grid Variable MappingMultiple SelectionMap 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

    PropertySettingDescription
    NameStringA human-readable name for the component.
    Database TypeSelectA dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
    Connection URLStringInput 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.
    UsernameStringEnter a valid username to authorise connection to the database.
    PasswordStringEnter 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 OptionsParameterA 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.
    ValueA value for the given parameter.
    SchemaSelectSelect the table schema.
    TableSelectSelect the table from which metadata will be taken.
    Grid VariableSelectSelect the grid variable to be loaded with data. To learn more about grid variables, read Grid Variables.
    Grid Variable MappingMultiple SelectionMap 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

    PropertySettingDescription
    NameStringA human-readable name for the component.
    Database TypeSelectA dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
    Connection URLStringInput 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.
    UsernameStringEnter a valid username to authorise connection to the database.
    PasswordStringEnter 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 OptionsParameterA 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.
    ValueA value for the given parameter.
    SchemaSelectSelect the table schema.
    TableSelectSelect the table from which metadata will be taken.
    Grid VariableSelectSelect the grid variable to be loaded with data. To learn more about grid variables, read Grid Variables.
    Grid Variable MappingMultiple SelectionMap 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

    PropertySettingDescription
    NameStringA human-readable name for the component.
    Database TypeSelectA dropdown menu of databases to choose from. To learn more, read Manage Database Drivers.
    Connection URLStringInput 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.
    UsernameStringEnter a valid username to authorise connection to the database.
    PasswordStringEnter 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 OptionsParameterA 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.
    ValueA value for the given parameter.
    SchemaSelectSelect the table schema.
    TableSelectSelect the table from which metadata will be taken.
    Grid VariableSelectSelect the grid variable to be loaded with data. To learn more about grid variables, read Grid Variables.
    Grid Variable MappingMultiple SelectionMap 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.