Skip to main content Link Menu Expand (external link) Document Search

Why GlareDB?

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.

Simple interface

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:

  1. Connect a GlareDB deployment named gdb to a PostgreSQL database
  2. Query a table public.animals on the PostgreSQl database

Connecting:

psql "postgresql://user:password@proxy.glaredb.com:6543/gdb"

Response:

gdb=>

Connecting GlareDB to a PostgreSQL database:

This only needs to be done once. pg_db will 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',
);

Response:

CREATE DATABASE

Querying pg_db:

SELECT * from pg_db.public.animals;

Response:

 animal
--------
 cat
 dog
 monkey
(3 rows)

Refer to data sources for more information on data sources