65 lines (44 loc) · 1.58 KB

Connecting JavaScript and Snowflake with ADBC

Instructions

Prerequisites

Install Node.js (version 22 or later)
- Alternatively, you can use Bun or Deno
Install dbc

Connect to Snowflake

Install the Snowflake ADBC driver:
```
dbc install snowflake
```
Install dependencies:
```
npm --prefix .. install
```
Customize the script main.js:
- Change the connection arguments in databaseOptions
  - See Snowflake Driver Client Options for the full list of available options
- If you changed the database and schema, also change the SQL SELECT statement in conn.query()

Run the script:

Node.js:

node main.js

Bun:

bun run main.js

Deno:

deno run --allow-ffi --allow-env main.js