Start exploring your data with Facet

Create your first workspace: Snowflake

It is fast and easy to create a new Snowflake workspace in Facet. To start, you will need to have the connection information detailed in Connect Your Data: Snowflake

Navigate to the "New Workspace" panel

In the settings dropdown on the top right of your screen, select "Switch Workspace"

At the bottom of your workspace list, click the "+New workspace" link to go to the workspace creation panel.

Workspace

The first page in the workspace creation panel is the "Workspace" page. In the "Workspace" page, enter the following:

  • Workspace Name: Friendly name for your workspace. This is the name that will appear in your workspace list.
  • Slug: URL for your workspace, e.g. app.facetdata.com/workspaces/company_click_data

Click "Create New Workspace" and you will see a confirmation that your workspace has been created, then click "Next".

Database

The next page in the workspace creation panel is the "Database" page. Here you will specify what database you are connecting to (in this case, Snowflake) and the credentials you are using. Click "+Create New Database" and enter the following:

  • Database Name: Friendly name for your database within Facet. This does not have to match your database name in Snowflake.
  • Database Type: Select "Snowflake"
  • Credentials: Click "+Create New Key"
  • Enter User Name and Password and click "+Add Credentials" to save the credentials
  • Account: Your Snowflake account name, as seen in your Snowflake URL
  • Snowflake Database: Database name in Snowflake
  • Warehouse: Name of Snowflake warehouse you would like to use
  • Role: Name of role for above user

Click "Create" and you will see a confirmation that your database connection information has been saved, then click "Next".

Dataset

The third page in the workspace creation panel is the "Dataset" page. Here you will choose the specific table in your database that you'd like to explore. Click "+Create New Dataset" and enter the following:

  • Dataset Name: Friendly name for your dataset within Facet. This does not have to match your table name in Snowflake.
  • Database Name and Database Type: These are autopopulated from the database information.
  • Snowflake Schema: Name of schema in Snowflake that you would like to connect to
  • Table Name: Name of table in Snowflake that you would like to connect to
  • Timestamp Field: The main timestamp field in your table. This will be "x-axis" for your graphs in Facet.
  • Minimum Granularity: The minimum granularity that is available/that you would like to see in Facet. (typically this is "Hourly")

Click "Create" and you will see a confirmation that your dataset has been created, then click "Next".

Dimensions

The next page is your "Dimensions" page, where you will choose which dimension values will appear on your workspace. To start, click "+Look for Suggestions".

The panel will automatically pull dimensions from your data model, allowing you to select those which you'd like to see.

Select your dimensions, check at least one dimension as default, and hit "Next".

Check out Setting workspace dimensions for best practices on selecting dimensions.

Metrics

The last page is your "Metrics" page, where you will choose which metrics will appear on your workspace. To start, click "+Look for Suggestions".

The panel will automatically pull metrics from your data model, along with a best guess for how to aggregate them, allowing you to select those which you'd like to see.

Select your metrics, check at least one metric as default, and your workspace is ready to go. Click "Go to workspace" and start exploring your data.

Check out Setting workspace metrics for best practices on selecting, calculating, and formatting metrics.

Updated 27 days ago


What's Next

Next, best practices for setting your dimensions for your Facet workspace. All set with dimensions? Skip ahead to see how to calculate the perfect metrics.

Setting workspace dimensions
Setting workspace metrics

Create your first workspace: Snowflake


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.