Databricks - Example querying using Databricks SQL Connector for Python.

databricks_sql_query_example.py

from databricks import sql
import os

# Retrieve environment variables
server_hostname = os.getenv("DATABRICKS_SERVER_HOSTNAME")
http_path = os.getenv("DATABRICKS_HTTP_PATH")
access_token = os.getenv("DATABRICKS_TOKEN")

# Establish a connection to the Databricks SQL warehouse
with sql.connect(server_hostname=server_hostname, http_path=http_path, access_token=access_token) as connection:
    # Create a cursor object using the connection
    with connection.cursor() as cursor:
        # Execute the SELECT query
        cursor.execute("SELECT * FROM your_table_name LIMIT 10")

        # Fetch all results from the executed query
        result = cursor.fetchall()

        # Print the results
        for row in result:
            print(row)

notes.txt

https://docs.databricks.com/en/dev-tools/python-sql-connector.html