# Accessing Postgres Database for Analytics Pipeline

**URL:** <https://meta.discourse.org/t/accessing-postgres-database-for-analytics-pipeline/310045>\
**Category:** Data & reporting\
**Tags:** data-explorer, analytics\
**Created:** [May 30, 2024, 11:44pm UTC](https://meta.discourse.org/t/accessing-postgres-database-for-analytics-pipeline/310045 "2024-05-30T23:44:40Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [May 31, 2024, 12:01pm UTC](https://meta.discourse.org/t/accessing-postgres-database-for-analytics-pipeline/310045/2 "2024-05-31T12:01:36Z")

</div>

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](https://meta.discourse.org/t/32566?silent=true) and retrieve the stuff automatically via the API.

---

_[View the full topic](https://meta.discourse.org/t/accessing-postgres-database-for-analytics-pipeline/310045)._