Company
Date Published
Author
Javier de la Torre
Word count
948
Language
English
Hacker News points
None

Summary

Federated Tables` are a new feature in the CARTO platform that allows users to connect to remote databases and perform live queries on them, without having to cache or sync data. This enables faster query performance, especially for large datasets or frequently changing data. The feature uses `PostgreSQL Foreign Data Wrapper` to establish a connection with the remote database, allowing users to execute queries dynamically on the remote server. With Federated Tables, CARTO can leverage the scalability and low latency of cloud databases within its ecosystem, reducing latency between servers and transferring only the minimum amount of data necessary for the query. The feature is designed to work with various cloud databases and on-premise systems, including PostgreSQL, AWS RDS, GCP Cloud SQL, Azure Database, Amazon Aurora, and Hyperscale (Citus) on Azure Database.