@beekeeperstudio/knex-snowflake-dialect
v0.4.4
Published
knex.js dialect for the Snowflake data warehouse
Readme
NOTE
This code was forked from the folks over at Deliverr, Inc. The original license is in this repo.
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-dialectUsage
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.
