https://dagster.io/ logo
#integration-snowflake
Title
# integration-snowflake
c

clay

04/17/2023, 4:17 PM
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

Félix Tremblay

04/17/2023, 4:58 PM
Hello @clay, maybe you could simply sync the tables from Postgres to Snowflake using an ingestion tool such as Airbyte or Airbyte Cloud?
c

clay

04/17/2023, 5:05 PM
That's a good idea. I'll look into that. Thanks!
6 Views