snowflake-sdk

What is snowflake-sdk?

The snowflake-sdk npm package is a Node.js driver for connecting to Snowflake, a cloud-based data warehousing service. It allows you to execute SQL queries, manage transactions, and handle various database operations programmatically.

What are snowflake-sdk's main functionalities?

Connecting to Snowflake

This feature allows you to establish a connection to a Snowflake database using the provided account credentials and connection details.

const snowflake = require('snowflake-sdk');
const connection = snowflake.createConnection({
  account: 'your_account',
  username: 'your_username',
  password: 'your_password',
  warehouse: 'your_warehouse',
  database: 'your_database',
  schema: 'your_schema'
});
connection.connect((err, conn) => {
  if (err) {
    console.error('Unable to connect: ' + err.message);
  } else {
    console.log('Successfully connected to Snowflake.');
  }
});

Executing SQL Queries

This feature allows you to execute SQL queries against the connected Snowflake database and handle the results.

connection.execute({
  sqlText: 'SELECT * FROM your_table',
  complete: (err, stmt, rows) => {
    if (err) {
      console.error('Failed to execute statement due to the following error: ' + err.message);
    } else {
      console.log('Number of rows produced: ' + rows.length);
      console.log(rows);
    }
  }
});

Managing Transactions

This feature allows you to manage transactions by beginning, committing, and rolling back transactions within the Snowflake database.

connection.execute({
  sqlText: 'BEGIN TRANSACTION',
  complete: (err, stmt, rows) => {
    if (err) {
      console.error('Failed to begin transaction: ' + err.message);
    } else {
      console.log('Transaction started.');
      // Perform other operations within the transaction
      connection.execute({
        sqlText: 'COMMIT',
        complete: (err, stmt, rows) => {
          if (err) {
            console.error('Failed to commit transaction: ' + err.message);
          } else {
            console.log('Transaction committed.');
          }
        }
      });
    }
  }
});

Other packages similar to snowflake-sdk

pg

The pg package is a PostgreSQL client for Node.js. It provides similar functionalities for connecting to and interacting with PostgreSQL databases, including executing SQL queries and managing transactions. However, it is specific to PostgreSQL and does not support Snowflake.

mysql

The mysql package is a Node.js client for MySQL databases. It offers similar capabilities for connecting to MySQL databases, executing queries, and managing transactions. Like pg, it is specific to MySQL and does not support Snowflake.

mssql

The mssql package is a Microsoft SQL Server client for Node.js. It provides functionalities for connecting to SQL Server databases, executing queries, and managing transactions. It is specific to SQL Server and does not support Snowflake.

README

Node.js driver for Snowflake

The official Node.js driver for Snowflake.

Installing

To install the driver, go to your project directory and type the following:

npm install snowflake-sdk

Usage and Getting Started

You can find documentation for the driver at:

https://docs.snowflake.net/manuals/user-guide/nodejs-driver.html

License

This driver is distributed under the Apache License, Version 2.0, see LICENSE.txt for more information.