Forum Discussion
Solved
Limit amount of data imported - 2 different data sources
Hi there
I have 2 x tables, one in Snowflake with 1,000 rows and one in Oracle with over 4,000,000.
I only want to import data from the Oracle table with matching rows.
Is this possible?
Perhaps Reference your Snowflake query, Remove all columns except the column you want to match on. Do a Merge query with your Oracle data. (left inner join with your single column Snowflake table as the left)
1 Reply
Perhaps Reference your Snowflake query, Remove all columns except the column you want to match on. Do a Merge query with your Oracle data. (left inner join with your single column Snowflake table as the left)