Connect Single Origin to Snowflake

Create a read-only role and service user that can read Snowflake's metadata views.

Single Origin reads metadata only from your Snowflake account: database, schema, table, view and column information, plus query and usage history. It never reads the contents of your tables.

You connect Single Origin by creating a dedicated read-only role and service user in your own account and granting them access to Snowflake's metadata. The setup is a single SQL script, and nothing leaves your environment.

What you're granting

All metadata Single Origin reads comes from the shared, read-only SNOWFLAKE database that exists in every account. You grant a dedicated role access to it using Snowflake's predefined database roles:

GrantWhat it allows
SNOWFLAKE.OBJECT_VIEWERRead object metadata (databases, schemas, tables, views and columns) from the ACCOUNT_USAGE views.
SNOWFLAKE.USAGE_VIEWERRead query history and usage metadata from the ACCOUNT_USAGE views.
USAGE on a warehouseLets the service user run the metadata queries. This is compute access only; it grants no access to data.

These database roles grant SELECT on ACCOUNT_USAGE views only. They expose schema and usage metadata, never the rows inside your tables.

Confirm the exact roles with your Single Origin contact. OBJECT_VIEWER and USAGE_VIEWER cover schema and usage profiling. If your integration also uses governance metadata (policies, tags) or security metadata (logins, grants), you may also need SNOWFLAKE.GOVERNANCE_VIEWER or SNOWFLAKE.SECURITY_VIEWER. Grant only what's needed.

Before you start

You'll need:

  1. A user with the ACCOUNTADMIN role. Only ACCOUNTADMIN can grant the SNOWFLAKE database roles, because it owns the shared SNOWFLAKE database.
  2. The Single Origin RSA public key for key-pair authentication, from your onboarding email (shown as <SINGLE_ORIGIN_PUBLIC_KEY> below). Paste the key body only. Leave out the -----BEGIN PUBLIC KEY----- and -----END PUBLIC KEY----- lines and any line breaks. Single Origin holds the matching private key; you never share or store it.
  3. The name of a warehouse Single Origin can use to run metadata queries (shown as <YOUR_WAREHOUSE> below). An X-Small or Small warehouse is enough.
  4. Your Snowflake account identifier. Find it in Snowsight under your account menu → View account details.

Choose a method

  1. Sign in to Snowsight with a user that can use the ACCOUNTADMIN role.
  2. Open a new SQL worksheet.
  3. Paste the script from the Full SQL script tab and replace the placeholders with your values.
  4. Run the statements top to bottom.

Finish up

Once the script has run, send your account identifier to your Single Origin contact (or enter it in the onboarding flow). Single Origin connects as SINGLE_ORIGIN_USER and starts reading metadata. No further action is needed on your side.

Revoking access

You can remove Single Origin's access at any time by dropping the role and user. Run as ACCOUNTADMIN:

USE ROLE ACCOUNTADMIN;

DROP USER IF EXISTS SINGLE_ORIGIN_USER;
DROP ROLE IF EXISTS SINGLE_ORIGIN_ROLE;

Dropping the role removes every grant associated with it. Dropping the user ends Single Origin's ability to connect at once.


Did this page help you?