Skip to content

deliverr/data-knex-snowflake-dialect

Repository files navigation

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: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.