knex-snowflake-dialect
v0.3.2
Published
knex.js dialect for the Snowflake data warehouse
Downloads
8,259
Readme
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
npm install knex-snowflake-dialect
Usage
Sample 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.