Documentation

Support

Analytics

Analytics

Set up Data Access

Follow this workflow to configure Data Access and share your Analytics data with your Snowflake account.
Read time 1 minuteLast updated 19 hours ago
You can follow this process to share Analytics data to an existing Snowflake account.
  1. Open Analytics in the Unity Dashboard, and select Analytics Settings.
  2. Click Set up Data Access.
  3. Click With an existing account, then select Next.
  4. Enter your account locator and cloud region provider, then select Create.
The Analytics Settings page now displays your Data Access account. To create and to access the database from this share in Snowflake, click the Shares icon in the menu bar. You'll see the share listed in the view. Shares can be viewed by using an SQL command. This lists the shares available for the Snowflake account.

Access your Analytics data in Snowflake

To access the shared data you need to create a database from the share and grant the account admin role for the database:
  1. Select Data Products > Private sharing > Shared with you. Snowflake displays the shares available for your account, including the one you set up in the Unity Dashboard. You can also view shares via the SQL command: 
    SHOW SHARES;
    .
  2. Select the download button on the share you wish to view.
  3. Define the roles you want to allow access to this share, and select Get Data.
This creates a database where you can query the shared data. Alternatively, you can create a database for the share using the following SQL in Snowflake: 
CREATE DATABASE "SFSHARETEST" FROM SHARE UNITYLIVEOPS."UNITY_ANALYTICS_PDA";GRANT IMPORTED PRIVILEGES ON DATABASE "SFSHARETEST" TO ROLE "ACCOUNTADMIN";
To view the created databases in Snowflake, select Data > Databases. Alternatively, you can view the list of databases via the SQL command: 
Show databases;
 To view a list of views and tables within the share, run a 
describe share <sharename>
SQL query in the worksheet. The Origin column in the database table displays the share names. For more information on how to consume Snowflake shared data, refer to the Snowflake documentation.

Useful resources