DataArtsFabric SQL Restrictions

Technical Metric	Max. Value
Number of concurrent sessions	500
Maximum length of the waiting queue for creating sessions asynchronously	1000

**Table 1** DataArtsFabric SQL service usage restrictions
Item	Description
Service enabling	An account can enable only one DataArtsFabric SQL service, which is shared among all sub-users.
Connection operations	The service supports multiple connection modes, including SQL editor, JDBC, SDK, and API.
O&M operations	The service operates in serverless mode, eliminating the need for O&M tasks such as capacity expansion, upgrades, backup and restoration, or disaster recovery.
Timeout limit	The user authorization token lasts for 8 hours. Requests made after this period will fail to execute.
SQL syntax	For details, see Database Operation Restrictions.

**Table 2** Database operation restrictions
Type	Syntax	Supported
Basic functions	CREATE EXTERNAL TABLE	Yes
	DROP TABLE	Yes
	CREATE VIEW	Yes
	DROP VIEW	Yes
	INSERT	Yes
	SELECT	Yes
	TRUNCATE	Yes
	EXPLAIN	Yes
	ANALYZE	Yes
	ALTER TABLE DROP PARTITIONS	Yes
	ALTER TABLE SET TABLEPROPERTIES	Yes
	ALTER TABLE UNSET TABLEPROPERTIES	Yes
	ALTER TABLE DROP COLUMNS	No (supported only by Iceberg)
	ALTER TABLE ADD COLUMNS	No (supported only by Iceberg)
	ALTER TABLE COLUMN RENAME	No (supported only by Iceberg)
	CREATE EXTERNAL TABLE AS	Yes