Forum Discussion

pmscorca's avatar
pmscorca
Kudo Kingpin
2 years ago
Solved

Creating a table in a lakehouse and inserting rows

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 d...
lakehouse
  • AndyDDC's avatar
    AndyDDC
    2 years ago

    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

AndyDDC's avatar
AndyDDC
Most Valuable Professional
2 years ago

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's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi pmscorca 

     

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

     

    Thanks.