Databricks SQL Connector for Python

Navigation

Verified details

These details have been verified by PyPI
Maintainers
Avatar for benc-db from gravatar.com benc-db Avatar for jprakash-db from gravatar.com jprakash-db Avatar for juliuszsompolski from gravatar.com juliuszsompolski Avatar for moderakh from gravatar.com moderakh Avatar for sgoos-db from gravatar.com sgoos-db Avatar for yunbo.deng from gravatar.com yunbo.deng

Unverified details

These details have not been verified by PyPI
Project links
Meta
  • License: Apache Software License (http://www.apache.org/licenses/LICENSE-2.0)
  • Author: Databricks
  • Requires: Python >=3.7
Classifiers
Report project as malware

Project description

Databricks SQL Connector for Python

Status: Private preview

Documentation can be found here: Databricks SQL Connector for Python.

About

The Databricks SQL Connector is a Python library that allows you to use Python code to run SQL commands on Databricks clusters and Databricks SQL endpoints. This library follows PEP 249 -- Python Database API Specification v2.0.

Quickstart

Install the library with pip install databricks-sql-connector

Example usage:

from databricks import sql

connection = sql.connect(
  server_hostname='<server-hostname>',
  http_path='<http-path>',
  access_token='<personal-access-token>')

cursor = connection.cursor()

cursor.execute('SELECT * FROM RANGE(10)')
result = cursor.fetchall()
for row in result:
  print(row)

cursor.close()
connection.close()

Where:

  • <server-hostname> is the Databricks instance host name.
  • <http-path> is the HTTP Path either to a Databricks SQL endpoint (e.g. /sql/1.0/endpoints/1234567890abcdef), or to a Databricks Runtime interactive cluster (e.g. /sql/protocolv1/o/1234567890123456/1234-123456-slid123)
  • <personal-access-token> is a HTTP Bearer access token, e.g. a Databricks Personal Access Token.

For more information, see Databricks documentation.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page