Install Match

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 documentation.

Snowflake will email your account administrator when a private listing is 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, go to Catalog > Apps, then in the Recently shared with you section, select the listing tile.
  • Select Security to view the privileges and logging requests for the app, including:
    • Account-level privileges
    • Privileges on objects
    • Connections
    • App events
  • Click 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. If you'd like to rename the app later, you can use the Options menu. Rename from the default and note the app name you have chosen, as you will need it in subsequent steps. Please ensure the name you create in this step matches the name you provided to dentsu when you had requested access to the app. As a reminder, the default name for this application is DENTSU_COMPOSABLE_MATCH_APP.
  • Select the warehouse where you want to install the app.
  • Click Get. Once the app is installed, an automated email from Snowflake will be sent to your account administrator.
    After the app is installed, you will be presented with a screen to grant the application account privileges by clicking the Grant button. If you do not have the proper permissions, you will need to ask an ACCOUNTADMIN to handle this step for you. This can be done via clicking the Grant button or by executing the following as an ACCOUNTADMIN:
GRANT CREATE COMPUTE POOL ON ACCOUNT TO APPLICATION <app name>;

GRANT CREATE WAREHOUSE ON ACCOUNT TO APPLICATION <app name>;

GRANT EXECUTE TASK ON ACCOUNT TO APPLICATION <app name>;

 

Post-installation setup and verification

Set up required application objects

After you have completed installing the app and granted the application account object privileges, run the following setup procedure once to create the account-level objects. This procedure will create the following types of account-level objects for the app to function: 

  • COMPUTE POOL 
  • WAREHOUSES 
  • TASKS 

To create all of the required objects, please run the following command: 
CALL <your_application_name>.app_public.setup_required_objects()

If the procedure was successful, you should receive a message that states Successfully created objects for app.
If the procedure was unsuccessful and you received an error, please contact the Support Team for assistance. 
 

Grant account role to the application role

To support the application's use, assign the application role to the account roles that will use it.
Review the roles in your Snowflake account and assign them appropriately.

Use the following template to assign the appropriate application role permission to the User Role.

USE ROLE <INSTALLER_ROLE>;  

-- Create the consumer account role if it does not exist  
CREATE ROLE IF NOT EXISTS <USER_ROLE>; 

-- Map application roles to account roles  
GRANT APPLICATION ROLE <APPLICATION_NAME>.APP_USER_ROLE to role <USER_ROLE>;

Please review the application README for any additional guidance.

 

Related articles