Set up the Openflow Connector for Meta Ads¶

As an Openflow administrator, perform the following tasks to set up your Snowflake account. With the default SNOWFLAKE_MANAGED authentication strategy, the runtime’s execute-as role is the identity the connector uses to access Snowflake, so you grant it the following privileges.

Create database, schema, and warehouse¶

1. Create the destination database:

   Copy code

   USE ROLE OPENFLOW_ADMIN;
   CREATE DATABASE IF NOT EXISTS <destination_database>;
   

2. Create the destination schema:

   Copy code

   CREATE SCHEMA IF NOT EXISTS <destination_database>.<destination_schema>;
   

3. Grant the required privileges to the runtime’s execute-as role:

   Copy code

   GRANT USAGE ON DATABASE <destination_database> TO ROLE OPENFLOW_<RUNTIME_NAME>_EXECUTE_AS_RL;
   GRANT USAGE ON SCHEMA <destination_database>.<destination_schema> TO ROLE OPENFLOW_<RUNTIME_NAME>_EXECUTE_AS_RL;
   GRANT CREATE TABLE ON SCHEMA <destination_database>.<destination_schema> TO ROLE OPENFLOW_<RUNTIME_NAME>_EXECUTE_AS_RL;
   

4. Create a warehouse (or use an existing one) and grant usage privileges:

   Copy code

   CREATE WAREHOUSE IF NOT EXISTS <openflow_warehouse>
     WITH
     WAREHOUSE_SIZE = 'XSMALL'
     AUTO_SUSPEND = 300
     AUTO_RESUME = TRUE;
   
   GRANT USAGE, OPERATE ON WAREHOUSE <openflow_warehouse> TO ROLE OPENFLOW_<RUNTIME_NAME>_EXECUTE_AS_RL;
   

5. If any other Snowflake users require access to the tables ingested by the connector (for example, for custom processing in Snowflake), grant those users the execute-as role.

To install the connector, do the following as a data engineer:

1. Navigate to the Connector library tab in Openflow.

2. On the Openflow connectors page, find the connector and select Install.

3. In the Select runtime dialog, select your runtime from the Available runtimes drop-down list and click Install.

   Note

   Before you install the connector, ensure that you have created a database and schema in Snowflake for the connector to store ingested data.

4. Authenticate to the deployment with your Snowflake account credentials and select Allow when prompted to allow the runtime application to access your Snowflake account. The connector installation process takes a few minutes to complete.

5. Authenticate to the runtime with your Snowflake account credentials.

The Openflow canvas appears with the connector process group added to it.