Accessing Postgres Database for Analytics Pipeline

If snowflake can talk to Postgres, then I’d open a postgres port (with appropriate firewall to limit access) and let it talk to it.

If Snowflake can read csv/json then you could use data explorer and retrieve the stuff automatically via the API.