Snowflake

Snowflake

Warehouses

Overview

Push your ecommerce data to Snowflake for scalable cloud analytics with automatic scaling and near-zero maintenance.

Setup

  1. 1

    Create a Snowflake account (or use an existing one) with a warehouse, database, and schema.

  2. 2

    Go to Dashboard > Outputs, click Connect on Snowflake, and enter your credentials.

  3. 3

    Data syncs automatically to your Snowflake database.

Fields Required

Account URL

abc123.snowflakecomputing.com

Warehouse

COMPUTE_WH

Database

ECOMMERCE

Schema

PUBLIC

Username

your_user

Password

your_password

Secret

Setup Guide

  1. 1

    Log in to your Snowflake account (or sign up for a trial).

    https://signup.snowflake.com/
  2. 2

    Your Account URL is the full URL you use to log in — find it under Admin > Accounts.

  3. 3

    Go to Admin > Warehouses to find your Warehouse name (or create one — X-Small is fine).

  4. 4

    Go to Data > Databases to find your Database name (or create one, e.g., SMARTECOM).

  5. 5

    Click on your database and use the PUBLIC schema, or create a new one.

  6. 6

    Use your login credentials, or ask your admin to create a dedicated user.

Tips

  • Trial accounts come with a warehouse, database, and schema ready to use.
  • Make sure the user has USAGE privileges on the warehouse, database, and schema.