Install the ODBC Driver 17 for SQL Server

[GJ2]

Hi,

I am not a Data Engineer, I want to connect to ssas. It looks like it can be connected through 

pyodbc. however looks like  I need to install "ODBC Driver 17 for SQL Server" using the following command. How do i install the driver on the cluster and are there any requirement to connect with SSAS ?

 

Thank you 

[Hubert-Dudek]

As SQL Server is included in the Lakehouse federation driver, it is built in databricks. Install only in case you need a different version - the built-in one is not working

[lilydays]

If you're only connecting to SSAS, installing the ODBC Driver 17 for SQL Server is usually the first step, but the exact method depends on your cluster environment and operating system. If it's a managed cluster, you may need admin access or an script to install the driver on every node. Also, make sure the correct authentication method, network access, and SSAS connectivity are configured before troubleshooting the Python code.

Thanks!