Overview
After installing and configuring dentsu.Composable Push, you may need to grant the application access to additional tables containing audience data. This article explains how to grant the required access to Snowflake databases, schemas, and tables.
Grant access to objects required by the app
Grant Push access to the database, schema, and tables that contain your audience data.
If you consistently use tables from the same database and schema, you only need to grant SELECT access to each new table after the initial setup. You do not need to repeat the database and schema grants.
Run the following SQL statements using either the <INSTALLER_ROLE> used to install the application or a role that has permission to grant access to the applicable objects.
Replace the following values:
<INSTALLER_ROLE>: Role used to install Push or another role with the required privileges<APPLICATION_NAME>: Name of the installed Push application<consumer_defined_db>: Database containing the audience data<consumer_defined_schema>: Schema containing the audience data<consumer_defined_table>: Table containing the audience data
Template
USE ROLE <INSTALLER_ROLE>; GRANT USAGE ON DATABASE <consumer_defined_db> TO APPLICATION <APPLICATION_NAME>; GRANT USAGE ON SCHEMA <consumer_defined_db>.<consumer_defined_schema> TO APPLICATION <APPLICATION_NAME>; GRANT SELECT ON TABLE <consumer_defined_db>.<consumer_defined_schema>.<consumer_defined_table> TO APPLICATION <APPLICATION_NAME>;
Example
USE ROLE ACCOUNTADMIN; GRANT USAGE ON DATABASE AUDIENCE_DB TO APPLICATION DENTSU_COMPOSABLE_PUSH_APP; GRANT USAGE ON SCHEMA AUDIENCE_DB.SINGLE_ATTR_AUDS TO APPLICATION DENTSU_COMPOSABLE_PUSH_APP; GRANT SELECT ON TABLE AUDIENCE_DB.SINGLE_ATTR_AUDS.AUDIENCE_SUMMER_2026 TO APPLICATION DENTSU_COMPOSABLE_PUSH_APP;
Access to new audience tables
Grant Push SELECT access to each new audience table added after the initial configuration. If the new table uses a database and schema that Push can already access, you do not need to repeat the database and schema grants.