Node.js driver for Snowflake
npm install snowflake-sdk---
NodeJS Driver for Snowflake
---
| :exclamation: | For production-affecting issues related to the driver, please create a case with Snowflake Support. |
| ------------- | :----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
Run npm i snowflake-sdk in your existing NodeJs project.
For detailed documentation and basic usage examples, please see the documentation
at NodeJS Driver for Snowflake.
This driver starts supporting the GCS regional endpoint starting from version 2.0.0. Please ensure that any workloads using through this driver
below the version 2.0.0 do not require support for regional endpoints on GCP. If you have questions about this, please contact Snowflake Support.
Specify env variables:
```
export SNOWFLAKE_TEST_USER=
export SNOWFLAKE_TEST_PASSWORD=
export SNOWFLAKE_TEST_ACCOUNT=
export SNOWFLAKE_TEST_WAREHOUSE=
export SNOWFLAKE_TEST_DATABASE=
export SNOWFLAKE_TEST_SCHEMA=
export SNOWFLAKE_TEST_PROTOCOL=
export SNOWFLAKE_TEST_HOST=
export SNOWFLAKE_TEST_PORT=
Run hang webserver:
``
python3 ci/container/hang_webserver.py 12345 &
Run unit tests:
``
npm test
or
``
npm run test:unit
To run a single test file use test:single script, e.g. run tests in test/unit/snowflake_test.js only:
``
npm run test:single -- test/unit/snowflake_test.js
Run integration tests:
``
npm run test:integration
Specify env variables:
``
export RUN_MANUAL_TESTS_ONLY=true
export SNOWFLAKE_TEST_OKTA_USER=
export SNOWFLAKE_TEST_OKTA_PASS=
export SNOWFLAKE_TEST_OKTA_AUTH=
export SNOWFLAKE_TEST_OAUTH_TOKEN=
export SNOWFLAKE_TEST_BROWSER_USER=
Run manual connection test for different authenticators
``
npm run test:manual
Run tests and show code coverage report
``
npm run test:ci:coverage
The npm package can be built by the command:
``
npm pack
Note it is not required to build a package to run tests blow.
Starting from version v1.13.0 the driver package is signed with a signature allowing to verify its authenticity and integrity.
Steps to verify the signature:
1. Install cosigntgz
2. Download the driver package file () from npmjs.org, e.g.: https://registry.npmjs.org/snowflake-sdk/-/snowflake-sdk-1.13.0.tgz
3. Download the signatures file (.sig and .pub) from the release, e.g.: https://github.com/snowflakedb/snowflake-connector-nodejs/releases/download/v1.13.0
4. Verify the signature:
`shell
cosign verify-blob snowflake-sdk-1.13.0.tgz --key snowflake-connector-nodejs-v1.13.0.pub --signature resources.snowflake-sdk-1.13.0.tgz.sig
Verified OK
`
Check formatting on all files:
``
npm run lint:check:all
Check formatting of single file or directory e.g. test/unit/snowflake_test.js:
``
npm run lint:check -- test/unit/snowflake_test.js
Fix potentially fixable formatting errors and warnings of single file or directory e.g. test/unit/logger:
``
npm run lint:fix -- test/unit/logger
The build and test pipeline supports TypeScript. You can:
- Import .ts files into .js files.js
- Import files into .ts files.js
- Rename files to .ts files
#### Migration playbook
- Every newly created file should be a .ts file..js
- When working with existing file, try to rename it to .ts and// @ts-ignore Error Description
- Try to replace require() with import
- Try to replace module.export with ES export const/default
- If there's compilation error:
- Try to fix it
- If the fix is time consuming - use e.g. // @ts-ignore TS2451: Cannot redeclare block-scoped variable 'toString'.(var: any)
- Do your best to avoid fixing strict mode errors with tsconfig.json`
- Feel free to add more compilation rules to