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:
The database for the Server UI part of your Server instance. Go to AlteryxGallery SQL DB Schema.
The service-layer database. Go to AlteryxService SQL DB Schema.
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). |