Install the application
Once you have been provisioned by dentsu, the application will be available for you to install. To install the application, you will need the appropriate privileges in your Snowflake Account (ACCOUNTADMIN or similar). For more information on role requirements and account privileges, please read this Snowflake article.
- An email will be sent by Snowflake to your account administrator when a private listing has been shared with you. To access the listing, go to the listing detail page via the link in the email, or navigate to it as outlined below.
- Sign in to Snowsight.
- In the navigation menu, select Catalog > Apps.
- In Recently shared with you, select the tile for the listing.
- Select Security to view the privileges and logging requests for the app, including:
- Account-level privileges
- Privileges on objects
- Connections
- App events
- Select Get. Snowflake takes some time to prepare the app. Once it is ready, another email will be sent to your account administrator.
- Optionally, enter a name for the app. The app name is set by dentsu and changing it is not required. Should you wish to rename the app later, use the Options menu on the pop-up screen. Rename from the default and note the app name you have chosen, as you will need it in subsequent steps.
- Select the warehouse that you want to use to install the app.
- Select Get. Once the app is installed, an automated email from Snowflake will be sent to your account administrator.
- Select Open to view the app or Done to finish.
Post-installation set-up and verification
Verify application installation
Once installed, verify the application's state by running the query below. Replace <application_name> and <INSTALLER_ROLE> with the application name and role used during installation.
USE ROLE <INSTALLER_ROLE>;
SELECT status FROM <application_name>.cleanroom.consumer_status;If the query returns ACTIVE, the application is ready for use. If the query returns any other value, please contact Customer Support.
Grant account role to the application role
To support the use of the application, assign the application role to the account roles that will use it.
Use the following template to create the account roles and assign the appropriate application role permissions to these.
USE ROLE <INSTALLER_ROLE>;
-- Example how consumer role creation
-- Create consumer's account-level roles
CREATE ROLE IF NOT EXISTS consumer_<app_name>_user;
-- Map application roles to account roles
GRANT APPLICATION ROLE <app_name>.dcr_db_role TO ROLE consumer_<app_name>_user;When post-installation setup and verification steps are complete, review the application README for additional guidance on next steps.