matlab-connect-databricks-jdbc

Establish JDBC connections from MATLAB to Databricks clusters and SQL Warehouses.

883|109|Updated Apr 3, 2026
One-click install
npx skills add https://github.com/matlab/matlab-agentic-toolkit --skill matlab-connect-databricks-jdbc
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: matlab-connect-databricks-jdbc
Source: https://github.com/matlab/matlab-agentic-toolkit/tree/main/skills-catalog/reporting-and-database-access/matlab-connect-databricks-jdbc
Command: npx skills add https://github.com/matlab/matlab-agentic-toolkit --skill matlab-connect-databricks-jdbc

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill eliminates the trial-and-error involved in establishing reliable Databricks connectivity from MATLAB, including the correct authentication setup and JDBC driver selection.

Core Features & Use Cases

  • JDBC connection establishment: Connects MATLAB to Databricks clusters and SQL Warehouses using Database Toolbox over JDBC.
  • Authentication configuration: Supports PAT, OauthU2M, and OauthM2M, including safe handling via the unified provider chain and .databrickscfg/environment variables.
  • Driver selection and performance tuning: Chooses between Simba and OSS JDBC drivers (including Java 11+ requirements) and applies write-performance optimizations for large transfers.

Use cases include reading and writing tables from MATLAB (sqlread/fetch/sqlwrite/execute), integrating with Unity Catalog naming rules, setting up Database Explorer sources, and handling on-Databricks browser-based OAuth constraints.

Quick Start

Use the matlab-connect-databricks-jdbc skill to create a JDBCConnection to a Databricks cluster and query data using sqlread, then close the connection when finished.

Frequently Asked Questions about matlab-connect-databricks-jdbc

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

FAQPage Schema
How do I connect MATLAB to Databricks using a JDBC driver?

You connect MATLAB to Databricks by configuring a JDBC connection through Database Toolbox, utilizing the correct driver and authentication method like PAT or OAuth for secure cluster and SQL Warehouse access.

What authentication methods are supported for a MATLAB Databricks JDBC connection?

Supported authentication methods for a MATLAB Databricks JDBC connection include PAT, OAuthU2M, and OAuthM2M, which are safely handled through a unified provider chain using .databrickscfg or environment variables.

Can I use OAuth to connect MATLAB to a Databricks SQL Warehouse?

Yes, you can use OAuth to connect MATLAB to a Databricks SQL Warehouse by configuring OAuthU2M or OAuthM2M via the unified auth provider chain, which also safely handles on-Databricks browser-based OAuth constraints.

What is the best way to tune JDBC driver performance for large data writes in MATLAB?

The best way to tune JDBC driver performance for large data writes in MATLAB is to apply write-performance optimizations during transfer and correctly select between Simba and OSS JDBC drivers based on your Java environment.

Why does my MATLAB JDBC connection to Databricks fail with Java 11 errors?

Your MATLAB JDBC connection to Databricks might fail with Java 11 errors because specific OSS JDBC drivers require Java 11 or higher, making proper driver selection between Simba and OSS critical for successful connectivity.

How do I verify and close a Databricks JDBC connection in MATLAB?

To verify and close a Databricks JDBC connection in MATLAB, you use connection verification methods like j.testConnection() or j.Connection.Message, and execute close(j) to safely clean up the connection when finished.