Forum Discussion

khanjaved's avatar
khanjaved
Microsoft Employee
6 months ago

T‑SQL Magic Command (%%tsql) Error in Microsoft Fabric Notebook on Fabric SQL Database

Hello, My T-SQL command executed from a Microsoft Fabric Python notebook against a Fabric SQL Database was working fine last week, but it has suddenly stopped working. There is no change from our ...
workspaces
khanjaved's avatar
khanjaved
Microsoft Employee
6 months ago

AsgerLBYes I tried, And I think with the session you can run the %tsql magic cmd in the next cell, alone with %%tsql look like its not going to be helpful.

AsgerLB's avatar
AsgerLB
Resolver I
6 months ago

khanjaved , so you can make it work by using the -session parameter in one cell and then making your query in a new %%tsql command?

  • khanjaved's avatar
    khanjaved
    Microsoft Employee
    6 months ago

    AsgerLB How it will work? for session we need to use -artifact -type cmd which itself is not working for me now. which is the main issue I posted.

    • AsgerLB's avatar
      AsgerLB
      Resolver I
      6 months ago

      khanjaved so running this 

       

      %%tsql -artifact sqldb1 -type SQLDatabase -session
SELECT TOP (10) * FROM [SalesLT].[Address]

      Does not work?

      • khanjaved's avatar
        khanjaved
        Microsoft Employee
        6 months ago

        AsgerLB  Yes not working.