GlareDB is designed to make time to first insight as quick as possible. Instead of having to rely on ETL (Extract-Transform-Load) pipelines to move data across databases, GlareDB hooks directly into your data sources. With GlareDB, you no longer have to wait on an ETL pipeline before being able to work on the freshest data.
GlareDB gracefully plugs into your stack and allows you to use the languages and tools you already know.
Example: query an external PostgreSQL database in 2 steps
The example below uses
psql to perform the following steps:
- Connect a GlareDB deployment named
gdbto a PostgreSQL database
- Query a table
public.animalson the PostgreSQl database
Connecting GlareDB to a PostgreSQL database:
This only needs to be done once.
pg_dbwill be recognized as a data source for future sessions and queries, unless it is explicitly removed.
CREATE EXTERNAL DATABASE pg_db FROM postgres OPTIONS ( host = 'localhost', port = '5432', user = 'postgres', password = 'postgres', database = 'postgres', );
SELECT * from pg_db.public.animals;
animal -------- cat dog monkey (3 rows)
Refer to data sources for more information on data sources