snowflake

Connecting JavaScript and Snowflake with ADBC

Instructions

Prerequisites

1. Install Node.js (version 22 or later)

   • Alternatively, you can use Bun or Deno

2. Install dbc

Connect to Snowflake

1. Install the Snowflake ADBC driver:

   dbc install snowflake

2. Install dependencies:

   npm --prefix .. install

3. 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()

4. Run the script:

   Node.js:

   node main.js

   Bun:

   bun run main.js

   Deno:

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