topic Re: Handling SQL database(PREVIEW) with notebook in SQL database

Handling SQL database(PREVIEW) with notebook

munindra — Tue, 31 Dec 2024 09:54:55 GMT

I am trying to access the sql database inside the fabric using notebook with connection string but i am getting error
('HYT00', '[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQLDriverConnect)')

Re: Handling SQL database(PREVIEW) with notebook

Anonymous — Thu, 02 Jan 2025 02:36:18 GMT

Hi munindra

You can refer to the following link to make sure that your format is right.

SQL connection with Python - Microsoft Fabric Community

And please make sure that your server name and the username and the password is right, you can refer to the following link about the connection of database.

Connect to your SQL database - Microsoft Fabric | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Handling SQL database(PREVIEW) with notebook

dlevy — Tue, 07 Jan 2025 18:56:27 GMT

Hi munindra - Here is an example that one of our private preview customers got working in their notebooks:

def run_select_query(query_text): # Define JDBC URL and connection properties jdbc_url = "jdbc:sqlserver://<server>;" \ "database=<db>;" \ "encrypt=true;trustServerCertificate=false;authentication=ActiveDirectoryServicePrincipal;" connection_properties = { "user": f"{client_id}@{tenant_id}", "password": client_secret, "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver" } # Define your SQL query query = query_text # Read data from Azure SQL Database using the query df = spark.read \ .format("jdbc") \ .option("url", jdbc_url) \ .option("dbtable", query) \ .option("user", connection_properties["user"]) \ .option("password", connection_properties["password"]) \ .option("driver", connection_properties["driver"]) \ .load() # Show the data # df.show() return df

Please feel free to make it your own, including making sure it is safe to run in your environment.

The big thing you'll notice is that this requires an Entra Service Principal. That is the only option that will work right now.

Re: Handling SQL database(PREVIEW) with notebook

munindra — Wed, 08 Jan 2025 03:48:47 GMT

thanks for reply i am able to reslove my error by changing authentication in my code to

Authentication=ActiveDirectoryPassword
and if possible can you help me with building connection with lakehouse to vscode using python to get the files present inside the lakehouse .I am unable to find proper answer for this

Re: Handling SQL database(PREVIEW) with notebook

dlevy — Wed, 08 Jan 2025 18:09:22 GMT

Have you seen this example? Access OneLake with Python - Microsoft Fabric | Microsoft Learn

The other angle would be to go through the SQL Analytics Endpoint. That will work just like a read-only SQL server so you should already have most of the code for that.

Otherwise, you may want to ask in the Lakehouse area.