Databricks Community

YOUKE · 03-17-2025

On Databricks, when I try to connect to SQL using SQLAlchemy or pyodbc to run delete queries on a specific table, I get this error: (pyodbc.Error) ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not ...

YOUKE · 11-29-2024

Hi everyone,I was trying to understand: when a managed table is created, Databricks stores the metadata in the Hive metastore and the data in the cloud storage managed by it, which in the case of Azure Databricks will be an Azure Storage Account. But...

YOUKE · 03-27-2025

I was able to solve the problem! the problem was because the driver was missing and so pyodbc or sqlAlchemy can't find it. So I used the native Java API and it is working.This is the example code:jdbcUsername = "username"jdbcPassword = "password"driv...

YOUKE · 11-29-2024

Yes, exactly. I’m trying to understand where they are stored, but it seems to me that they are present in the Hive Warehouse, which should be the storage managed by Azure Databricks using Apache Hive, it's correct?

Databricks Community

User Stats

User Activity

Connecting to SQL on Databricks Using SQLAlchemy or pyodbc

Managed Tables on Azure databricks

Re: Connecting to SQL on Databricks Using SQLAlchemy or pyodbc

Re: Managed Tables on Azure databricks