Query and join your existing PostgreSQL databases with DuckDB data.
Note: No replication is required here. The Postgres tables are queried natively using pg_duckdb.
Suppose you have customer data in Postgres and product analytics in DuckDB. With Chakra, you can write a single SQL query to join these sources:
Connect your Postgres database in the Chakra UI.
Add requisite details and confirm the database has been attached. You will see “blue” icons corresponding to Postgres attached databases.
Query and join the data like a normal DuckDB database.