0
$\begingroup$

Have a Schema.Table_Name on Oracle. Exactly similar table is on Snowflake with same metadata(Schema.Table_Name). How can I combine data from two on the fly without moving Oracle data to Redshift.

Most obvious: I cannot take content of Oracle table to Snowflake/cloud. Restricted. Cannot use any service which can store Oracle data outside of it. Can use a transient service though.

Any thoughts on how to combine the data on the fly? Any sql which I write on Oracle will work on Snowflake as is. How I can combine the two SQL outputs on the fly. Want to write a single query to get data from two places.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.