Snowflake

This Integration requires Fides Cloud or Fides Enterprise. For more information, talk to our solutions team. (opens in a new tab)

Snowflake (opens in a new tab) is a cloud-based data platform that provides a highly scalable and fully managed solution for storing, processing, and analyzing large volumes of structured and semi-structured data.

Prerequisites Permalink for this section

In order to integrate with Snowflake, you'll need to collect the following information from the database administrator:

• Account name: The unique identifier for your Snowflake account.
• Username: The username for your Snowflake account.
• Password: The password associated with the Snowflake account user.

You may optionally configure the following information:

• Warehouse: The name of the Snowflake warehouse where your queries will be executed. If not provided, Snowflake will use the default warehouse.
• Database: The name of the Snowflake database you want to connect to. If not specified, Snowflake will use the default database.
• Schema: The name of the Snowflake schema within the selected database. If not provided, the default schema will be used.
• Role: The Snowflake role to assume for the session. If not specified, the default role for the user will be used.

Integrating with Snowflake Permalink for this section

To integrate an existing system with Snowflake:

1. Navigate to Data map → View Systems and choose the system that you want to connect to
2. Click on the Integrations tab.
3. Pick the vendor or system type that you want to integrate with from the Connection type drop-down menu.
4. Complete the required fields for the integration and click Save.

You may confirm your connection is working using the Test connection button, if desired.

To learn more, please see our guide for Managing Integrations.

Configuring a Dataset Permalink for this section

A dataset is required to configure an integration to this database. A dataset is a configuration file that tells Fides how to query and update data in the database. To learn more about how to create and manage datasets, please see our Managing datasets guide.

An example Snowflake dataset can be viewed in Github (opens in a new tab)

Dataset Namespace Permalink for this section

Snowflake datasets support namespaces. This means that the dataset can contain the database name and schema that will be used when accessing or masking data from a given Snowflake table. If namespace information is not included, the dataset will use the default database name and schema from the associated integration.

dataset:
  - fides_key: snowflake_example_test_dataset
    name: Snowflake Example Test Dataset
    description: Example of a Snowflake dataset containing a variety of related tables like customers, products, addresses, etc.
    fides_meta:
      namespace:
        database_name: STORE
        schema: public
    ...

[PostgreSQL](/content/docs/integrations/databases/postgresql "PostgreSQL"/index.html) [Index](/content/docs/integrations/databases "Index"/index.html)