CETAS availability

Priya Jha 866 Reputation points
2022-10-07T14:50:12.183+00:00

Hi All,

SQL 2016 and onwards Polybase functionality is available. Can someone clarify whether CETAS is supported in SQL 2016 or is it just supported in SQL 2022.

@Alberto Morillo @Ronen Ariely

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,697 questions
{count} votes

1 additional answer

Sort by: Most helpful
  1. Seeya Xi-MSFT 16,436 Reputation points
    2022-10-10T02:58:09.947+00:00

    Hi @Priya Jha ,

    The CETAS stands for CREATE EXTERNAL TABLE AS SELECT that allows to create an external table and export data into Hadoop or Azure Blob Storage. It is an acronym. Also, this available only with Azure SQL Data Warehouse and Parellel Data Warehouse. As NandanHegde-7720 found the document, it applies to: SQL Server 2022 (16.x) Preview and later.
    In addition, you may be mixed up with CREATE EXTERNAL TABLE.

    Best regards,
    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    2 people found this answer helpful.
    0 comments No comments