MongoDB Schema Reference
These articles cover the MongoDB schema version 42, which corresponds to Server versions 2022.2. Servers using either embedded MongoDB or user-managed MongoDB use this schema. See the version crosswalk for info on Server to MongoDB versions.
Important
MongoDB Community is not FIPS compliant, therefore it is not embedded in Server-FIPS. You need the user-managed Mongo DB Atlas or MongoDB Enterprise Advanced. Accordingly, we removed the Community Mongo from the System Settings. For more information see the Alteryx Server and FIPS Feature Differences help page.
Each Server instance stores information in 3 default databases:
AlteryxGallery Schema
The database for the Server UI part of your Server instance. For more information, go to AlteryxGallery MongoDB Schema.
AlteryxGallery_Lucene Schema
The database contains the indices for search within the Server UI. For more information, go to AlteryxGallery_Lucene MongoDB Schema.
AlteryxService Schema
The service-layer database. For more information, go to AlteryxService MongoDB Schema.
Server Version to MongoDB Version Crosswalk
Server Version | AlteryxGallery Schema Version | AlteryxService Schema Version | Embedded MongoDB Version | Supported MongoDB Version for User-Managed Instances | Documentation |
|---|---|---|---|---|---|
2022.2 | 42 | 1 | 4.2 | 4.2, 4.4, 5.0, and 6.0 (for all versions) | Current page. |
2022.1.1.42590 Patch 3 and later | 40.03 | Not available. | 4.2 | 4.0, 4.2, 4.4, 5.0, and 6.0 (for all versions) | See MongoDB Schema Reference for MongoDB schema version 40 (2022.1). |
2022.1 | 40 | Not available. | 4.2 | 4.0, 4.2, 4.4, 5.0, and 6.0 (for all versions) | See MongoDB Schema Reference for MongoDB schema version 40 (2022.1). |
2021.4.2.47792 Patch 5 and later | 34.03 | Not available. | 4.2 | 4.0, 4.2, 4.4, 5.0, and 6.0 (for all versions) | See MongoDB Schema Reference for MongoDB schema version 34 (2021.4). |
2021.4 | 34 | Not available. | 4.2 | 4.0, 4.2, 4.4, 5.0, and 6.0 (for all versions) | See MongoDB Schema Reference for MongoDB schema version 34 (2021.4). |
2021.3 | 31 | Not available. | For 2021.3.1 to 2021.3.5: 4.0 For 2021.3.6 and later: 4.2 | For 2021.3.1 to 21.3.5: 3.4, 4.0, and 4.0 Atlas For 2021.3.6 and later: 4.0, 4.2 and 4.4 | See MongoDB Schema Reference for MongoDB schema version 31 (2021.3). |
2021.2 | 30 | Not available. | 4.0 | 3.4, 4.0, and 4.0 Atlas | See MongoDB Schema Reference for MongoDB schema version 30 (2021.2). |
2021.1 | 28 | Not available. | 4.0 | 3.4, 4.0, and 4.0 Atlas | See MongoDB Schema Reference for MongoDB schema version 28 (2021.1). |
2020.4 | 28 | Not available. | 4.0 | 3.4, 4.0, and 4.0 Atlas | See MongoDB Schema Reference for MongoDB schema version 28 (2020.4). |
2020.3 | 28 | Not available. | 4.0 | 3.4, 4.0, and 4.0 Atlas | See MongoDB Schema Reference for MongoDB schema version 28 (2020.3). |
2020.2 | 28 | Not available. | 4.0 | 3.4, 4.0, and 4.0 Atlas | See MongoDB Schema Reference for MongoDB schema version 28 (2020.2). |
2020.1 | 27 | Not available. | 4.0 | 3.4, 4.0, and 4.0 Atlas | |
2019.4 | 25 and 26 | Not available. | 4.0 | 3.4 and 4.0 | |
2019.3 | 24 | Not available. | 4.0 | 3.0, 3.4, and 4.0 | |
2019.2 | 23 | Not available. | 3.4 | 3.0, 3.4, and 4.0 | Not available. |
2019.1 | 22 | Not available. | 3.4 | 3.0 and 3.4 | Not available. |
2018.4 | 21 | Not available. | 3.4 | 3.0 and 3.4 | Not available. |
2018.3 | 20 | Not available. | 3.4 | 3.0 and 3.4 | Not available. |