Skip to main content

Configure the Push app

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.