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.
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.