To create a custom MongoDB resource defined via an aggregation pipeline, go to Company Settings → Data Sources. Click on the desired MongoDB data source.
Under “Resources”, click on “Add New”:
Name your custom resource at the top.
Then, enter in the name of the MongoDB collection with your data. This must match an existing collection within your MongoDB data source.
Within the input field, you can enter in your aggregation pipeline to define the data that you want in your resource. See the screenshot above for an example. For more information on aggregation, you can refer to the MongoDB documentation for quick reference and SQL-to-aggregation mapping chart.
Hit “Apply” to create your custom resource.
Things to know about custom resources: