Snowflake

This guide provides detailed instructions for setting up and using Data Connect with Snowflake.

Snowflake is a cloud-based data platform that provides data warehouse-as-a-service designed for the cloud. The Data Connect integration with Snowflake allows you to automatically sync your Contentsquare data to Snowflake for advanced analysis and joining with other business data.

Before setting up the Snowflake integration, ensure you have:

• A Snowflake account with appropriate access
• Sufficient permissions to create databases, schemas, and tables
• Snowflake user credentials with appropriate roles

To get started, you need to have the following information about your Snowflake account:

• Your Snowflake account name: Your account name can be found in the URL used to access Snowflake <account_name>.snowflakecomputing.com.

• Your account region: We currently support the following regions:

  AWS:

  • us-west-2 (Oregon): region not included in snowflake URLs for this region only
  • us-east-1 (N. Virginia)
  • us-east-2 (Ohio)
  • eu-west-1 (Ireland)
  • eu-central-1 (Frankfurt)
  • ap-southeast-2 (Sydney)
  • ca-central-1 (Canada Central)

  Azure:

  • east-us-2 (Virginia)
  • west-us-2 (Washington)
  • canada-central (Toronto)
  • west-europe (Netherlands)
  • australia-east (New South Wales)
  • north-europe (Ireland)
  • centralus (Iowa)
  • uksouth (London)

  GCP:

  • us-central1 (Iowa)
  • europe-west4 (Netherlands)

If you are outside of these regions, let us know and we will work to add support for you.

To find this information in your Snowflake account, see the Analysis Setup > Connect > Snowflake page in Contentsquare. This page will only be available once Data Connect has been enabled for you by someone on our end.

1. Log in to Contentsquare.
2. Navigate to Analysis setup > Data Connect.
3. Select Connect next to Snowflake.
4. Create a database in Snowflake by copying and running the generated snippet.
5. Select Next.
6. Enter your Snowflake hostname.
7. Select Next.

• Common Queries for analysis examples
• Snowflake Documentation ↗
• Snowflake Best Practices ↗