Snowflake

Facet is an exploratory analytics platform that makes data analytics a team sport. Let the Facet team make a custom workspace on top of your Snowflake data, and see the power of Facet firsthand. All you need to get started are your Snowflake connection details.

Requirements

You'll want the following on hand to get started:

  • Snowflake account name (this appears in your Snowflake URL, ACCOUNT_NAME.snowflakecomputing.com)
  • Database name, Schema name, and Table name for the Snowflake table you would like to visualize
  • Login username, password, and user role
  • Warehouse name you'd like us to use

Though you can use an existing warehouse and user, we recommend that you set up a new warehouse, user role, and user for exclusive Facet use.

Need help? Check out the full guide to creating a new user login and warehouse in Snowflake.

Sign Up

If you already have an account, you can skip this section

  • Navigate to our sign up page
  • Sign up with your Google account, or create an account with your email
    • If you log in using email, be sure to verify your email address via our confirmation email
  • Once logged in, ensure that you have your Company Name set up in Account Settings

📘

Account Settings > Company Name

Facet requires a verified email address (either via Google log-in or email verification) and a Company Account to create a workspace.

If a member of your company has already created your company account, you will be added to it automatically and will not have to create a new one. You can see your Account Settings here.

Add Connection Details

  • To get started, click the workspace dropdown, and click "+ Create New Workspace"
  • In the Create New Workspace flow:
    • Enter a Workspace Name and URL
    • Click Next
  • Click "+ Create New Database" to open the database creation panel— fields will appear as you enter the following:
    • Database Name (internal name, does not need to match database name in Snowflake)
    • Database Type, select Snowflake
    • Account, your Snowflake account name (this appears in your Snowflake URL, ACCOUNT_NAME.snowflakecomputing.com)
    • Snowflake Database, database name in Snowflake
    • Warehouse, warehouse name in Snowflake
    • Role, role name in Snowflake
    • Click the "+" button to add new credentials
      • Enter User Name and Password
      • Directly beneath your new credentials, click "Save" to add credentials to your account
  • Click Save and then Next
  • Click "+ Create New Dataset" to open the dataset creation panel:
    • Dataset Name (internal name, does not need to match name in Snowflake)
    • Snowflake Schema, schema name in Snowflake
    • Table Name, table name in Snowflake
    • Timestamp Field, main timestamp column in your table
    • Minimum Granularity, granularity available in your timestamp
  • Click Save

Let us do the rest!

Reach out to your Facet account lead, and we'll get a flexible, robust analytics layer delivered to your desk within 24 hours. Some extra details that will help us fine-tune your workspace to be as useful as possible:

  • What are your top 5-10 metrics, and how do you define them? (e.g. is video completion rate VIDEO_COMPLETE/VIDEO_0 or VIDEO_COMPLETE/IMPRESSIONS)
  • What are common analytics questions that your team has to answer daily?
  • What are less common analytics questions that you currently find difficult to answer with your available dashboards?

Did this page help you?