Skip to main content
The Data Connector gives you a read-only Snowflake account that mirrors your ION data, so you can query it from Power BI, Tableau, Looker, Sigma, or any other BI tool. This page walks you through connecting for the first time and building your first dashboard. To set up the Data Connector for your organization, go to Settings > Analytics > Data Connector and complete onboarding. Once enabled, you’ll have your Snowflake connection credentials and admin access to manage users for your team.

​
Connect your BI tool

Every BI tool connects to Snowflake using the same set of credentials, available in Settings > Analytics > Data Connector after onboarding:
  • Account identifier — your Snowflake account URL (for example, xyz12345.snowflakecomputing.com)
  • Username and password
  • Warehouse, database, and schema to use
To connect, open the Snowflake connector in your BI tool and enter the credentials above. The exact steps vary by tool: Once connected, you can browse the available tables directly from your BI tool’s data pane.

​
Build your first dashboard

The fastest way to build a useful dashboard is to start with a Data Product rather than the raw tables. Data Products are pre-joined, pre-aggregated views maintained by First Resonance. A good starting point for most teams:
  1. In your BI tool, open the Snowflake connection and browse to the schema.
  2. Find the computed tier — these are the Data Products (for example, issue_details, build_status, inventory_health).
  3. Drag in the table that matches your question. For a quality dashboard, start with issue_details. For a production overview, start with build_status.
  4. Add filters for date range, team, or part as needed.
  5. Build your chart or table from the columns available.
For the full list of Data Products and what each one contains, see Data Products. If no Data Product fits your question, you can query the raw or cleaned (_enriched) tables directly. See Available Tables for the full catalog.

​
What USERADMIN can do

First Resonance provisions one user per organization with the USERADMIN role in Snowflake. This role exists so your team can manage additional users in the Data Connector independently, without opening a support ticket for every new analyst or BI developer who needs access. As USERADMIN you can:
  • Create users — provision a Snowflake user for each analyst or BI service account in your organization.
  • Grant the reader role — assign the read-only role First Resonance provisions so new users can query all Data Connector tables.
  • Reset passwords — handle credential rotation for your organization’s users without involving First Resonance.
  • Deactivate users — remove access when someone leaves the team.
USERADMIN does not grant the ability to modify table definitions, create tables, write data, or change First Resonance’s provisioned roles. The Data Connector is strictly read-only. For Snowflake SQL reference, see:

​
What you don’t need USERADMIN for

Most work in the Data Connector doesn’t require elevated permissions. A standard read-only user can:
  • Query any table or Data Product — all tables in the Data Connector are readable by any user with the reader role.
  • Build dashboards and reports in any connected BI tool — the BI tool handles visualization; Snowflake just serves the data.
  • Write queries and views in your BI tool’s layer — Power BI measures, Tableau calculated fields, Looker LookML, and Sigma formulas all live in your BI tool, not in Snowflake, so they don’t require any Snowflake permissions beyond read access.
  • Export data — select and download query results from the Snowflake web UI or your BI tool without any additional grants.
You only need USERADMIN when you’re managing who has access to the Data Connector, not when you’re using it.