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.


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.