Some of our target DWHs are not not currently support as source (Snowflake, BQ, Synapse, etc).
This article is aimed to provide a quick workaround by setting up a logic river and source-to-target river.
- Create logic step with desired query for what data to move OUT of one DWH and INTO another:
- In the Target section of the step, choose ‘Files Export’ and write the bucket name to output the data to, as well as the file type:
- Next, create a source to target river that pulls the file just outputted by the previous step with the target set as the desired destination DWH. (In this example, BQ > SF).
Source tab example:
Target tab example:
- Add the Source to Target to the logic river as 2nd step:
