Harvesting from Snowflake using the generic JDBC bridge/ Database (via JDBC) bridge - 7.1

author
Talend Documentation Team
EnrichVersion
7.1
EnrichProdName
Talend Metadata Manager
task
Design and Development
EnrichPlatform
Talend Metadata Manager Platform
Talend Metadata Manager Platform Advanced
Talend Metadata Manager Platform Advanced with Authoring

Harvesting from Snowflake using the generic JDBC bridge

Talend Metadata Manager has a broad set of bridges for use in harvesting. However, there will still be times in which a specific bridge is not available for a particular database technology. In those situations, as long as the database will support JDBC connectivity, you can utilize the import bridge from Database (via JDBC).

Creating a new model

You create a new model that connects to a Snowflake database using the Database (via JDBC) bridge.

Procedure

  1. In Metadata Manager, right-click the repository and click New > Model.
  2. In Create Model, enter a name and a description for the model, in this example Harvest Snowflake via JDBC.
  3. In Model Type, select Database (via JDBC) from the drop-down list.
  4. Click Create.

Configuring the bridge import parameters

Procedure

  1. Right-click the newly created model and select Settings.
  2. In the Import Setup tab, configure the import parameters using the Help panel on the right side.
    You can click any parameter to see its full description and an example of the input.
    If you do not put specifics in your URL, you may end up harvesting everything you have access to.
    For more information on Snowflake’s JDBC connectivity, see https://docs.snowflake.net/manuals/user-guide/jdbc-configure.html.
  3. Click Test to confirm connectivity.
  4. Click OK.
  5. In the pop-up window, click Yes to import the model now.
  6. Review any issues or errors using the log and click Close.
  7. Click Yes to open the model.

Results

You can see your database, schema and table details.