This repository is based on Databricks SQL Driver for Node.js and includes the following changes:

Version at time of fork: 1.8.4

- Removal of dependency on lz4 and @types/lz4
- Minor changes in testing stubs to support node 20

Databricks SQL Driver for Node.js

!http://www.apache.org/licenses/LICENSE-2.0.txt

Description

The Databricks SQL Driver for Node.js is a Javascript driver for applications that connect to Databricks clusters and SQL warehouses. This project is a fork of Hive Driver which connects via Thrift API.

Requirements

- Node.js 14 or newer

Installation

``bash
npm i databricks-sql-nodejs
`

Usage

examples/usage.js

`javascript
const { DBSQLClient } = require('databricks-sql-nodejs');

const client = new DBSQLClient();

client
.connect({
host: '**.databricks.com',
path: '/sql/2.0/warehouses/',
token: 'dapi**',
})
.then(async (client) => {
const session = await client.openSession();

const queryOperation = await session.executeStatement('SELECT "Hello, World!"');
const result = await queryOperation.fetchAll();
await queryOperation.close();

console.table(result);

await session.close();
await client.close();
})
.catch((error) => {
console.log(error);
});
`

Run Tests

$3

You can run all unit tests, or specify a specific test to run:

`bash
npm test
npm test --
`

$3

Before running end-to-end tests, create a file named tests/e2e/utils/config.local.js and set the Databricks SQL connection info:

`javascript
{
host: '*.databricks.com',
path: '/sql/2.0/warehouses/*',
token: 'dapi*',
database: ['catalog', 'database'],
}
`

Then run

`bash
npm run e2e
npm run e2e --
``

Contributing

See CONTRIBUTING.md

Issues

If you find any issues, feel free to create an issue or send a pull request directly.

License

Apache License 2.0