sense-sql-engine

SQL engine for Sense supporting Redshift, Postgres, MySql, and SQLite.

npm install sense-sql-engine
23 downloads in the last month

SQL Engine for Sense

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.

Installation

You can install this engine in Sense using:

npm install sense-sql-engine

Usage

Database connection info should be stored securely in environmental variables (Project > Environment). For instance, if you have a database you want to call REDSHIFT, store the connection info as:

REDSHIFT=driver://user:pass@hostname/database

The driver can be postgresql (redshift or postgres), mysql, or sqlite.

You can then select the database from within a SQL dashboard or script using:

CONNECT ${REDSHIFT};

The syntax ${VARIABLE} performs variable substitution from your environment. You can then execute queries like you would normally:

CONNECT ${REDSHIFT};
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.

Tips

  • Make sure to always limit the amount of data you return using like LIMIT.
  • Comments are markdown formatted.

Support

LICENSE

MIT

npm loves you