Adding a dataset from your Snowflake connection (EAP) - Cloud

Talend Cloud Data Inventory with Snowflake Getting Started Guide

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Data Inventory
Talend Data Preparation
Talend Pipeline Designer
Content
Data Governance

Now that everything is set up, you are ready to start importing your Snowflake tables as datasets in the inventory.

When starting your Talend Cloud Data Inventory trial, a Snowflake connection is automatically created. The Snowflake connection is a JDBC type connection and contains the information to connect to your datastore. Based on this connection, you will be able to retrieve several, or all the tables and views contained in one of your Snowflake databases, in a single operation.

A step by step menu opens to help you configure your first import in a few clicks.

About this task

You can add dataset from Snowflake on AWS, GCP and Microsoft Azure.

Procedure

  1. To start importing Snowflake tables and views as inventory datasets, click Let's go.
  2. From the Snowflake databases list, select the one containing the tables or views that you want to import and click Next.
    You can also test this process with the PC_TALEND_DB database, a demo database with several tables to import as datasets.
  3. Use the search field and the Type drop-down list to explore the content of the database and select the check boxes corresponding to the objects to import, and click Next.
  4. Select the check box corresponding to the warehouse to use for the import process.
    The PC_TALEND_WH warehouse that has been created during the trial setup can be used for this purpose.
  5. To start the import process, click Nice work, go!.

Results

Your tables and views are progressively retrieved and added to the Datasets list. The Talend Trust Score™ of each dataset is calculated when their samples becomes available. You are now ready to start looking into the details of your Snowflake datasets.

If you want to import more tables or views from other Snowflake databases, you can relaunch this import menu anytime with the Add from Snowflake button and repeat this process for an other database.

Aside from Snowflake, Talend Cloud Data Inventory offers connectivity to a wide range of environments or systems such as file systems or cloud platforms, see the Talend Cloud Connectors Guide for more information.

If you want to get more familiar with the key elements and features of the application, you can access a quick overview any time by clicking your user name in the header menu and selecting Guided tour.