MongoDB Schema Reference

Version:
2022.2 FIPS
Last modified: April 18, 2023

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.

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.

AlteryxGallery_Lucene Schema

The database contains the indices for search within the Server UI.

AlteryxService Schema

The service-layer database.
Server Version to MongoDB Version Crosswalk
Server Version MongoDB Schema Version Embedded MongoDB Version Supported MongoDB Version for User-Managed Instances Documentation
2022.2 42 4.2 4.2, 4.4, 5.0, and 6.0 (for all versions) Current page.
2022.1 40 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 34 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

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 4.0 3.4, 4.0, and 4.0 Atlas See MongoDB Schema Reference for MongoDB schema version 30 (2021.2).
2021.1 28 4.0 3.4, 4.0, and 4.0 Atlas See MongoDB Schema Reference for MongoDB schema version 28 (2021.1).
2020.4 28 4.0 3.4, 4.0, and 4.0 Atlas See MongoDB Schema Reference for MongoDB schema version 28 (2020.4).
2020.3 28 4.0 3.4, 4.0, and 4.0 Atlas See MongoDB Schema Reference for MongoDB schema version 28 (2020.3).
2020.2 28 4.0 3.4, 4.0, and 4.0 Atlas See MongoDB Schema Reference for MongoDB schema version 28 (2020.2).
2020.1 27 4.0 3.4, 4.0, and 4.0 Atlas See MongoDB Schema Reference for MongoDB schema version 27.
2019.4 25 and 26 4.0 3.4 and 4.0 See MongoDB Schema Reference for MongoDB schema version 26.
2019.3 24 4.0 3.0, 3.4, and 4.0 See MongoDB Schema Reference for MongoDB schema version 24.
2019.2 23 3.4 3.0, 3.4, and 4.0 Not available.
2019.1 22 3.4 3.0 and 3.4 Not available.
2018.4 21 3.4 3.0 and 3.4 Not available.
2018.3 20 3.4 3.0 and 3.4 Not available.
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.