Skip to main content

Get started

Instacart requires SHA256 for all personally identifiable information (PII) columns.

Before you start​

Before you start, keep in mind the following considerations:

  • Make sure templates have a minimum number of users.
  • Combine query results so individual customer information isn’t revealed.
  • Clean rooms update every two hours but may be unavailable during updates.
  • Keep track of all data access and check it regularly to follow rules.
  • Run small tests with shorter date ranges to confirm your settings work.
  • Choose data summaries that fit what you’re trying to analyze.
  • Take seasonal trends into account when picking date ranges.
  • Contact your Instacart representative if you need custom templates.

Partner Snowflake Account​

If you already have a Snowflake account, you can integrate your account with Instacart Data Hub. You can interface with the dataset through Snowflake Data Clean Rooms: Web app overview or Snowflake Data Clean Rooms developer's guide. With the Snowflake Developer API, you can write SQL to run the templates, schedule analyses, and commit the results into version control.

  1. To find your account information, run the following query:

    select current_organization_name(),current_account_name(),current_account_locator(),current_region();

  2. Take a screenshot of the following Snowflake account information. Any incorrect details or typos can delay setting up the clean room.

    • Organization Name. Your Snowflake organization name.
    • Account Name. Your Snowflake account name.
    • Account Locator. Short account locator in legacy format that does not include the organization name.
    • Region. The cloud region where your account is hosted, such as us-west-2 or us-east-1.
    • Cloud Platform. The cloud provider, such as Amazon Web Service (AWS), Azure, or Google Cloud Platform (GCP).

  3. Provide the screenshot to your Instacart representative or email it to data-hub@instacart.com.

  4. Set up a clean room. For more information, see About Snowflake Data Clean Rooms.

  5. Accept the invitation to join the Partner-Instacart clean room.

  6. Decide on the queries and datasets for analysis. Access to data is subject to the contractual terms and conditions agreed upon between Instacart and the partner, and may be subject to legal review.

Configure the Snowflake environment​

  1. Set up the required role by running the following query:

    use role samooha_app_role;

  2. Configure your warehouse by running the following query:

    use warehouse WAREHOUSE_NAME;

    Ideally, use a large or x-large warehouse size for fast query execution.

  3. Set up your clean room name by running the following query. Replace "CLEANROOM_NAME" with the clean room name provided by Instacart.

    set cleanroom_name = "CLEANROOM_NAME";

Account requirements​

Your Snowflake account must have the following requirements:

  • Role access. Access to the samooha_app_role.
  • Compute resources. A warehouse with sufficient compute resources for query execution.
Last updated on