Databricks SQL Connector for Python
Project description
Databricks SQL Connector for Python
Status: Generally available
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.
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
File details
Details for the file databricks-sql-connector-1.0.1.tar.gz.
File metadata
- Download URL: databricks-sql-connector-1.0.1.tar.gz
- Upload date:
- Size: 39.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.7.1 importlib_metadata/4.6.3 pkginfo/1.8.2 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | 9f423af927167a0f7adc4ea80d86018ab984131cb12ea6f6839a4f104f206a9c |
|
| MD5 | 2df22a3c15b5665887ec6fa028f4b14e |
|
| BLAKE2b-256 | b1c54a8415025b4dfbf4109ca17105240ec01ae6d9600d133ee4ccd6adc30246 |
File details
Details for the file databricks_sql_connector-1.0.1-py3-none-any.whl.
File metadata
- Download URL: databricks_sql_connector-1.0.1-py3-none-any.whl
- Upload date:
- Size: 43.4 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/3.7.1 importlib_metadata/4.6.3 pkginfo/1.8.2 requests/2.26.0 requests-toolbelt/0.9.1 tqdm/4.62.3 CPython/3.9.7
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 | eddc66f474d79e20d7a37a0ea1fd07406f9f78d8278cb9f0e177256901de44f6 |
|
| MD5 | 5c431be58d2eee26f16d09a57048fb1b |
|
| BLAKE2b-256 | 470d0c53b28aa7232a26b9a66aea68746114fbb49a5d403402df7bce48cb787c |
