Do you know how to install the 'ODBC Driver 17 for SQL Server' on a Databricks cluster?
I'm trying to connect from a Databricks notebook to an Azure SQL Datawarehouse using the pyodbc python library. When I execute the code I get this error:
Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found (0) (SQLDriverConnect)")
I understand that I need to install this driver but I have no idea how to do it. I have a Databricks cluster runing with Runetime 6.4, Standard_DS3_v2.
Solution
By default, Azure Databricks does not have ODBC Driver installed.
Run the following commands in a single cell to install MS SQL ODBC Driver on Azure Databricks cluster.
%sh
curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -
curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list
sudo apt-get update
sudo ACCEPT_EULA=Y apt-get -q -y install msodbcsql17
- Bool object does not support item assignment
- Fetching multiple urls with aiohttp in python
- Installing pycddlib on Windows Failed building wheel
- Python 3 input eats always one character
- Show non printable characters in a string
- Best practices for using @property with Enum values on a Django model for DRF serialization
- Spliting a JSON list obj into multiple based on values in python
- Shorter way to execute some code if any case were matched Python 3.10
- Ctypes- Can't get PEB Address using NtQueryInformationProcess
- Must have equal len keys and value when setting with an iterable
- How to change Tkinter App Display Name in Ubuntu Panel?
- How to get all coordinates from kml file?
- How does one ignore extra arguments passed to a dataclass?
- How do I integrate custom exception handling with the FastAPI exception handling?
- Determine most accurate best-fit algorithm for scattered points
- Unable to Trigger Lambda function in AWS using Python code from my local setup
- Catching optional content just after a new line
- Python asyncio wait and notify
- Failed to find out the source of a certain portion of a link
- pydantic convert to jsonable dict (not full json string)
- how to update python in raspberry pi
- How do I pass command line parameters to a python prgram called from XMLHTTPRequest
- Expected output not returned for spiral coordinate computation functions (iterative and recursive)
- Python list comprehension with two loops and two conditions
- Python 3 simple HTTP server with GET functional
- Using the http.HTTPStatus class in Python to return the meaning of a HTTP status code
- Turn slice into range
- Is there a way to use asyncio.Queue in multiple threads?
- built-in range or numpy.arange: which is more efficient?
- Receiving Import Error: No Module named ***, but has __init__.py