SQL DB Schema Reference
These articles cover the SQL DB schema version 2, which corresponds to Server versions 2024.2. Servers using user-managed SQL DB use this schema. See the version crosswalk for info on Server to SQL DB versions.
Each Server instance stores information in 2 default databases:
AlteryxGallery Schema
The database for the Server UI part of your Server instance. Go to AlteryxGallery SQL DB Schema.
AlteryxService Schema
The service-layer database. Go to AlteryxService SQL DB Schema.
Server Version to SQL DB Version Crosswalk
Server Version | SQL DB Schema Version | Supported MSSQL Version for User-Managed Instances | Documentation |
|---|---|---|---|
2024.2 | 2 | MSSQL Server 2019 and 2022, Amazon RDS for SQL Server | Current page. |
2024.1 | 1 | MSSQL Server 2019 and 2022 | See SQL DB Schema Reference for SQL DB Schema version 1 (2024.1). |