Blog Post

Azure Synapse Analytics Blog
6 MIN READ

How to use CETAS on serverless SQL pool to improve performance and automatically recreate it

Liliam_C_Leme's avatar
Liliam_C_Leme
Icon for Microsoft rankMicrosoft
Jul 19, 2022
Serverless SQL pool  has a very cool way to handle CREATE EXTERNAL TABLE AS SELECT (CETAS).  I mean, you can use a serverless SQL pool to create a CETAS which will materialize the query results. It m...
Updated Jul 06, 2022
Version 1.0
Synapse SQL
Alex_Morein's avatar
Alex_Morein
Copper Contributor
Sep 27, 2022

@Thomas Pagel A usage pattern that might suit your needs could be to treat the CETAS output file like "staging" location. In the Data Pipeline coordinating everything, have a final Copy Activity to copy the CETAS output to a "trusted" folder/location that is referenced by BI consumers, overwriting any existing file there.