Skip to main content

Export Results to a Cloud

You can set up an export of results to an outside cloud location, like an AWS S3 location or GCS. See the articles in this section for specific configuration steps by cloud platform.

Not all clean room types support exports and whether exports are supported depends on the export location. For those clean room types that support exports, some support both analytical results and list results, while others only support analytical results. For detaile information, see the "Supported Clean Room Types" section below.

Analytical results are exported as Parquet files.

By default, list results are exported as Parquet files but you can request that list results be exported as CSV files for your account by contacting your LiveRamp representative.

Supported Clean Room Types

For more information on the clean room types supported for each export destination connection, see the table below.

Export Destination Connection Name

Credential Type

Export TIming

Clean Room Type

Industry Clean Rooms (ADH, AMC, and FAA)

Hybrid

Confidential Computing

Snowflake

Google Cloud BigQuery

Amazon Web Services

Databricks

S3 IAM Role Export

AWS S3 Credential

Export completed at runtime

Not supported

Both Analytical and List Results

Both Analytical and List Results

Not Supported

Not Supported

Not Supported

Not Supported

GCS Export

Google Service Account

Export completed at runtime

Not supported

Both Analytical and List Results

Both Analytical and List Results

Not Supported

Not Supported

Not Supported

Not Supported

Azure Export

Azure AD Service Principal

Export completed at runtime

Not supported

Both Analytical and List Results

Both Analytical and List Results

Not supported

Not supported

Not supported

Not supported

S3 Export

AWS IAM User Credentials

Export completed in batch (AM UTC)

Only Analytical

Not supported

Not supported

Both Analytical and List Results

Not Supported

Not Supported

Not Supported

BigQuery Export

Google Service Account

Export completed in batch (AM UTC)

Only Analytical

Not supported

Not supported

Only Analytical

Not Supported

Not Supported

Not Supported

Note

  • LinkedIn clean rooms have the same export functionality as Confidential Computing clean rooms.

  • Check with your LiveRamp representative for information on generally available features relevant to your particular collaborations. Export options will vary by pattern, collaboration, permissions, and cloud.

  • LiveRamp does not have access to the results from Google Cloud BigQuery, Amazon Web Services, and Databricks clean rooms and so results cannot be exported from those clean room types.

  • LiveRamp does not have access to the results from Snowflake clean rooms, but those results can be exported to AWS S3 or BigQuery by sharing the question results with LiveRamp. For more information, see "Export Results to an AWS S3 Bucket" or "Export Analytical Results to BigQuery".

Overall Steps to Export Results

Perform the following overall steps to set up an export of results to an outside cloud location:

Note

These steps vary depending on the clean room type and export location. See the individual articles in this section for specific instructions.

  1. Enable the clean room for exports.

  2. Add the appropriate credentials.

  3. Create an export destination connection.

  4. Provision the destination connection in a clean room.

  5. Create a new export.

  6. If desired, view destination account details.

For information on performing these steps, see the sections below or the individual articles in this section.

Enable the Clean Room for Exports

Before setting up an export, the clean room owner must enable exports for the selected source clean room:

  1. From the LiveRamp Clean Room navigation pane, select Clean Rooms → Clean Rooms (or click Go to Clean Rooms from the Clean Rooms tile).

  2. In the row for the clean room you would like to export from, click the More Options menu (the three dots), and then select Edit.

    CR-Export_to_GCS-edit_button.png

  3. From the Configuration step, click Next Step.

    LCR-Export_Analytical_Results_to_BigQuery-Next_Step_button.png

  4. From the Parameters step, adjust any data control parameters as needed and then slide the Enable Export toggle to the right.

    CR-Export_to_GCS-edit_clean_room_screen.png

  5. Click Next Step.

  6. Verify that your data control parameters are correct and then click Save.

    CR-Export_to_GCS-edit_clean_room_screen_2.png

Add the Credentials

After enabling the clean room for exports, the clean room owner must first add either their own credentials or those of their partner:

  1. From the LiveRamp Clean Room navigation pane, select Data Management → Credentials.

  2. Click Add Credential.

    add_credential.png

  3. Enter a descriptive name for the credential.

  4. For the Credentials Type, select the appropriate type (Google Service Account example shown - for more information, see the specific articles in this section).

    CR-Export_to_GCS-edit_credential.png

  5. Enter the required information (information varies for each credential type).

  6. Click Save Credential.

  7. Verify that your credentials have been added to LiveRamp Clean Room (Google Service Account example shown):

    CR-Export_to_GCS-_verify_credential.png

Create a Destination Connection

An export destination connection is used to connect your results to your export location. After you've added the appropriate credentials, create an export destination connection for your desired cloud type.

