skills.rest
databricks-solutions
databricks-solutionsOFFICIAL
Explore all skills by this author →
GitHub

databricks-isv-python-sql-connector

Configure PWAF-compliant Databricks SQL connections from Python using databricks-sql-connector.

5|1|Updated Apr 8, 2026
Search Tags:#python#pkce#databricks#pwaf#sql-connector#oauth-m2m#oauth-u2m
One-click install
npx skills add https://github.com/databricks-solutions/partner-ai-dev-kit --skill databricks-isv-python-sql-connector
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-isv-python-sql-connector
Source: https://github.com/databricks-solutions/partner-ai-dev-kit/tree/main/skills/python-sql-connector
Command: npx skills add https://github.com/databricks-solutions/partner-ai-dev-kit --skill databricks-isv-python-sql-connector

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Facilitate PWAF-aligned Python SQL Connector integrations to securely access Databricks SQL warehouses from Python applications, reducing setup complexity and risk.

Core Features & Use Cases

  • PWAF-aligned authentication patterns for Python SQL connections to Databricks SQL warehouses.
  • Comprehensive guidance for multiple auth flows (PAT for testing, OAuth M2M for production, OAuth U2M with PKCE for interactive flows, and token-env for headless CI).
  • Environment, security, and telemetry guidance with practical configuration examples and error-handling strategies.
  • Examples and integration references for using the databricks-sql-connector with Databricks SQL.

Quick Start

Run a sample script to connect to a Databricks SQL warehouse and execute a simple query.

Frequently Asked Questions about databricks-isv-python-sql-connector

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I connect Python to a Databricks SQL warehouse using OAuth?▼

To connect Python to a Databricks SQL warehouse using OAuth, configure the databricks-sql-connector with OAuth M2M for production or OAuth U2M with PKCE for interactive flows to ensure secure access.

What is PWAF compliance for Databricks SQL connectors?▼

PWAF compliance for Databricks SQL connectors ensures secure, standardized authentication and configuration when integrating Python applications with Databricks SQL warehouses in ISV-partner scenarios.

Can I use the databricks-sql-connector for headless CI authentication?▼

Yes, you can use the databricks-sql-connector for headless CI authentication by configuring the token-env auth flow, which supports secure automated environments without interactive login.

Which authentication flow should I use for Databricks Python integrations?▼

Use PAT for testing, OAuth M2M for production service accounts, OAuth U2M with PKCE for interactive user logins, and token-env for headless CI when building Databricks Python integrations.

How do I handle errors in a Python Databricks SQL connection?▼

Handle errors in a Python Databricks SQL connection by applying robust error-handling strategies provided by the databricks-sql-connector, covering authentication failures and query execution issues.

Does the Python SQL connector support telemetry integration for Databricks?▼

Yes, the Python SQL connector supports telemetry integration for Databricks, offering environment and security guidance to configure tracking alongside your SQL workloads.

Related Skills

Explore More Software Engineering Skills→
databricks-solutionsdatabricks-solutions
5

databricks-isv-go-sql-driver

Enable PWAF-compliant SQL queries against Databricks using the Go SQL Driver.

Official
Advanced
sourcegraphsourcegraph
16

bigquery

Run BigQuery SQL queries and export results using the bq CLI.

Official
Advanced
camoneartcamoneart
5

grafana-dashboards

Design and deploy Grafana dashboards for real-time system and application metrics.

Community
Intermediate
databricks-solutionsdatabricks-solutions
5

databricks-isv-java-sdk

Automate PWAF-aligned Databricks Java SDK integration for authentication and workspace management.

Official
Advanced