Dutchie provides data sharing through Snowflake Listings, allowing you to access our datasets directly in your Snowflake environment. This guide walks you through the process of setting up and accessing shared data.
Before you begin
Before getting started, you'll need:
- Your Snowflake account identifier
- Your Snowflake account locator
- Administrative access to your Snowflake account
Step-by-step process
1. Initial setup
Your Customer Success Manager (CSM) will request your Snowflake account details:
- Account identifier
- Account locator
To find these identifiers, log in to your Snowflake account and click at your user profile at the bottom of the screen > Account > View account details (you can view a visual path here). Copy and save data sharing account identifier and account locator. You can also get these values by executing the following query in your Snowflake account:
select current_organization_name() || '.' || current_account_name() as account_name, current_account_locator() as account_locator;
Once provided, Dutchie will grant access to the appropriate data listings for your account.
2. Access notification
You'll receive an email notification once access has been granted to your account. This email will include:
- Confirmation that the listing is available
- A direct link to the listing (no need to search through the marketplace)
3. Adding the data share
- Click Get in the listing interface from the email link
-
Regional Replication (if applicable):
- If your Snowflake account is not in AWS US-East-1, Snowflake will begin preparing the data
- You'll see a message indicating "Snowflake is preparing the data"
- A second email will be sent once data replication is complete
Screenshot showing the listing header during initial replication
4. Final Configuration
- Click Get again once data is ready
-
Configure Database: A popup will appear where you can:
- Specify the database name for the listing
- Configure any additional settings
- Click Get in the popup to complete the setup
5. Getting started
After successful setup, you'll see a final popup with two options:
- Query Data: Opens example queries to help you get started
- Done: Closes the setup and returns you to your Snowflake interface
Next steps
Once the share is configured, you can:
- Query the shared data using standard SQL
- Integrate the data into your existing workflows
- Set up automated processes using the shared datasets
Support
If you encounter any issues during this process, please contact your Dutchie Customer Success Manager or reach out to our support team.