It's easy to get started with a new workspace in Facet. Let's have a quick look at the five steps you need to start exploring your data in minutes.
Head over to Facet, open the main dropdown, and click the + Create New Workspace button. Pick a name for your workspace, and the URL you'd like.
Be sure to have your Company Name set up under Account Settings, so we know what account we should associate your workspace to.
Pick the database you'd like to connect to, and add in your connection details. This might be a username/password (for e.g. Snowflake) or a service key (for e.g. BigQuery).
Check out our Available Integrations page for connection options, as well as detailed instructions on where to find the required connection details.
A Facet workspace acts like an interactive layer on top of one table in a database. Pick the table you would like to visualize, and select the main timestamp column that will act as the filter or "x-axis" for your entire workspace.
The column can be of type
Facet will automatically pull all of the columns from the table you chose and populate your dimension list. Any column that isn't of type
float gets pulled in as a dimension.
Dimensions are the attributes that describe your data, and are one of the building blocks of your workspace. Pick the ones you care about most, that are most helpful when you're digging into your data, or just select all of them. Just be sure to choose at least one as a default.
Facet will automatically pull all of the columns of type
float to populate your metrics list. All metrics are set to "sum" by default, but you can easily edit any metric calculation.
Metrics are measurements derived from your data, and you will want to tailor your metrics to reflect your business needs. For example, you might want to see a sum of all Clicks, a count of all unique User IDs, and an average of Bid Amount.
You can add custom metrics with advanced aggregation and filter logic. Check out our guide to creating custom metrics to get started.
If you have any questions, we're always here to help. Just reach out via the Intercom messenger.
Updated 2 months ago
Find your database and what connection details you'll need to get your workspace up and running