SQL API
Refresh collections Hide
    in progress items 0 error items 1 info items 0 Failed to get authorization headers for offers: {"readyState":4,"responseText":"The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.","status":404,"statusText":"error"}
    expand console
    New Database

    * Database id More information A database is a logical container of one or more collections

    * Throughput (400 - 1,000,000 RU/s) More information Provisioned throughput is measured in Request Units per second (RU/s). 1 RU corresponds to the throughput of a read of a 1 KB document.

    Estimated spend (USD): $4.00 hourly / $96.00 daily.

    Contact support for more than 1,000,000 RU/s.

    Add Collection

    * Database id More information A database is a logical container of one or more collections

    Create new Use existing

    * Throughput (400 - 1,000,000 RU/s) More information Provisioned throughput is measured in Request Units per second (RU/s). 1 RU corresponds to the throughput of a read of a 1 KB document.

    Estimated spend (USD): $0.032 hourly / $0.77 daily.

    * Collection Id More information Unique identifier for the collection and used for id-based routing through REST and all SDKs

    Where did 'fixed' collections go? More information We lowered the minimum throughput for partitioned containers to 400 RU/s, removing the only drawback partitioned containers had.

    We are planning to deprecate ability to create non-partitioned containers, as they do not allow you to scale elastically. If for some reason you still need a container without partition key, you can use our SDKs to create one.

    Please contact us if you have questions or concerns.

    * RU/m More information For each 100 Request Units per second (RU/s) provisioned, 1,000 Request Units per minute (RU/m) can be provisioned. E.g.: for a collection with 5,000 RU/s provisioned with RU/m enabled, the RU/m budget will be 50,000 RU/m.

    * Partition key More information The Partition Key is used to automatically partition data among multiple servers for scalability. Choose a JSON property name that has a wide range of values and is likely to have evenly distributed access patterns.

    * Throughput (400 - 1,000,000 RU/s) More information Each collection can be provisioned throughput in Request Units per second (RU/s). 1 RU corresponds to the throughput of a read of a 1 KB document.

    Estimated spend (USD): $0.032 hourly / $0.77 daily.

    Unique keys More information Unique keys provide developers with the ability to add a layer of data integrity to their database. By creating a unique key policy when a container is created, you ensure the uniqueness of one or more values per partition key.

    Add unique key Add unique key
    Delete Collection
    Warning Warning! The action you are about to take cannot be undone. Continuing will permanently delete this resource and all of its children resources.

    Confirm by typing the collection id

    Delete Database
    Warning Warning! The action you are about to take cannot be undone. Continuing will permanently delete this resource and all of its children resources.

    Confirm by typing the database id

    New Vertex
    label
    Add property Add Property
    Graph Styling

    Show vertex (node) as

    Map this property to node color

    Map this property to node icon

    Show

    Property Name
    Type
    Value
    Insert attribute Add Property
    Property Name
    Type
    Value
    Insert attribute Add Property
    Column Options
    Choose the columns and the order in which you want to display them in the table.
    Move down Move up
      Select Column
      Select the columns that you want to query.
        Add Table

        * Keyspace name More information Select an existing keyspace or enter a new keyspace id.

        Create new Use existing
        Provision keyspace throughput More information Provisioned throughput at the keyspace level will be shared across unlimited number of tables within the keyspace

        * Throughput (400 - 1,000,000 RU/s) More information Provisioned throughput is measured in Request Units per second (RU/s). 1 RU corresponds to the throughput of a read of a 1 KB document.

        Estimated spend (USD): $0.032 hourly / $0.77 daily.

        * Enter CQL command to create the table. Learn More

        CREATE TABLE

        * Throughput (400 - 1,000,000 RU/s) More information Each table can be provisioned throughput in Request Units per second (RU/s). 1 RU corresponds to the throughput of a read of a 1 KB document.

        Estimated spend (USD): $0.032 hourly / $0.77 daily.

        Settings
        Page options More information Choose Custom to specify a fixed amount of query results to show, or choose Unlimited to show as many query results per page.
        Enable cross-partition query More information Send more than one request while executing a query. More than one request is necessary if the query is not scoped to single partition key value.
        Max degree of parallelism More information Gets or sets the number of concurrent operations run client side during parallel query execution. A positive property value limits the number of concurrent operations to the set value. If it is set to less than 0, the system automatically decides the number of concurrent operations to run.
        Upload Documents
        Select JSON documents More information Select one or more JSON files to upload. Each file can contain a single JSON document or an array of JSON documents. The combined size of all files in an individual upload operation must be less than 2 MB. You can perform multiple upload operations for larger data sets.
        upload files
        Load Query
        Select a query document
        upload files
        Input parameters
        Enter input parameters (if any)
        Type Param
        Delete param Add param
        Connect to Azure Cosmos DB
        Provide a valid account connection string
        Show renew access image Hide renew access image Where do I find the Connection String?
        Save Query
        We save queries in a container in your Azure Cosmos account. To proceed, we will create a container in your account with 400 RUs provisioned throughput, estimated additional monthly cost is $24/month.
        Open Saved Queries
        We save queries in a container in your Azure Cosmos account. To proceed, we will create a container in your account with 400 RUs provisioned throughput, estimated additional monthly cost is $24/month.