Creating a table in a lakehouse and inserting rows

[pmscorca]

Hi,

I'd like to know if it is possible to create a SQL table in a lakehouse (no warehouse) and inserting some rows as a insert t-sql statement.

F.e. I could want to create a table having code and description columns to feed by some established values by an insert statement.

Thanks

[AndyDDC · Accepted solution]

Hi @pmscorca so you won't be able to use the SQL Endpoint of the Lakehouse to use T-SQL to modify data as it's read only.

Hiwever you can use Spark SQL in Notebooks to run SQL against the lakehouse and insert/update/delete data

[v-cboorla-msft]

Hi @pmscorca 

Glad that you query got resolved.
Please continue using Fabric Community for further queries.

Thanks.