Search code examples
azureazure-synapse

Not able to create table in Azure Synapse Analytics

I am new in Azure Synapse Analytics. I have created database in workspace but when I am trying to create a new table it is showing below error.

Failed to execute query. Error: CREATE TABLE <table_name> is not supported.

Attaching screenshot of error and query.

enter image description here

Solution

  • it seems that you are connected to the built-in SQL serverless pool.

    The Serverless SQL pool has no local storage, only metadata objects are stored in databases. Therefore, T-SQL related to the following concepts isn't supported:

    Tables
Triggers
Materialized views
DDL statements other than ones related to views and security
DML statements

    You can use CETAS - CREATE EXTERNAL TABLE AS SELECT or instead you can create a provisioned SQL Pool.