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.
If the target table doesn't exist, the component function is dependent on the database type. Sybase and MySQL return a fail. Other drivers pass with an empty grid returned.
Note
In Snowflake, unquoted object identifiers are resolved as uppercase. Object identifiers encased in double quotes are resolved exactly as entered.
- For example,
tablename
andtableNAME
both resolve toTABLENAME
. - Conversely,
"tablename"
would resolve totablename
.
This means that a table whose name is all uppercase will resolve to uppercase with or without double quotes. It may be preferable to use table names in all uppercase when working with Snowflake.
Read Identifier Resolution for more information.
Properties
Name
= string
A human-readable name for the component.
Database Type
= drop-down
Select the database type. Choose from:
- Amazon Redshift
- IBM DB2 for i
- MariaDB
- Microsoft SQL Server
- Oracle
- PostgreSQL
- Snowflake
- SQL Server (Microsoft Driver)
- Sybase ASE
Connection URL
= string
The URL for your chosen JDBC database.
Although many parameters and options can be added to the end of the URL, it's generally easier to add them in the Connection Options property, documented below.
Username
= string
A valid username for the database connection.
Password
= string
The secret definition representing the password that corresponds to your database user account.
Connection Options
= column editor
- Parameter: A JDBC parameter supported by the database driver. Manual setup is not usually required, since sensible defaults are assumed.
- Value: A value for the given parameter.
To use grid variables, tick the Use Grid Variable checkbox at the bottom of the Connection Options dialog.
Schema
= drop-down
Select a table schema.
Table
= drop-down
Select the table to pull metadata from.
Grid Variable
= drop-down
Drop-down list of grid variables. To learn more, read Grid variables.
Grid Variable Mapping
= multiple drop-downs
Map each column in the grid variable to a particular "type" of metadata by selecting from the available drop-down menus.
To use grid variables, tick the Use Grid Variable checkbox at the bottom of the Grid Variable Mapping dialog.
Snowflake | Databricks | Amazon Redshift |
---|---|---|
✅ | ❌ | ❌ |