Creating a table in a lakehouse and inserting rows

Question

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 Answer

Hi&nbsp;pmscorca&nbsp;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.&nbsp;Hiwever you can use Spark SQL in Notebooks to run SQL against the lakehouse and insert/update/delete data

Forum Discussion

Creating a table in a lakehouse and inserting rows

2 Replies

Related content

Issue Creating Lakehouse

Lakehouse Table Generate Create Table

merge or update/insert lakehouse table from another lakehouse table

Copy Data Upsert to Lakehouse Inserting instead of Updating

can't create table in Lakehouse