Page History
The mapping below displays side-by-side how MongoDB syntax maps to ADS MongoSQL syntax so that you can determine how to write queries in the Aqua Data Studio's Query Analyzer when connecting to MongoDB. These examples use the baseball.json file attached to the SQL Query Reference page.
To test the SQL Mapping, you can first create a new collection using CREATE COLLECTION and then insert data using INSERT, or you can just insert data using INSERT and a collection will be created if it does not exist. There is no direct mapping for CREATE TABLE.
...