Fabric Lakehouse Drop Table

[jkalkbrenner]

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/Sqlservers/Databases/Schemas/Tables/Drop' was denied on the requested resource.
Msg 3701, Level 14, State 20, Line 1
Cannot drop the table '<table name>', because it does not exist or you do not have permission.
Statement ID: {EDB6B91A-18D2-4654-A0D0-7C8771B934A7}

Completion time: 2023-06-28T16:02:43.1676935-04:00

[GilbertQ · Accepted solution]

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_]

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]

Hi @hello_ 

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

[hello_]

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]

Hi @hello_ 

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

[jkalkbrenner]

Thank you @GilbertQ !
Spark SQL did indeed drop the table!

drop table <lakehousename>.<tablename>