M365 Show -  Microsoft 365 Digital Workplace Daily

M365 Show - Microsoft 365 Digital Workplace Daily

Microsoft Data Pulse: Power BI, Fabric, Purview

How to Use Create Table AS in Microsoft Fabric for Fast Data Loading

Mirko Peters - M365 Specialist's avatar
Mirko Peters - M365 Specialist
Jul 08, 2025
∙ Paid

You can use the create table as statement, or CTAS, to quickly ingest data in Microsoft Fabric. This tool lets you build a new table from a select query, which means you move data from one layer to another with speed and control. When you ingest data, you often need to create a new table for your silver or gold layers. CTAS helps you accelerate data ing…

This post is for paid subscribers

Already a paid subscriber? Sign in
© 2025 Mirko Peters
Publisher Privacy ∙ Publisher Terms
Substack
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture