Data Clean Room—Working with connections

Premium
For:
Marketers
Last update:

At a glance: Connect your cloud services to the Data Clean Room in order to upload data and receive reports.

Overview

Once you have set up your cloud services for use with the Data Clean Room (DCR), the next step is to connect them to the DCR. 

  • The connections from which the DCR reads first-party data from your systems are called inbound connections. You use these connections when setting up your custom data sources.
  • The connections through which the DCR delivers reports after processing are called outbound connections. You use these connections when setting up your reports.

Creating inbound connections

You can choose to create inbound connections either:

  • Before using them to create sources; or
  • As part of the source creation process.

Either way, the process is the same, and you can use the created connections in exactly the same way. The only difference is the timing and the way you initiate the process.

To create a new inbound connection outside the source creation process:

  1. From the top of the main DCR page in AppsFlyer, click the Manage connections button:

    dcr_manage_connections_button.png

    • If you have existing inbound connections in your account, you'll see the Manage connections dialog. From there, click the dcr_new_connection_button.png button to open the New connection dialog.
    • If you are creating your account's first inbound connection, the New connection dialog will open automatically.
  2. Continue with the instructions in the Complete the connection section, below.

To create a new inbound connection as part of the source creation process:

  1. Create the connection while you are specifying the source location.
    • If there are no connections defined in your account, the New connection dialog will open, prompting you to create one.
    • If you have existing connections but want to use a new one, click the dcr_new_connection_button.png button to open the New connection dialog.
  2. Continue with the instructions in the Complete the connection section below.

Complete the connection

From the New connection dialog, select the cloud service you are connecting to the DCR, then continue with the instructions from the relevant tab below.

dcr_create_inbound_connection.png

BigQuery

In the New connection dialog, enter the BigQuery project ID for the project that contains your custom data source.

  • You can get this information from the Big Query page of your Google Cloud Console.

    BQ_project_ID.png

Snowflake

In the New connection dialog, enter the Snowflake account ID and region for the account that contains your custom data source. You can get this information by clicking on the account name at the bottom-left menu of your Snowflake console:

ui-snowsight-account-identifier.png

Amazon S3 and GCS

In the New connection dialog, enter the name of the bucket you created for the exclusive use of the DCR.

Creating outbound connections

The DCR delivers reports to your selected cloud services using AppsFlyer Data Locker. Because reports are delivered via Data Locker, outbound DCR connections are actually Data Locker connections. You can choose to create these connections either:

  • Before using them to create reports (starting from the Data Locker page in AppsFlyer); or
  • As part of the report creation process (starting from the DCR page in AppsFlyer).

Either way, the process is largely the same, and you can use the created connections in exactly the same way. 

 Note

Receiving DCR reports does not require a premium subscription to Data Locker. If you are interested in receiving other AppsFlyer reports via Data Locker, contact your CSM or send an email to hello@appsflyer.com.

To create a new outbound connection outside the report creation process:

  1. From the AppsFlyer left-side navigation menu, select Report > Data Locker.
    • If you have existing Data Locker connections in your account, you'll be taken to the main Data Locker page. From there, click the dcr_dl_new_connection_button.png button in the upper-right corner to open the New connection dialog.
    • If you are creating your account's first Data Locker connection, you'll see Data Locker's Get started page. Click the dcr_dl_get_started_button.png button to open the New connection dialog.
  2. Continue with the instructions in the Complete the connection section below.

To create a new outbound connection as part of the report creation process:

  1. Create the connection while you are setting the report destination.
    • If there are no connections defined in your account:
      • A new tab will open in your browser (showing the AppsFlyer Data Locker page)
      • A New connection dialog will open.
    • If you have existing connections but want to use a new one, click the dcr_new_connection_data_locker_button.png button:
      • A new tab will open in your browser (showing the AppsFlyer Data Locker page)
      • A New connection dialog will open.
  2. Continue with the instructions in the Complete the connection section, below.
  3. After creating the connection, return to the DCR tab in your browser and select the newly created connection from the list of Data Locker connections.

Complete the connection

 Important!

The AppsFlyer AWS Bucket option should not be used for DCR reports.

From the New connection dialog, select the cloud service you are connecting to, then continue with the instructions from the relevant tab below.

dcr_dl_new_connection_dialog.png

BigQuery

  1. In the New connection dialog, enter a name for the connection; then select the BigQuery option.
  2. Enter the Project ID and Dataset name for the BigQuery project that contains the dataset you created for Data Locker.
    • You can get this information from the Big Query page of your Google Cloud Console.

      BQ_project_ID_dataset_name.png

  3. Click the dcr_dl_test_connection_button.png button to ensure that Data Locker is connected to the dataset.
  4. Click Save to create the connection.

Snowflake

The procedure for connecting Snowflake to Data Locker is a 2-step process:

  • Step #1 – In AppsFlyer, create the initial connection.
    • This gives your Snowflake account the ability to access an AppsFlyer Snowflake share. 
  • Step #2 – In your Snowflake account, create a database from the share.
    • This creates a database in your account that references the tables in the AppsFlyer share.

Note: The following procedure must be performed by a Snowflake Accountadmin.

Step #1 (create the initial connection) – 

  1. In the New connection dialog, enter a name for the connection; then select the Snowflake option.
  2. Enter your Snowflake account region and account ID.
    • You can get this information by clicking on the account name at the bottom-left corner of your Snowflake console, then hovering over the account name in the popup. Important! Look for the ID labeled Locator. This is NOT the same ID as the one used to create inbound Snowflake connections.

      snowflake_account_locator.png

  3. Click the dcr_dl_test_connection_button.png button to ensure that Data Locker is connected to your Snowflake account.
  4. Click Save to create the connection.

Step #2 (create a database from share) – 

  1. Log in to your Snowflake account.
  2. Switch your role to Accountadmin.
  3. From the left-side panel, select Private Sharing.
  4. In the page that opens, select the Shared With You tab.
  5. From the share whose name begins with APPSFLYER, click the Get data snowflake_get_data_button.png button.
  6. [Optional] In the Get Data dialog, change the default database name according to your needs and select the roles in addition to Accountadmin that can access the database.
  7. Click Get Data to create the database.

Amazon S3 and GCS

  1. In the Data Locker New connection dialog, enter a name for the connection; then select either the Amazon S3 or GCS option.
  2. Enter the name of the bucket you created for the exclusive use of DCR.