#fabric
Lakehouse do not support stored procedure.
Lakehouse delete activity in pipeline only support delete files. We cannot delete table with delete activity.
Lakehouse SQL endpoint for delta table, and is readonly.
The only way to write/change/update data in lakehouse is use notebook, spark SQL.