0

I have to create an app which transfer data from snowflake to postgres everyday. Some tables in postgres are truncated before migration and all data from corresponding snowflake table is copied. While for other tables, data after last timestamp in postgres is copied from snowflake. This job has to run at night sometime and not when customers are using the service at daytime. What is the best way to do this ?

Saurabh Bhatia
  • 679
  • 2
  • 7
  • 11

2 Answers2

0

Do you have constraints, limiting your choices in:

  • ETL or bulk data tooling
  • Development languages?
Thomas B
  • 181
  • 1
  • 13
0

According to this site, you can create a foreign data wrapper on Postgresql for snowflake

Thomas B
  • 181
  • 1
  • 13