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.
npm install knex-snowflake-dialectSample initialization:
import * as knex from "knex";
import { SnowflakeDialect } from "knex-snowflake-dialect";
export const Snowflake = knex({
client: SnowflakeDialect,
debug: true,
connection: "snowflake://myuser:[email protected]/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.