SQL engine for Sense supporting Redshift, Postgres, MySql, and SQLite.
A SQL engine for Sense supporting Redshift, MySql, Postgres, and SQLite3.
Note: This engine is not yet officially supported due to known bugs in the chunker.
You can install this engine in Sense using:
npm install sense-sql-engine
Database connection info must be stored securely in environmental variables (Project > Environment).
For instance, if you have a database you want to call
MYREDSHIFT, store the connection info as:
The driver can be
postgresql (redshift or postgres),
You can then select the database from within a SQL dashboard or script using:
Your connection information will never appear in any dashboard output. You can then execute queries like you would normally:
CONNECT MYREDSHIFT;SELECT * FROM users WHERE created_at > CURRENT_TIMESTAMP - INTERVAL '7 days'
You can switch between multiple databases in a single script by issuing multiple
CONNECT statements. Connection names are case insensitive.