<html>
<head>
<title>Synapse FAQ</title>
</head>
<body>
<div>
<h1>how to get started</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started'>get started</a><p>
<h1>how to create a synapse workspace</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-create-workspace'> create a synapse workspace</a><p>
<h1>how to analyze using serverless sql pool</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-analyze-sql-on-demand'> analyze using serverless sql pool</a><p>
<h1>how to analyze using a data explorer pool</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-analyze-data-explorer'> analyze using a data explorer pool</a><p>
<h1>how to analyze using a serverless spark pool</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-analyze-spark'> analyze using a serverless spark pool</a><p>
<h1>how to analyze using a dedicated sql pool</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-analyze-sql-pool'> analyze using a dedicated sql pool</a><p>
<h1>how to analyze data in a storage account</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-analyze-storage'> analyze data in a storage account</a><p>
<h1>how to integrate with pipelines</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-pipelines'> integrate with pipelines</a><p>
<h1>how to visualize with power bi</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-visualize-power-bi'> visualize with power bi</a><p>
<h1>how to monitor</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-monitor'> monitor</a><p>
<h1>how to explore the knowledge center</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-knowledge-center'> explore the knowledge center</a><p>
<h1>how to add an administrator</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/get-started-add-admin'> add an administrator</a><p>
<h1>how to create workspace using azure portal</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/quickstart-create-workspace'>azure portal</a><p>
<h1>how to create workspace using azure cli</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/quickstart-create-workspace-cli'>azure cli</a><p>
<h1>how to create workspace using azure powershell</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/quickstart-create-workspace-powershell'>azure powershell</a><p>
<h1>how to create workspace using arm template</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/quickstart-deployment-template-workspaces'>arm template</a><p>
<h1>how to use serverless sql pool to analyze data</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/tutorial-data-analyst'>use serverless sql pool to analyze data</a><p>
<h1>how to create logical data warehouse with serverless sql pool</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/tutorial-logical-data-warehouse'>create logical data warehouse with serverless sql pool</a><p>
<h1>how to power bi desktop</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/tutorial-connect-power-bi-desktop'>power bi desktop</a><p>
<h1>how to query csv files</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-single-csv-file'>query csv files</a><p>
<h1>how to query parquet files</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-parquet-files'>query parquet files</a><p>
<h1>how to query json files</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-json-files'>query json files</a><p>
<h1>how to query nested types</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-parquet-nested-types'>query nested types</a><p>
<h1>how to query delta lake</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-delta-lake-format'>query delta lake</a><p>
<h1>how to query folders and multiple files</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-folders-multiple-csv-files'>query folders and multiple files</a><p>
<h1>how to query partitioned files using file metadata</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-specific-files'>query partitioned files using file metadata</a><p>
<h1>how to create and use views</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/create-use-views'>create and use views</a><p>
<h1>how to create and use external tables</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/create-use-external-tables'>create and use external tables</a><p>
<h1>how to store query results to storage</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/create-external-table-as-select'>store query results to storage</a><p>
<h1>how to configure synapse link</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/../cosmos-db/configure-synapse-link?context=/azure/synapse-analytics/context/context'>configure synapse link</a><p>
<h1>how to connect to azure synapse link for cosmos db</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/synapse-link/how-to-connect-synapse-link-cosmos-db'>connect to azure synapse link for cosmos db</a><p>
<h1>how to use power bi and serverless sql pool to analyze azure cosmos db</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/../cosmos-db/synapse-link-power-bi?context=/azure/synapse-analytics/context/context'>use power bi and serverless sql pool to analyze azure cosmos db</a><p>
<h1>how to query azure cosmos db analytical store with apache spark </h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark-3'>query azure cosmos db analytical store with apache spark </a><p>
<h1>how to query azure cosmos db analytical store with apache spark </h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/synapse-link/how-to-query-analytical-store-spark'>query azure cosmos db analytical store with apache spark </a><p>
<h1>how to copy data from synapse link into a dedicated sql pool using apache spark</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/synapse-link/how-to-copy-to-sql-pool'>copy data from synapse link into a dedicated sql pool using apache spark</a><p>
<h1>how to query azure cosmos db analytical store with serverless sql pool</h1><p>See <a href='https://docs.microsoft.com/azure/synapse-analytics/sql/query-cosmos-db-analytical-store?context=/azure/synapse-analytics/context/context'>query azure cosmos db analytical store with serverless sql pool</a><p>
<div><h1>Tables available supported Serverless</h1><div>No, the in-database tables are not supported. Serverless SQL pool can query only <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-tables-external-tables?tabs=native" data-linktype="relative-path">external tables</a> that reference data placed on <a href="https://docs.microsoft.com/azure/synapse-analytics/#storage-options" data-linktype="self-bookmark">Azure Storage</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Views available supported Serverless</h1>
<div>
<a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-view-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Yes</a>, you can create views over <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-tables-external-tables?tabs=native" data-linktype="relative-path">external tables</a> and other views. Views can use <a href="https://docs.microsoft.com/azure/synapse-analytics/#query-language" data-linktype="self-bookmark">query language elements</a> that are available in serverless model. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.
</div>
</div>
<br><hr/></br>
<div><h1>Schemas available supported Serverless</h1><div><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-schema-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Yes</a>, schemas are supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Temporary tables available supported Serverless</h1><div>No, temporary tables might be used just to store some information from system views. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>User defined procedures available supported Serverless</h1><div>Yes, stored procedures can be placed in any user databases (not <code>master</code> database). For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>User defined functions available supported Serverless</h1><div>Yes, only inline table-valued functions. Scalar user-defined functions are not supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Triggers available supported Serverless</h1><div>No, serverless SQL pools do not allow changing data, so the triggers cannot react on data changes. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>External tables available supported Serverless</h1><div><a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Yes</a>. See the supported <a href="https://docs.microsoft.com/azure/synapse-analytics/#data-formats" data-linktype="self-bookmark">data formats</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Caching queries available supported Serverless</h1><div>No. Only file statistics are cached. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Table variables available supported Serverless</h1><div>No, table variables are not supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Table distribution available supported Serverless</h1><div>No, table distributions are not supported. See <strong><a href="https://docs.microsoft.com/azure/synapse-analytics/../sql-data-warehouse/sql-data-warehouse-tables-distribute?context=/azure/synapse-analytics/context/context" data-linktype="relative-path">Table distribution</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Table indexes available supported Serverless</h1><div>No, indexes are not supported. See <strong><a href="https://docs.microsoft.com/azure/synapse-analytics/../sql-data-warehouse/sql-data-warehouse-tables-index?context=/azure/synapse-analytics/context/context" data-linktype="relative-path">Table indexes</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Table partitioning available supported Serverless</h1><div>External tables do not support partitioning. You can partition files using Hive-partition folder structure and create partitioned tables in Spark. The Spark partitioning will be <a href="https://docs.microsoft.com/azure/synapse-analytics/../metadata/table" data-linktype="relative-path">synchronized with the serverless pool</a>. If you are not using Spark, you can partition your files in folder structure and can create <a href="https://docs.microsoft.com/azure/synapse-analytics/create-use-views#partitioned-views" data-linktype="relative-path">partitioned views</a> on folder partition structure, but external tables cannot be created on partitioned folders. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Statistics available supported Serverless</h1><div>Yes, statistics are <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-tables-statistics#statistics-in-serverless-sql-pool" data-linktype="relative-path">created on external files</a>. See <strong><a href="https://docs.microsoft.com/azure/synapse-analytics/develop-tables-statistics" data-linktype="relative-path">Statistics</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Workload management, resource classes, and concurrency control available supported Serverless</h1><div>No, serverless SQL pool automatically manages the resources. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Cost control available supported Serverless</h1><div>Yes, using <a href="https://docs.microsoft.com/azure/synapse-analytics/data-processed#cost-control" data-linktype="relative-path">the Azure portal or T-SQL procedure</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>SELECT statement available supported Serverless</h1><div>Yes, but some Transact-SQL query clauses like <a href="https://docs.microsoft.com/en-us/sql/t-sql/queries/select-for-clause-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">FOR XML</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/queries/match-sql-graph?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">MATCH</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/queries/predict-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">PREDICT</a>, GROUPNG SETS, and query hints are not supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>INSERT statement available supported Serverless</h1><div>No, upload new data to Data lake using Spark or other tools. Use Cosmos DB with the analytical storage for highly transactional workloads. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>UPDATE statement available supported Serverless</h1><div>No, but Parquet/CSV data updated using Spark is automatically available in serverless pool. Use Cosmos DB with the analytical storage for highly transactional workloads. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>DELETE statement available supported Serverless</h1><div>No, but Parquet/CSV data deleted using Spark is automatically available in serverless pool. Use Cosmos DB with the analytical storage for highly transactional workloads. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>MERGE statement available supported Serverless</h1><div>No, but Parquet/CSV data merged using Spark is automatically available in serverless pool. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Transactions available supported Serverless</h1><div>Yes, applicable only on the meta-data objects. See <strong><a href="https://docs.microsoft.com/azure/synapse-analytics/develop-transactions" data-linktype="relative-path">Transactions</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Labels available supported Serverless</h1><div>No See <strong><a href="https://docs.microsoft.com/azure/synapse-analytics/develop-label" data-linktype="relative-path">Labels</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Data load available supported Serverless</h1><div>No, you can initially load data into an external table using CETAS statement. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Data export available supported Serverless</h1><div>Yes. Using <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">CETAS</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Types available supported Serverless</h1><div>Yes, all Transact-SQL types except <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/cursor-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">cursor</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/hierarchyid-data-type-method-reference?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">hierarchyid</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/ntext-text-and-image-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">ntext, text, and image</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/rowversion-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">rowversion</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/spatial-geometry/spatial-types-geometry-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Spatial Types</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/data-types/sql-variant-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">sql_variant</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/xml/xml-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">xml</a>, and Table type. See how to <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-openrowset#type-mapping-for-parquet" data-linktype="relative-path">map Parquet column types to SQL types here</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Cross-database queries available supported Serverless</h1><div>Yes, 3-part-name references are supported including <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/use-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">USE</a> statement. The queries can reference the serverless SQL databases or the Lake databases in the same workspace. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Built-in/system functions (analysis) available supported Serverless</h1><div>Yes, all Transact-SQL <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/analytic-functions-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Analytic</a>, Conversion, <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/date-and-time-data-types-and-functions-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Date and Time</a>, Logical, <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/mathematical-functions-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Mathematical</a> functions. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Built-in/system functions (string) available supported Serverless</h1><div>Yes. All Transact-SQL <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">String</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/json-functions-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">JSON</a>, and Collation functions. See <strong>Built-in/system functions (<a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/string-functions-transact-sql" data-linktype="absolute-path">string</a>)</strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Built-in/system functions (Cryptographic) available supported Serverless</h1><div><code>HASHBYTES</code> is the only supported cryptographic function in serverless SQL pools. See <strong>Built-in/system functions (<a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/cryptographic-functions-transact-sql" data-linktype="absolute-path">Cryptographic</a>)</strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Built-in/system table-value functions available supported Serverless</h1><div>Yes, <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/functions?view=azure-sqldw-latest&preserve-view=true#rowset-functions" data-linktype="absolute-path">Transact-SQL Rowset functions</a>, except <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/openxml-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">OPENXML</a>, <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/opendatasource-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">OPENDATASOURCE</a>, and <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/openquery-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">OPENQUERY</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Built-in/system aggregates available supported Serverless</h1><div>All Transact-SQL built-in <a href="https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15" data-linktype="absolute-path">aggregates</a> are supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Operators available supported Serverless</h1><div>Yes, all <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/operators-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Transact-SQL operators</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Control of flow available supported Serverless</h1><div>Yes. All <a href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/control-of-flow?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Transact-SQL Control-of-flow statement</a> SELECT query in <code>WHILE (...)</code> condition For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>DDL statements (CREATE, ALTER, DROP) available supported Serverless</h1><div>Yes. All Transact-SQL DDL statement applicable to the supported object types For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Logins available supported Serverless</h1><div>Yes server-level Azure AD and SQL logins are supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Users available supported Serverless</h1><div>Yes For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Contained users available supported Serverless</h1><div>No See <strong><a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/contained-database-users-making-your-database-portable?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Contained users</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>SQL username/password authentication available supported Serverless</h1><div>Yes, users can access serverless SQL pool using their usernames and passwords. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure Active Directory (Azure AD) authentication available supported Serverless</h1><div>Yes, Azure AD logins and users can access serverless SQL pools using their Azure AD identities. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Storage Azure Active Directory (Azure AD) passthrough authentication available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/develop-storage-files-storage-access-control?tabs=user-identity#supported-storage-authorization-types" data-linktype="relative-path">Yes</a>, applicable to Azure AD logins. The identity of the Azure AD user is passed to the storage if a credential is not specified. Azure AD passthrough authentication is not available for the SQL users. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Storage SAS token authentication available supported Serverless</h1><div>Yes, using <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">DATABASE SCOPED CREDENTIAL</a> in <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">EXTERNAL DATA SOURCE</a> or instance-level <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/create-credential-transact-sql?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">CREDENTIAL</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Storage Access Key authentication available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Storage Managed Identity authentication available supported Serverless</h1><div>Yes, using <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-storage-files-storage-access-control?tabs=managed-identity#database-scoped-credential" data-linktype="relative-path">Managed Identity</a> credential. See <strong>Storage <a href="https://docs.microsoft.com/azure/synapse-analytics/../../data-factory/data-factory-service-identity?context=/azure/synapse-analytics/context/context&tabs=synapse-analytics" data-linktype="relative-path">Managed Identity</a> authentication</strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Storage Application identity/Service principal (SPN) authentication available supported Serverless</h1><div>Yes, you can create a <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-storage-files-storage-access-control?tabs=service-principal#database-scoped-credential" data-linktype="relative-path">credential</a> with a <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-storage-files-storage-access-control?tabs=service-principal#supported-storage-authorization-types" data-linktype="relative-path">service principal application ID</a> that will be used to authenticate on the storage. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Server-level roles available supported Serverless</h1><div>Yes, sysadmin, public, and other server-roles are supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>SERVER SCOPED CREDENTIAL available supported Serverless</h1><div>Yes, the server scoped credentials are used by the <code>OPENROWSET</code> function that do not uses explicit data source. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Permissions - Server-level available supported Serverless</h1><div>Yes, for example, <code>CONNECT ANY DATABASE</code> and <code>SELECT ALL USER SECURABLES</code> enable a user to read data from any databases. See <strong>Permissions - <a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles" data-linktype="absolute-path">Server-level</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Database-scoped roles available supported Serverless</h1><div>Yes, you can use <code>db_owner</code>, <code>db_datareader</code> and <code>db_ddladmin</code> roles. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>DATABASE SCOPED CREDENTIAL available supported Serverless</h1><div>Yes, used in external data sources. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Permissions - Database-level available supported Serverless</h1><div>Yes See <strong>Permissions - <a href="https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=azure-sqldw-latest&preserve-view=true" data-linktype="absolute-path">Database-level</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Permissions - Schema-level available supported Serverless</h1><div>Yes, including ability to GRANT, DENY, and REVOKE permissions to users/logins on the schema For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Permissions - Object-level available supported Serverless</h1><div>Yes, including ability to GRANT, DENY, and REVOKE permissions to users/logins on the system objects that are supported For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Permissions - Column-level security available supported Serverless</h1><div>Yes See <strong>Permissions - <a href="https://docs.microsoft.com/azure/synapse-analytics/../sql-data-warehouse/column-level-security?bc=/azure/synapse-analytics/breadcrumb/toc.json&toc=/azure/synapse-analytics/toc.json" data-linktype="relative-path">Column-level security</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Built-in/system security & identity functions available supported Serverless</h1><div>Some Transact-SQL security functions and operators: <code>CURRENT_USER</code>, <code>HAS_DBACCESS</code>, <code>HAS_PERMS_BY_NAME</code>, <code>IS_MEMBER', 'IS_ROLEMEMBER</code>, <code>IS_SRVROLEMEMBER</code>, <code>SESSION_USER</code>, <code>SESSION_CONTEXT</code>, <code>SUSER_NAME</code>, <code>SUSER_SNAME</code>, <code>SYSTEM_USER</code>, <code>USER</code>, <code>USER_NAME</code>, <code>EXECUTE AS</code>, and <code>REVERT</code>. Security functions cannot be used to query external data (store the result in variable that can be used in the query). For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Row-level security available supported Serverless</h1><div>No built-in support. Use custom views as a <a href="https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/how-to-implement-row-level-security-in-serverless-sql-pools/ba-p/2354759" data-linktype="external">workaround</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Transparent Data Encryption (TDE) available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Data Discovery & Classification available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Vulnerability Assessment available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Auditing available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/../../azure-sql/database/auditing-overview" data-linktype="relative-path">Yes</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Firewall rules available supported Serverless</h1><div>Yes, the firewall rules can be set on serverless SQL endpoint. See <strong><a href="https://docs.microsoft.com/azure/synapse-analytics/../security/synapse-workspace-ip-firewall" data-linktype="relative-path">Firewall rules</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Private endpoint available supported Serverless</h1><div>Yes, the private endpoint can be set on serverless SQL pool. See <strong><a href="https://docs.microsoft.com/azure/synapse-analytics/../security/synapse-workspace-managed-private-endpoints" data-linktype="relative-path">Private endpoint</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Synapse Studio available supported Serverless</h1><div>Yes, SQL scripts. Use SSMS or ADS instead of Synapse Studio if you are returning a large amount of data as a result. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Power BI available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/tutorial-connect-power-bi-desktop" data-linktype="relative-path">Yes</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure Analysis Service available supported Serverless</h1><div>Yes For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure Data Studio available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/get-started-azure-data-studio" data-linktype="relative-path">Yes</a>, version 1.18.0 or higher. SQL scripts and SQL Notebooks are supported. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>SQL Server Management Studio available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/get-started-ssms" data-linktype="relative-path">Yes</a>, version 18.5 or higher For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Internal storage available supported Serverless</h1><div>No, data is placed in Azure Data Lake or Cosmos DB analytical storage. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure Data Lake v2 available supported Serverless</h1><div>Yes, you can use external tables and the <code>OPENROWSET</code> function to read data from ADLS. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure Blob Storage available supported Serverless</h1><div>Yes, you can use external tables and the <code>OPENROWSET</code> function to read data from Azure Blob Storage. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure SQL/SQL Server (remote) available supported Serverless</h1><div>No, serverless SQL pool cannot reference Azure SQL database. You can reference serverless SQL pools from Azure SQL using <a href="https://devblogs.microsoft.com/azure-sql/read-azure-storage-files-using-synapse-sql-external-tables/" data-linktype="external">elastic queries</a> or <a href="https://devblogs.microsoft.com/azure-sql/linked-server-to-synapse-sql-to-implement-polybase-like-scenarios-in-managed-instance" data-linktype="external">linked servers</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Dataverse available supported Serverless</h1><div>Yes, using <a href="https://docs.microsoft.com/en-us/powerapps/maker/data-platform/azure-synapse-link-data-lake" data-linktype="absolute-path">Synapse link</a>. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure CosmosDB transactional storage available supported Serverless</h1><div>No, use Spark pools to update the Cosmos DB transactional storage. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Azure CosmosDB analytical storage available supported Serverless</h1><div>Yes, using <a href="https://docs.microsoft.com/azure/synapse-analytics/../../cosmos-db/synapse-link?bc=/azure/synapse-analytics/breadcrumb/toc.json&toc=/azure/synapse-analytics/toc.json" data-linktype="relative-path">Synapse Link</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Apache Spark tables (in workspace) available supported Serverless</h1><div>Only PARQUET and CSV tables using <a href="https://docs.microsoft.com/azure/synapse-analytics/develop-storage-files-spark-tables" data-linktype="relative-path">metadata synchronization</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Apache Spark tables (remote) available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Databricks tables (remote) available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Delimited available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/query-single-csv-file" data-linktype="relative-path">Yes</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>CSV available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/query-single-csv-file" data-linktype="relative-path">Yes</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Parquet available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/query-parquet-files" data-linktype="relative-path">Yes</a>, including files with <a href="https://docs.microsoft.com/azure/synapse-analytics/query-parquet-nested-types" data-linktype="relative-path">nested types</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Hive ORC available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Hive RC available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>JSON available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/query-json-files" data-linktype="relative-path">Yes</a> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Avro available supported Serverless</h1><div>No For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Delta Lake available supported Serverless</h1><div><a href="https://docs.microsoft.com/azure/synapse-analytics/query-delta-lake-format" data-linktype="relative-path">Yes</a>, including files with <a href="https://docs.microsoft.com/azure/synapse-analytics/query-parquet-nested-types" data-linktype="relative-path">nested types</a> See <strong><a href="https://delta.io/" data-linktype="external">Delta Lake</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<div><h1>CDM available supported Serverless</h1><div>No See <strong><a href="https://docs.microsoft.com/en-us/common-data-model/" data-linktype="absolute-path">CDM</a></strong> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/overview-features'>here</a>.</div></div>
<br><hr/></br>
<html><head><title></title></head><body>
<div><h1>OPENROWSET(BULK) without datasource how to Required permissions</h1><div><code>ADMINISTER BULK OPERATIONS</code>, <code>ADMINISTER DATABASE BULK OPERATIONS</code>, or SQL login must have REFERENCES CREDENTIAL::<URL> for SAS-protected storage For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview'>here</a>.</div></div>
<br><hr/></br>
<div><h1>OPENROWSET(BULK) with datasource without credential how to Required permissions</h1><div><code>ADMINISTER BULK OPERATIONS</code> or <code>ADMINISTER DATABASE BULK OPERATIONS</code>, For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview'>here</a>.</div></div>
<br><hr/></br>
<div><h1>OPENROWSET(BULK) with datasource with credential how to Required permissions</h1><div><code>REFERENCES DATABASE SCOPED CREDENTIAL</code> and one of <code>ADMINISTER BULK OPERATIONS</code> or <code>ADMINISTER DATABASE BULK OPERATIONS</code> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview'>here</a>.</div></div>
<br><hr/></br>
<div><h1>CREATE EXTERNAL DATA SOURCE how to Required permissions</h1><div><code>ALTER ANY EXTERNAL DATA SOURCE</code> and <code>REFERENCES DATABASE SCOPED CREDENTIAL</code> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview'>here</a>.</div></div>
<br><hr/></br>
<div><h1>CREATE EXTERNAL TABLE how to Required permissions</h1><div><code>CREATE TABLE</code>, <code>ALTER ANY SCHEMA</code>, <code>ALTER ANY EXTERNAL FILE FORMAT</code>, and <code>ALTER ANY EXTERNAL DATA SOURCE</code> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview'>here</a>.</div></div>
<br><hr/></br>
<div><h1>SELECT FROM EXTERNAL TABLE how to Required permissions</h1><div><code>SELECT TABLE</code> and <code>REFERENCES DATABASE SCOPED CREDENTIAL</code> For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview'>here</a>.</div></div>
<br><hr/></br>
<div><h1>CETAS how to Required permissions</h1><div>To create table - <code>CREATE TABLE</code>, <code>ALTER ANY SCHEMA</code>, <code>ALTER ANY DATA SOURCE</code>, and <code>ALTER ANY EXTERNAL FILE FORMAT</code>. To read data: <code>ADMINISTER BULK OPERATIONS</code> or <code>REFERENCES CREDENTIAL</code> or <code>SELECT TABLE</code> per each table/view/function in query + R/W permission on storage For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-overview'>here</a>.</div></div>
<br><hr/></br>
<html><head><title></title></head><body>
<div><h1>Syntax errors: - Incorrect syntax near Openrowset - ... is not a recognized BULK OPENROWSET provider option. - Incorrect syntax near ... what is Root cause</h1><div>Possible root causes:<br> - Not using CosmosDB as the first parameter.<br> - Using a string literal instead of an identifier in the third parameter.<br> - Not specifying the third parameter (container name). For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>There was an error in the CosmosDB connection string. what is Root cause</h1><div>- The account, database, or key isn't specified. <br> - There's some option in a connection string that isn't recognized.<br> - A semicolon (<code>;</code>) is placed at the end of a connection string. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Resolving CosmosDB path has failed with the error "Incorrect account name" or "Incorrect database name." what is Root cause</h1><div>The specified account name, database name, or container can't be found, or analytical storage hasn't been enabled to the specified collection. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Resolving CosmosDB path has failed with the error "Incorrect secret value" or "Secret is null or empty." what is Root cause</h1><div>The account key isn't valid or is missing. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max number of Synapse workspaces per subscription what is Limitation</h1><div>20 For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max number of databases per serverless pool what is Limitation</h1><div>20 (not including databases synchronized from Apache Spark pool) For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max number of databases synchronized from Apache Spark pool what is Limitation</h1><div>Not limited For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max number of databases objects per database what is Limitation</h1><div>The sum of the number of all objects in a database cannot exceed 2,147,483,647 (see <a href="https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server#objects" data-linktype="absolute-path">limitations in SQL Server database engine</a> ) For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max identifier length (in characters) what is Limitation</h1><div>128 (see <a href="https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server#objects" data-linktype="absolute-path">limitations in SQL Server database engine</a> ) For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max query duration what is Limitation</h1><div>30 min For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max size of the result set what is Limitation</h1><div>up to 200 GB (shared between concurrent queries) For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
<div><h1>Max concurrency what is Limitation</h1><div>Not limited and depends on the query complexity and amount of data scanned. One serverless SQL pool can concurrently handle 1000 active sessions that are executing lightweight queries, but the numbers will drop if the queries are more complex or scan a larger amount of data. For more information, see <a href='https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand'>here</a>.</div></div>
<br><hr/></br>
</body>
</html>