Skip to main content

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).MongoDB Schema Reference

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).MongoDB Schema Reference

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).MongoDB Schema Reference

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).MongoDB Schema Reference

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

See MongoDB Schema Reference for MongoDB schema version 27.

2019.4

25 and 26

Not available.

4.0

3.4 and 4.0

See MongoDB Schema Reference for MongoDB schema version 26.

2019.3

24

Not available.

4.0

3.0, 3.4, and 4.0

See MongoDB Schema Reference for MongoDB schema version 24.

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.