Will Onelake and Fabric DWH support truncate option ??

S, Anil Kumar 20 Reputation points

Will Onelake and Fabric DWH support truncate option ?? Please let us know.

Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
28 questions
{count} votes

Accepted answer
  1. Rakesh Gurram 5,325 Reputation points Microsoft Vendor

    Hi S, Anil Kumar,

    Thanks for reaching out to us on the Microsoft Q&A forum.

    Currently, the truncate option is not supported in OneLake and Data Warehouse.


    Microsoft OneLake does not support the truncate option directly. Instead, you can delete, purge, or truncate data in OneLake using other methods. For example, you can use notebooks to truncate data in Lakehouse tables in Fabric. Additionally, you can load data into a staging table, perform transformations on the data in staging, and then insert the data into a production table, effectively truncating the data in the production table.

    Data Warehouse:

    Fabric Warehouse does not currently support the "TRUNCATE" statement for tables. This is a common limitation mentioned in the documentation. You can achieve a similar outcome using a "DELETE" statement.

    Please refer to the document for your reference: T-SQL surface area in Microsoft Fabric

    Hope we are able to clarify your doubt.

    If you found the information helpful, we would greatly appreciate it if you could acknowledge it by selecting the Accept Answer & Upvote options.

    2 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful