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.