Load from Snowflake

TigerGraph Savanna allows you to load data directly from Snowflake. This guide will walk you through the steps to configure and load data from Snowflake into your TigerGraph workspace.

1) Select Source

Once you’ve selected Snowflake, you will be asked to configure the Snowflake data source.

  1. Click on Screenshot 2024 04 17 at 9.36.58 PM to add a new Snowflake data source.

    gcs empty data source

  2. You will need to provide your Snowflake username, Snowflake password, and Snowflake URL.

    snowflake connection details

  3. Once you have those configured, you can select one or more Table and View within the Snowflake account.

  4. Click Connect to fetch the Table(s) and View(s).

    snowflake tables

  5. Click Next to process the Table(s).

2) Configure File

This step lets you view the source details.

  1. The data loading tool will automatically fetch the sample data.

    snowflake sample data

  2. Once you are satisfied with the sample data, click Next to proceed.

3) Configure Map

If you are loading data into a brand new graph, you will be prompted to let our engine generate a schema and mapping for you. Or you can start from scratch. For more details of schema design please refer to Design Schema.

  1. Select Generate the schema only or Generate the schema and data mapping.

    Screenshot 2024 04 17 at 5.55.35 PM

    The schema generation feature is still a preview feature. The correctness and efficiency of the resulting graph schema and mapping could vary.

  2. In the Source column, you can choose the specific column from the data source that you want to map with the attribute.

    config mapping snowflake 1

  3. Use the + button to create a new attribute of the target vertex or edge.

    config mapping 2

  4. Click the Token Function button to configure token functions for the selected source. For more details of configuring token functions, please refer to Token Function.

  5. Click the Quick Map button to quickly map the data source headers to the existing schema attributes.

    quick map snowflake

    1. The Map all to target button aligns existing attribute names with the corresponding data source headers, it won’t introduce new attributes.

    2. The Map all from source button not only aligns existing attribute names with the corresponding data asource headers, but also introduces new attributes based on unmatched data source headers.

    3. The following list shows the mapping status of each attribute. You can manually adjust the mapping by checking the box next to the attribute name.

  6. Click Next to proceed.

4) Confirm

This step will let you confirm the changes made to the schema and the data mapping you created to load the data.

  1. Simply review the Schema to be changed and Data to be loaded lists.

    confirm snowflake

    Please be aware that some schema changes will result in unintentional deletion of the data. Please carefully review the warning message before confirming the loading.

  2. Click on the Confirm button to run the loading jobs and monitor their Status.

    load data snowflake

Next Steps

Next, learn how to use Design Schema, GSQL Editor and Explore Graph in TigerGraph Savanna.

Or return to the Overview page for a different topic.