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?