SQL DB Schema Reference
These articles cover the SQL DB schema version 1, which corresponds to Server versions 2024.1. 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.1 | 1 | MSSQL Server 2019 and 2022 | Current page. |