Forum Discussion

jkalkbrenner's avatar
jkalkbrenner
Frequent Visitor
3 years ago
Solved

Fabric Lakehouse Drop Table

I receive the below error when I run 'drop table [dbo].[tablename]' in a Lakehouse. What am I doing wrong?   Msg 368, Level 14, State 1, Line 1 The external policy action 'Microsoft.Sql/Sqlserver...
Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    Hi jkalkbrenner 

     

    In order to drop a table in the Lakehouse you have to use a Notebook to do this. The SQL Endpoint for a lakehouse is ready only.

     

    Here it the code to do this in the Notebook

    # Syntax of DROP
DROP TABLE tableName
GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi jkalkbrenner 

 

In order to drop a table in the Lakehouse you have to use a Notebook to do this. The SQL Endpoint for a lakehouse is ready only.

 

Here it the code to do this in the Notebook

# Syntax of DROP
DROP TABLE tableName
hello_'s avatar
hello_
Helper I
2 years ago

Hello GilbertQ I am having this same error in CREATE command and don't know how to use Notebook in wharehouse (SQLEndpoint) 

Could you please assist me

  • GilbertQ's avatar
    GilbertQ
    Super User
    2 years ago

    Hi hello_ 

     

    If you are using the Warehouse then you will have to do it in the Warehouse view.

     

     

    • hello_'s avatar
      hello_
      Helper I
      2 years ago

      Hello GilbertQ , something is strange like, 
      1 - when I am in ( Lake | Wherehouse ) and writing in wherehour i am having error but 

      2 - when I am in ( Wherehouse ) and writing all seems to be fine 

       

      For now i directly created a whereHouse and working on it   

      • GilbertQ's avatar
        GilbertQ
        Super User
        2 years ago

        Hi hello_ 

         

        Yes because you can drop tables in a Warehouse via SQL but NOT in a Lakehouse.