How to update a table in snowflake with data from Oracle?

Question

I need to update a table in snowflake by taking data from oracle database. Is there a way to connect to oracle database from snowflake? If answer is NO how can i update the table in snowflake using data from oracle.

Answer 1

Not sure exactly what you are looking for here. The best way to get data into Snowflake is via the COPY INTO command, which would then allow you to update the Snowflake table with that data. If you are looking at ways to keep the 2 systems in-sync, then you might want to look into the various data replication tools that are in the marketplace. If this is a transactional update, then you can use a connector (ODBC, JDBC, Python, etc.) to update the data from one system to another. I wouldn't recommend that for bulk updates, though.

Answer 2

There are several ways you can integrate your data from oracle to snowflake. If you are familiar with ETL tool you can use any one of them or you can use any program language to extract and load.