We use Postgres for metadata/asset/job tracking, r...
# integration-snowflake
c
We use Postgres for metadata/asset/job tracking, running in a Docker container in a multi-container deployment. However, most of our work is done in Snowflake. I was thinking it would be useful to provide a way (in dagit?) to export the Postgres metadata tables to Snowflake for easier exploration. I'd like to be able to look at resource usage by asset materialization, for example, and that data is stored in Postgres. However, I would need to get it into Snowflake to support reporting anyhow. Does anybody know if there's a way to do this?
👀 1
f
Hello @clay, maybe you could simply sync the tables from Postgres to Snowflake using an ingestion tool such as Airbyte or Airbyte Cloud?
c
That's a good idea. I'll look into that. Thanks!