Setting up the export of data to Snowflake

To export Oracle Unity segments or data objects to Snowflake, you will need to create the destination and accompanying campaign job or export job that will export the data.

Before you begin

Make sure you have the following parameters before setting up the data connection.

  • SFTP server name: The hostname for the SFTP server, formatted as

  • Authentication key: Prepare a text file that has the authentication key to access the SFTP server.

  • Folder name: The path name to the folder on the SFTP server that has the files to export.

  • Encryption key: If the exported file has a PGP compression format, prepare a file with the key to encrypt the file.

Step 1: Create the Secure FTP destination

After collecting the information above, follow the steps for creating an Secure FTP destination. The destination provides all the details for exporting the data.

Step 2: Create the campaign job or export job

Once the destination is created and published, you can set up the job to export the data. You have the option of exporting data objects and segments from Oracle Unity.

Step 3: Run the campaign job or export job

Monitor the status of the export job or campaign job from the Jobs dashboard.

Step 4: Import data into Snowflake

After the data is successfully exported, you can then import the data into Snowflake. Learn how to Load Data into Snowflake from the Snowflake documentation.

integrate, integration, snowflake, how to integrate, export