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

• Email: support@senseplatform.com
• Twitter: https://twitter.com/SensePlatform
• Google Group: https://groups.google.com/forum/?fromgroups#!forum/sense-users
• IRC: #senseplatform on irc.freenode.net

LICENSE

MIT