Skip to main content

MongoDB Schema Reference

These articles cover the MongoDB schema version 46, which corresponds to Server versions 2023.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 MongoDB 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 2 default databases:

AlteryxGallery Schema

The database for the Server UI part of your Server instance. For more information, go to AlteryxGallery 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

2023.2

46

2

6.0

4.2, 4.4, 5.0, 6.0, and 7.0 (for all versions)

Current page.

2023.1.1.200 Patch 1 and later

45

1

4.2

4.2, 4.4, 5.0, and 6.0 (for all versions)

See MongoDB Schema Reference for MongoDB schema version 44 (2023.1).

2023.1

44

1

4.2

4.2, 4.4, 5.0, and 6.0 (for all versions)

See MongoDB Schema Reference for MongoDB schema version 44 (2023.1).

2022.3

43

1

4.2

4.2, 4.4, 5.0, and 6.0 (for all versions)

See MongoDB Schema Reference for MongoDB schema version 43 (2022.3).

2022.2

42

1

4.2

4.2, 4.4, 5.0, and 6.0 (for all versions)

See MongoDB Schema Reference for MongoDB schema version 42 (2022.2-FIPS).

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

Not available.

2021.2

30

Not available.

4.0

3.4, 4.0, and 4.0 Atlas

Not available.

2021.1

28

Not available.

4.0

3.4, 4.0, and 4.0 Atlas

Not available.

2020.4

28

Not available.

4.0

3.4, 4.0, and 4.0 Atlas

Not available.

2020.3

28

Not available.

4.0

3.4, 4.0, and 4.0 Atlas

Not available.

2020.2

28

Not available.

4.0

3.4, 4.0, and 4.0 Atlas

Not available.

2020.1

27

Not available.

4.0

3.4, 4.0, and 4.0 Atlas

Not available.

2019.4

25 and 26

Not available.

4.0

3.4 and 4.0

Not available.

2019.3

24

Not available.

4.0

3.0, 3.4, and 4.0

Not available.

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.