4 ms·
> There is inherent value in having a single source of truth for analytics. > I'm not sure how you'd solve that problem in an architecture where the data isn'
by michael_j_ward 6y ago
> There is inherent value in having a single source of truth for analytics.
> I'm not sure how you'd solve that problem in an architecture where the data isn't getting centralized.
Isn't the entire point of this article that the author achieved a single source of truth without moving the data by using postgres's Foreign Data Wrappers?
- nunie123 6y agoThe data is being moved, it's just that the mechanism to move it was the FDWs, instead of e.g. an Airflow DAG. The FDWs are interesting because they're update-on-query as opposed to updating on a fixed schedule or update on a source system event, which is more common.
- michael_j_ward 6y ago> The data is being moved My understanding is that FDW's act as a proxy. I don't believe the tables are materialized. Can you link me where it says otherwise? I don't see anything in the docs [1]. [1] https://www.postgresql.org/docs/current/postgres-fdw.html https://www.postgresql.org/docs/current/postgres-fdw.html