topic Re: Creating a table in a lakehouse and inserting rows in Data Engineering

Creating a table in a lakehouse and inserting rows

pmscorca — Fri, 24 May 2024 18:00:53 GMT

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 — Sun, 26 May 2024 07:31:47 GMT

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 — Mon, 27 May 2024 08:28:15 GMT

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

Thanks.