GlareDB Cloud has an integrated SQL workspace that can be used to connect, query and manage data sources. From the main page, click the SQL workspace link for a deployment.
The SQL workspace contains various helpful features for exploring your data, querying your data and producing basic reports:
- Schema explorer (available from the sidebar)
- Recent queries (available from the sidebar)
- Completion hints for tables and functions (available in the editor)
- Exporting results (available from the results panel)
Querying your data sources in GlareDB is simple. You can use familiar
JOIN statements. External tables do not need to be qualified. Tables on external databases require qualification.
For example, the following query for accesses an external database named
example with a
public schema containing a
SELECT * FROM example.public.users;
You can connect to GlareDB with your preferred Postgres-compatible clients, such as
psql. For more information on connections strings and passwords, refer to Connection Details and Managing Passwords.