Create a Cosmo DB Input

Create an Input for Cosmos DB in Hero Platform_

  1. Open Hero Platform_.
  2. Open Integration from the navigation menu and select Inputs.
  3. Click Create New Input.

  4. Enter a name for the Cosmos DB Input and select a Cosmos DB Connection from the drop-down list.
  5. Configure the Cosmos DB Input data.

    • Enter a Cosmos DB container name.

    • Select a query type:
      • Simple (Free text query mode without partitioning)
        • Enter the Cosmos DB query.
          • Date macros are supported in the query:
            • Example: ${{now() - 1d}}
      • Partitioned (by _ts field)
        • Enter the partition size.
        • Enter the select specification. (A comma separated list of fields to select)
        • Enter the where expression. (For partitioning, the _ts expressions is added to the expression automatically)
        • Review the auto generated sample query. 
    • From the field mapping table:
      • Confirm or change column names.
      • Confirm or change column data types.
      • Remove or confirm the arrangement of columns.
    • Click OK.