You’ll primarily use Data Refinery to read data from a source location, refine that data, and then load the analytics-ready data to a target location. But you can also use Data Refinery to simply and securely copy data from a source to a target.
From within a project, add the data that you want to copy. This creates a data asset in the project.
Create a connection for the target, if it doesn’t already exist. Be sure to use credentials that have Write permission.
Important: Not all connection types can be targets. Review restrictions in Connection types.
From the project’s Assets page, select Refine from the data asset’s menu. Alternatively, click the data asset to see a preview and then click the Refine link.
Click the Run Data Refinery flow icon in the Data Refinery toolbar.
In the DATA REFINERY FLOW OUTPUT panel, click the Edit Output icon and save the Data Refinery flow output (target data set) to a connection.
Optionally, edit the target name.
Click Change Location and then Connections.
Select the connection details, then click Save Location.
For the Update and Upsert options, you’ll need to select the columns in the output data set to compare to columns in the existing data set. The output and target data sets must have the same number of columns, and the columns must have the same names and data types in both data sets.
In the Edit output panel, click the checkmark to save the changes.
Click Save and Run flow.
Optionally, follow the progress of the run by clicking View Flow to monitor the Data Refinery flow’s status on the Data Refinery flow details page. When the Data Refinery flow completes, you can view the target data set from the Data Refinery flow details page too.
Watch this video to see how to copy data to a target.
This video shows you how to copy data from a source to a target.