Set up a Snowflake Data Exchange destination to share data directly from your Singular account to a Snowflake account.
- Singular data destinations are a premium feature (learn more).
- This data destination uses the Snowflake Data Share feature. It doesn't require granting Singular access to your Snowflake account.
- Singular also offers a direct Snowflake data destination which can push data directly to your Snowflake database (and requires providing Singular with write access to a Snowflake database).
1. Add a Snowflake Data Exchange Destination
In Singular, add a data destination for Snowflake as follows:
- In your Singular account, go to Settings > Data Destinations and click Add a new destination.
Type in "Snowflake Data Exchange".
In the window that opens, fill in the relevant details:
Field Description Snowflake Account Your Snowflake account name. You can find it in your database URL, e.g., if the URL is https://myaccount.snowflakecomputing.com/, the account name is myaccount. Schema Name Enter a name for the schema that Singular is going to create in the database. The default value is "singular". Table Name Enter a name for the table that Singular is going to write to. The default value is "marketing_data". Data Schema The schema of the data loaded into the destination. See Data Destination (ETL) Schemas.
2. Accept the share in Snowflake
To accept the share in your Snowflake account:
Switch to the ACCOUNTADMIN role:
Open the Shares section and find the entry by Singular:
Click Create Database From Secure Share:
- Enter a name for the database and grant access to specific roles, and then click Create Database.
- To see your marketing data, go to Singular > MARKETING_DATA: