Skip to main content

Export Results From a Snowflake Clean Room to an AWS S3 Bucket

To set up an export of analytical and list results to an AWS S3 bucket from a Snowflake clean room, see the instructions below.

Note

  • To set up an export of analytical and list results to an AWS S3 bucket from a Hybrid clean room or a Confidential Computing clean room, see "Export Results From a Hybrid or Confidential Computing Clean Room to an AWS S3 Bucket".

  • Partners invited to a clean room must have their export destination connections (grouped under "Destinations") approved by clean room owners. Contact your Customer Success representative to facilitate the approval.

  • If your AWS S3 Bucket is set up with SSE KMS, share the KMS key ARN with your LiveRamp contact. For information about S3's server-side encryption key management service, see this AWS article.

  • Make sure that the bucket path you use for the export destination connection is distinct from any bucket paths you use for existing AWS data connections in LiveRamp Clean Room. For example, to use the same bucket for both exports and data connections, make sure to use a distinct folder in that bucket for exports and a distinct folder for each data connection.

  • For S3 exports originating from a Confidential Computing (TEE/HCC) clean room, notify your LiveRamp contact because LiveRamp needs to add your S3 bucket to the firewall allowlist. If you joined the project mid-configuration and are unsure if your clean room is Confidential Computing and needs this step, you can ask.

  • Configuring exports outside of a clean room (such as at the organization level) is still supported, but will be deprecated. Setting up clean room question exports within a clean room is recommended.

Overall Steps

Perform the following overall steps to set up an export of analytical and user list results to an AWS S3 bucket:

  1. Enable the clean room for exports.

  2. Add the credentials.

  3. Add an export destination connection.

  4. configure the question to share the question results with LiveRamp.

  5. Provision the destination connection to the clean room.

  6. Create a new export.

For information on performing these steps, see the sections below.

Enable the Clean Room for Exports

Before setting up an export, the clean room owner must enable exports for the selected source clean room (if not already done during clean room creation):

  1. From the navigation menu, select Clean Room → Clean Rooms to open the Clean Rooms page.

    LCR-Old_Clean_Room_Nav_menu.png

  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

To set up an export to an AWS S3 bucket from a Snowflake clean room, the clean room owner must first add their credentials or their partner's.

  1. From the navigation menu, select Clean Room → Credentials to open the Credentials page.

  2. Click Create Credential.

    add_credential.png

  3. Enter a descriptive name for the credential.

  4. For the Credentials Type, select "AWS IAM User Credentials".

    CR-_Export__to__AWS-_AWS__IAM__credential.png

  5. Enter the following parameters:

    CR-_Export__to__AWS-_AWS__IAM__credential_parameters.png

    • AWS Access Key ID

    • AWS Secret Access Key

    • User ARN

    • AWS Region

  6. Click Save Credential.

  7. Verify that your credentials have been added to LiveRamp Clean Room:

Add an S3 Export Destination Connection

For Snowflake clean rooms, set up an S3 export destination connection:

  1. From the navigation menu, select Clean Room → Destinations to open the Destinations page.

    LCR-Old_Destinations_Nav_menu.png

  2. Click Create Destination Connection.

    image idm2060

  3. Select S3 Export.

    CR-Export_to_AWS-S3_Export.png

  4. Enter a name and select the AWS IAM credential created in the "Add the Credentials" section above.

    CR-Export_to_AWS-choose_IAM_credential.png

  5. Click Add new account.

  6. Confirm that the new export has been added to your list of S3 export activation channels.

Configure the Question to Share Results

For exports to AWS from a Snowflake clean room, you need to configure the question to share the results from your Snowflake account to LiveRamp:

Note

This step does not have to be performed if you’re exporting a question from a Hybrid or Confidential Computing clean room.

  1. From the navigation menu, select Clean Room → Clean Rooms to open the Clean Rooms page.

    LCR-Old_Clean_Room_Nav_menu.png

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

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

  4. In the row for the question whose results you want to export, click the More Options menu and then select Share Question Results.

    LCR-Export_AWS-Share_Question_Results_menu_selection.png

  5. From the dialog that appears, make sure that the check box for LiveRamp is checked and then click Share.

    LCR-Export_AWS-Share_button.png

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:

Note

In most situations, only the clean room owner can provision export destinations using this method. To give clean room partners the ability to provision destinations that the owner has created, contact your LiveRamp representative.

  1. From the navigation menu, select Clean Room → Clean Rooms to open the Clean Rooms page.

    LCR-Old_Clean_Room_Nav_menu.png

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

  3. Click Provision Destination.

    cr_activation_provision.png

  4. Check the check box for the desired destination connection and then click Provision (AWS S3 example shown).

    CR-Export_to_AWS-_provision_Activation_Channels.png

  5. Verify that your destination connection has been added (S3 IAM example shown).

    CR-Export_to_AWS-_verify_Activation_Channels.png

    Note

    If you're a clean room partner who has been given the ability to request the provisioning of export destinations, the status will show as "Configured (Pending Approval)" until the clean room owner has approved the provisioning of the destination. You can still set up your exports, but the data will not be exported until the request has been approved.

Approve a Destination Provisioning Request

If you're a clean room owner, you're clean room partners can provision export destinations in the clean room, but the status will show as "Configured (Pending Approval)" until you have approved the provisioning of the destination.

To approve the provisioning request:

  1. From the navigation menu, select Clean Room → Clean Rooms to open the Clean Rooms page.

    LCR-Old_Clean_Room_Nav_menu.png

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

  3. Click the caret next to the destination type to view the list of destination connections for that destination type.

  4. For the destinations that show the status as "Configured (Pending Approval)", click Approve.

    LCR-Approve_destination_provision.png

The destination status changes to "Configured".

Create a New Export

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

Note

The name of the export will be the name of the question with a timestamp appended to the end of the name (for example, the question "Export_List_Question_18_Aug_CSV_Enabled" will be exported as "Export_List_Question_18_Aug_CSV_Enabled_2025-08-18_10-02-36", along with the appropriate file extension).

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

    CR-Export_to_AWS-Export_menu_selection.png

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

    CR-Export_to_AWS-New_button.png

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

    CR-Export_to_AWS-select_question.png

  4. Select the specific export destination connection you want to send run outputs to, and then click Next.

    CR-Export_to_AWS-select_export_partner.png

  5. Enter the full s3://… export path to save the results to, and then click Finish:

    CR-Export_to_AWS-define_custom_folder.png

    Note

    Provide only the bucket name for the analytical or user list outputs. Do not include the gs:// prefix before the bucket name.

  6. 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.

    CR-Export_to_AWS-details_panel-exports.png
    CR-Export_to_AWS-details_panel-details.png

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.

  • The name of the export will be the name of the question with a timestamp appended to the end of the name (for example, the question "Export_List_Question_18_Aug_CSV_Enabled" will be exported as "Export_List_Question_18_Aug_CSV_Enabled_2025-08-18_10-02-36", along with the appropriate file extension).

  • To use a custom file name, create a support case after you create the export job and include the export job name, the custom file name pattern you want, and the name of the question.

Export Details

To set up an export of analytical and list results to an AWS S3 bucket from a Hybrid clean room or a Confidential Computing clean room, see the instructions below.

  • s3://<data-source-location>/<custom-prefix>

    • /yyyy-MM-dd ← Run date

      • /runID ← RunID available in the Clean Room and via API ( /cleanroom-questions/{cleanroomQuestionId}/cleanroom-question-runs )

        • /data ← For analytical questions, this contains 1 .csv file. For user list questions, this contains 1+ .csv files with list data.

          Note

          List files do not contain column headers

          • meta.csv ← Information about the question (title, description, category) and question run (name)

          • headers.csv ← Column headers for the /data files

In this section: