Use the Peliqan SQL query editor to write SELECT queries on any data source, including JOIN queries that join data from different sources.

Optionally you can run your SQL queries on Peliqan’s built-in query engine Trino, in order to join data between separate databases and data warehouses.

Referencing tables and views in queries

Referencing a table

Examples:

SELECT * FROM databasename.schema.tablename;
SELECT * FROM schema.tablename;
SELECT * FROM tablename;

Referencing a view

It is also possible to reference a view that is defined on a table. Views are useful to e.g. filter the data. A view is appended to the table name using an underscore. Example:

SELECT * FROM databasename.schema.tablename_viewname;

Referencing the “_original” view

If you want to fetch the source data without any changes applied (e.g. transformations), append “_original” to the table name:

SELECT * FROM databasename.schema.tablename_original;

Common examples

Filter records after a specified date:

SELECT * FROM some_table where some_date_column > date '2021-12-25'

Cast a column to a different format:

SELECT CAST(some_column AS float) FROM some_table