topic Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell in Data Engineering

UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

sharp1FL — Thu, 31 Jul 2025 18:20:09 GMT

I am trying to connect to our Fabric SQL orchestration database using the tsql command as documented here:

https://blog.fabric.microsoft.com/en-us/blog/connect-to-your-sql-database-in-fabric-using-python-notebook?ft=Databases:category

%%tsql -artifact <ORCH_DB_NAME> -type SQLDatabase -bind df2

SELECT * FROM dbo.<orch_tablename>

I get the following error:

UnsupportedArtifactException: Artifact type SQLDatabase is not supported to connect

This seems so simple. What am I doing incorrectly?

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

v-hashadapu — Fri, 01 Aug 2025 11:03:38 GMT

Hi @sharp1FL , Thank you for reaching out to the Microsoft Community Forum.

Microsoft Fabric notebooks do not support connecting to SQLDatabase artifacts using the %tsql magic command. %tsql in Fabric notebooks currently only supports querying data from Lakehouse and Warehouse artifacts. Attempting to use any other artifact type will result in this exact exception.

Ensure your orchestration data is available in a supported artifact like a Warehouse or Lakehouse, then modify your code as follows:

%%tsql -artifact MyWarehouse -bind df2

SELECT * FROM dbo.my_table

Author and run T-SQL notebooks in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Run T-SQL code in Fabric Python notebooks - Microsoft Fabric | Microsoft Learn

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

BhaveshPatel — Sun, 03 Aug 2025 09:42:34 GMT

Hi @sharp1FL

You should understand that difference between data lake, delta lake and linux operating system. Before going ahead,

Here you have to use T-SQL in Fabric Warehouse.

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

v-hashadapu — Mon, 04 Aug 2025 11:35:19 GMT

Hi @sharp1FL , hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

sharp1FL — Mon, 04 Aug 2025 12:51:56 GMT

Thanks for the clarification, though I am disappointed.

I'm using SQL because it makes more sense than delta for orchestration. Would there be additional overhead or performance implications for using the data warehouse artifact for CRUD operations on the orchestration tables?

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

sharp1FL — Mon, 04 Aug 2025 13:10:04 GMT

I dug a little more, and it appears that the documentation beat the availability of this feature for SQL databases.

From @sukkaur "Team is working on this capability and this should be coming available for customers use by next month."

How to connect to Fabric database from fabric note... - Microsoft Fabric Community

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

v-hashadapu — Tue, 05 Aug 2025 05:12:59 GMT

Hi @sharp1FL , Thank you for reaching out to the Microsoft Community Forum.

Yes, using a Warehouse for orchestration tables works, but it’s not a perfect substitute for a SQL database. Fabric Warehouses are optimized for analytical queries, not transactional operations. Frequent INSERT/UPDATE/DELETEs can be slower and less efficient than in a SQL database and transactional guarantees (like row-level locking) are limited.

For light or batched orchestration logic (e.g., logging or status updates), it’s a workable short-term solution. But for high-frequency or dependency-sensitive writes, you may hit performance limits. Once SQL database support in notebooks is live, it’ll be the better fit.

Limitations of Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

ernie8925 — Wed, 13 Aug 2025 13:14:59 GMT

According to this page it is supported:

https://blog.fabric.microsoft.com/en-us/blog/connect-to-your-sql-database-in-fabric-using-python-notebook/

I get the same error as @sharp1FL however.

Anyone here able to use the feature as described in that blog page?

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

sukkaur — Fri, 15 Aug 2025 15:12:14 GMT

@sharp1FL - Please try TSQL magic command again. There was an error and it's fixed. Thanks

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

sukkaur — Fri, 15 Aug 2025 15:13:14 GMT

@ernie8925 - Please try this capability again. This should work now. There was an error that team just finished fixing. Thanks

Re: UnsupportedArtifactException SQLDatabase in Python notebook tsql cell

ernie8925 — Mon, 18 Aug 2025 05:43:14 GMT

It works now! Thanks!