knex-snowflake-dialect

knex.js dialect for the Snowflake data warehouse.

As of release 0.2.x, the connect and raw query methods have been tested, along with schema migrations.

Installation

``shell script
npm install knex-snowflake-dialect
`

Usage

Sample initialization:

`javascript
import * as knex from "knex";
import { SnowflakeDialect } from "knex-snowflake-dialect";

export const Snowflake = knex({
client: SnowflakeDialect,
debug: true,
connection: "snowflake://myuser:mypassword@myaccount.myregion.snowflakecomputing.com/mydb?warehouse=MY_WAREHOUSE",
pool: {
min: 1,
max: 1
}
});
`

The configuration could alternatively break out the connection` parameters as separate keys, per the
snowflake-sdk "Establishing a Connection"
documentation.