Set up Data Access#

You can follow this process to share Analytics data to an existing Snowflake account.

1. Open Analytics in the Unity Cloud 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 Cloud 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#

• A list of views available through data access is listed on the Data Access available views page.
• Snowflake documentation on a BI tooling solution that natively supports Snowflake.
• Snowflake documentation on an ETL and data transformation tools that natively support Snowflake.