Destination connections are created at the organization level and can be configured for any clean room from there.

Note

Destination connection credentials can be configured on the Organization Credentials page before configuring the destination itself or they can be configured as part of the destination connection creation flow as shown below.

To create a new destination connection:

  1. From the LiveRamp Clean Room navigation pane, select Destinations & Integrations → Destinations.

  2. Click Create Destination Connection.

    image idm2060

  3. Select the platform you want to configure your account for.

    create_partner_choose_platform.png

  4. Enter a descriptive name for the destination connection so that you can easily identify individual connections for a given platform.

    create_partner_config_account.png

  5. To use a pre-configured credential, select the credential from the Available Credentials dropdown and then skip the next step.

  6. To create a new credential (if you are not selecting a pre-configured credential):

    1. Click Create new credential.

    2. Enter a name for the new credential.

      create_partner_create_cred.png

    3. Provide the requested account-level information.

      Note

      When creating a new credential, you provide the requested information in order for LiveRamp Clean Room to configure a connection to a specific partner account. Credential requirements differ by platform. Credentials are saved and accessible on the OrganiData ManagementList & Activations → Credentials from the navigation pane.

    4. Click Create.

    5. Select the new credential from the Available Credentials dropdown.

  7. Click Add new account.

Provision a Destination Connection to the Clean Room

Once you've created a destination connection, you can provision that destination connection to the clean room you want to export results from:

  1. From the LiveRamp Clean Room navigation pane, select Clean Rooms → Clean Rooms.

  2. From the tile for the desired clean room, click Enter.

  3. From the Clean Room navigation pane, select Destinations. The Destinations screen shows all destination connections provisioned to the clean room.

  4. Click Provision Destination.

    cr_activation_provision.png

  5. Select the check box for one or more destination connections to add to the clean room for activation, and then click Provision.

    CR-Export_to_BQ-_provision_Activation_Channels.png

Create a New Export

After you've provisioned the destination connection to the clean room, create a new export:

  1. From the LiveRamp Clean Room navigation pane, select Clean Rooms → Clean Rooms.

  2. From the tile for the desired clean room, click Enter.

  3. From the Clean Room navigation pane, select Exports.

  4. Click + New to open the wizard to create a new export.

    CR-Export_to_GCS-__Exports_page.png

  5. Select the question that you want to export outputs for and then click Next.

    Note

    Unless paused, all run outputs will be exported to the configured export destination connection.

    CR-Export_to_GCS-_choose_clean_room_question.png

  6. Check the radio button for the specific destination connection you want to send run outputs to.

    LCR-Export_Results_to_Azure_Blob_Storage_-Select_Azure_Export.png

  7. Enter the required information on where you would like the outputs to be exported to and then click Finish.

  8. Verify that the job has been created. Exports are added to the page. You may view the details of an export by clicking on the name.

    LCR-Export_Results_to_Azure_Blob_Storage_-Verify_job_creation_1.png
    LCR-Export_Results_to_Azure_Blob_Storage_-Verify_job_creation_2.png

  9. No

Note

  • Exports can be paused, which will stop them from sending data upon the completion of each run.

  • Exports cannot be edited or deleted. Changes should be made by pausing the export and creating a new export.

View Destination Connection Details

Once you've exported results from a clean room, you can view details on currently configured destination connections:

  1. From the LiveRamp Clean Room navigation pane, select Destinations & Integrations → Destinations.

  2. Select the dropdown next to any configured partner to see the individual partner account details, including:

    activation_channels_all.png

    • Destination Connection Name

    • Modified By

    • Date Modified

    • Status: Connection status for a particular account. Job statuses include:

      • Pending: The configuration is in progress.

      • Configured: The configuration is complete.

      • Failed: The configuration has failed. Contact your LiveRamp account team.

    • Ownership

    • Jobs for Last 7 Days: Number of jobs by job status for the last 7 days.

    • Actions: Click the More Options icon (three dots) to see a menu with available actions:

      • View Details: See the number of records sent based on a selected date range (7, 14, 30 days)

      • Edit: Update destination account credentials

      • Deprovision: Deprovision the destination account from this clean room

      • Delete: Remove a destination account so that audiences can no longer be activated

  3. To see job status details, click the More Options icon and then select View Details.

    LCR-Export-Create_View_Details_menu_selection.png

    A list of all jobs for that particular desction connection for the last 7 days is displayed. You can adjust the range filter to show all jobs or jobs in the last 14 or 30 days.j You can also filter by job status.

    LCR-Export-jobs_list.png

    Note

    For jobs in a failed or partially failed status, consider checking the associated data and data source, the partner platform itself, or the data logs to understand where a failure may be taking place.

In this section: