Astra DB DevOps

Get Tokens Create Token Delete Token

List Roles Get Role Create Role Update Role Delete Role

List Users Get User Delete User Invite Users

List Databases Create Database

(Deprecated) Create Auth Token List Available Regions List Available Serverless Regions Get Current Org

Data API vector collection

Create and find collections

findCollections

insertMany documents with $vector insertMany documents with $vectorize

find with pagingState: to get all purchases showing Page 2 results find sorted by $vectorize search, projection enabled, return similarity scores

Find and modify data

findOneAndDelete with $vectorize

updateMany - Set element value

deleteMany - delete by status deleteCollection - delete by collection name, vectorize

Data API vector collection non-astra

Create namespaces

createNamespace

Create and find collections

findCollections

insertMany documents with $vector insertMany documents with $vectorize

find with pagingState: to get all purchases showing Page 2 results find sorted by $vectorize search, projection enabled, return similarity scores

Find and modify data

findOneAndDelete with $vectorize

updateMany - Set element value

deleteMany - delete by status deleteCollection - delete by collection name, vectorize

Stargate Document API reference

v2-namespaces/{namespace-id}/collections-{collection-id}-{document-id}-{document-path}

Get a sub document by {document-path}Replace a sub document by {document-path}Update part of a sub document by {document-path}Delete a sub document by {document-path}

v2-namespaces/{namespace-id}/collections-{collection-id}-{document-id}

Get a document by {document-id}Replace a document by {document-id}Update part of a document Delete a document

v2-namespaces/{namespace-id}/collections-{collection-id}

Search for documents in {collection-id}Add a new document to {collection-id}Write multiple new documents in one request

v2-namespaces/{namespace-id}/collections

Create a collection List collections in a namespace

v2-schemas/namespaces-{namespace-id}-collections/{collection-id}

Get a collection Delete a collection

v2-schemas/namespaces-{namespace-id}

Get a namespace Delete a namespace

v2-schemas/namespaces

Create a namespace Get all namespaces

Create an auth token Copy

Stargate-Document-API:library

Create a auth token (Stargate OSS only)

Create a simple namespace test (Stargate OSS only)

Retrieve schema

Get a particular namespace (test)Get all namespaces

Create collection schema

Create empty collection library2 Put a JSON Schema Get a JSON Schema

Get collection info

Get all collections from a namespace Get a collection's JSON schema

PUT document with documentId POST ONE READER POST ONE BOOK Get one book POST MULTIPLE BOOKS with id-path POST ONE READER WITH DOCUMENT-ID

Decorations for writing - TTL and profiling

PUT TTL GET TTL

Write data with document-path

PUT ONE BOOK WITH DOCUMENT-PATH PATCH ONE BOOK WITH DOCUMENT-PATH

Pop an item off of the genre array Get state of the array genre again

Get all docs in a collection

Get all documents in a collection with page-state

Get docs in a collection with WHERE

Get all documents in a collection WHERE book title eq a particular book in reader.reviews

Get an identified document with info

Get a single document with fields

Read data with document-path

Get a path in a particular document Get an array in a path in a particular document with a document-path Get an array in a path in a particular document with a document-path

Delete collection library Delete a doc-path from a document Delete collection library2 Delete document with WHERE Delete document from collection

Delete namespaces test (Stargate OSS only)

Stargate-Document-API:myworld

Create a auth token (Stargate OSS only)

Create a namespace myworld with RF (Stargate OSS only)

retrieve schema

Get all namespaces Get namespaces myworld

POST nonsense-stuff PUT Janet PUT Martha PUT Joey PATCH Joey PATCH Joey weights (nested)PATCH Janet

Get document WHERE firstname EQ Janet/Joey/Martha/JanetLee OR weights.type="bench press" or "squat"Get document Joey Get document Joey, the weights value Get document Joey, the weights type value

Delete the document Janet

Delete namespaces myworld (Stargate OSS only)

Stargate-GraphQL-API:library

Create a auth token (Stargate OSS only)

Alter table book, add columns isbn, language, pub_year, and genre

retrieve schema

Update a book again - Moby Dick with genre

Read (get) reader with UDT

Delete one book with CL

Drop keyspace (Stargate OSS only)

Stargate-REST-API:users_keyspace

Create a auth token (Stargate OSS only)

Create a keyspace with replica set to 1 (Stargate OSS only)Create a user-defined type (UDT) called address Create a table users Create a column address (UDT)Change the column firstname to first Change the column first back to firstname Change the table definition back again Create table index country_idx (TUPLE)

retrieve schema

Get a listing of keyspaces Get info for users_keyspace Get a listing of all tables with defined columns Get a listing of all columns in table users Get column email info Get table indexes Get UDTs

Insert Janesha Doesha Patch user: Mookie Betts with email value Put user: Mookie Betts evaluation update

Get row using partition key only Get record for user using primary key in path Get row with WHERE clause (EQ, CONTAINS, CONTAINSKEY, CONTAINSENTRY) for collections, tuples, UDTs

Delete record of user: Mookie Betts

Delete column email Drop table index fav_books_idx Delete table users Delete UDT address_type Delete keyspace users_keyspace (Stargate OSS only)

Stargate: Leveraging Stargate Document API as a TimeSeries DB

Report 1: Weekly temperature report by day for a Boston for Week 26 Report 2: Weekly temperature comparison for 2 Boston & Seattle for Week 26

Astra DB DevOps

Get Tokens Create Token Delete Token

List Roles Get Role Create Role Update Role Delete Role

List Users Get User Delete User Invite Users

List Databases Create Database

(Deprecated) Create Auth Token List Available Regions List Available Serverless Regions Get Current Org

Data API vector collection

Create and find collections

findCollections

insertMany documents with $vector insertMany documents with $vectorize

find with pagingState: to get all purchases showing Page 2 results find sorted by $vectorize search, projection enabled, return similarity scores

Find and modify data

findOneAndDelete with $vectorize

updateMany - Set element value

deleteMany - delete by status deleteCollection - delete by collection name, vectorize

Data API vector collection non-astra

Create namespaces

createNamespace

Create and find collections

findCollections

insertMany documents with $vector insertMany documents with $vectorize

find with pagingState: to get all purchases showing Page 2 results find sorted by $vectorize search, projection enabled, return similarity scores

Find and modify data

findOneAndDelete with $vectorize

updateMany - Set element value

deleteMany - delete by status deleteCollection - delete by collection name, vectorize

Stargate Document API reference

v2-namespaces/{namespace-id}/collections-{collection-id}-{document-id}-{document-path}

Get a sub document by {document-path}Replace a sub document by {document-path}Update part of a sub document by {document-path}Delete a sub document by {document-path}

v2-namespaces/{namespace-id}/collections-{collection-id}-{document-id}

Get a document by {document-id}Replace a document by {document-id}Update part of a document Delete a document

v2-namespaces/{namespace-id}/collections-{collection-id}

Search for documents in {collection-id}Add a new document to {collection-id}Write multiple new documents in one request

v2-namespaces/{namespace-id}/collections

Create a collection List collections in a namespace

v2-schemas/namespaces-{namespace-id}-collections/{collection-id}

Get a collection Delete a collection

v2-schemas/namespaces-{namespace-id}

Get a namespace Delete a namespace

v2-schemas/namespaces

Create a namespace Get all namespaces

Create an auth token Copy

Stargate-Document-API:library

Create a auth token (Stargate OSS only)

Create a simple namespace test (Stargate OSS only)

Retrieve schema

Get a particular namespace (test)Get all namespaces

Create collection schema

Create empty collection library2 Put a JSON Schema Get a JSON Schema

Get collection info

Get all collections from a namespace Get a collection's JSON schema

PUT document with documentId POST ONE READER POST ONE BOOK Get one book POST MULTIPLE BOOKS with id-path POST ONE READER WITH DOCUMENT-ID

Decorations for writing - TTL and profiling

PUT TTL GET TTL

Write data with document-path

PUT ONE BOOK WITH DOCUMENT-PATH PATCH ONE BOOK WITH DOCUMENT-PATH

Pop an item off of the genre array Get state of the array genre again

Get all docs in a collection

Get all documents in a collection with page-state

Get docs in a collection with WHERE

Get all documents in a collection WHERE book title eq a particular book in reader.reviews

Get an identified document with info

Get a single document with fields

Read data with document-path

Get a path in a particular document Get an array in a path in a particular document with a document-path Get an array in a path in a particular document with a document-path

Delete collection library Delete a doc-path from a document Delete collection library2 Delete document with WHERE Delete document from collection

Delete namespaces test (Stargate OSS only)

Stargate-Document-API:myworld

Create a auth token (Stargate OSS only)

Create a namespace myworld with RF (Stargate OSS only)

retrieve schema

Get all namespaces Get namespaces myworld

POST nonsense-stuff PUT Janet PUT Martha PUT Joey PATCH Joey PATCH Joey weights (nested)PATCH Janet

Get document WHERE firstname EQ Janet/Joey/Martha/JanetLee OR weights.type="bench press" or "squat"Get document Joey Get document Joey, the weights value Get document Joey, the weights type value

Delete the document Janet

Delete namespaces myworld (Stargate OSS only)

Stargate-GraphQL-API:library

Create a auth token (Stargate OSS only)

Alter table book, add columns isbn, language, pub_year, and genre

retrieve schema

Update a book again - Moby Dick with genre

Read (get) reader with UDT

Delete one book with CL

Drop keyspace (Stargate OSS only)

Stargate-REST-API:users_keyspace

Create a auth token (Stargate OSS only)

Create a keyspace with replica set to 1 (Stargate OSS only)Create a user-defined type (UDT) called address Create a table users Create a column address (UDT)Change the column firstname to first Change the column first back to firstname Change the table definition back again Create table index country_idx (TUPLE)

retrieve schema

Get a listing of keyspaces Get info for users_keyspace Get a listing of all tables with defined columns Get a listing of all columns in table users Get column email info Get table indexes Get UDTs

Insert Janesha Doesha Patch user: Mookie Betts with email value Put user: Mookie Betts evaluation update

Get row using partition key only Get record for user using primary key in path Get row with WHERE clause (EQ, CONTAINS, CONTAINSKEY, CONTAINSENTRY) for collections, tuples, UDTs

Delete record of user: Mookie Betts

Delete column email Drop table index fav_books_idx Delete table users Delete UDT address_type Delete keyspace users_keyspace (Stargate OSS only)

Stargate: Leveraging Stargate Document API as a TimeSeries DB

Report 1: Weekly temperature report by day for a Boston for Week 26 Report 2: Weekly temperature comparison for 2 Boston & Seattle for Week 26

Home Data API vector collection non-astraUpdate data

Update data

Number of APIs: 1

updateMany - Set element value POST {{DB_API_ENDPOINT}}/{{DB_KEYSPACE}}/{{DB_COLLECTION}}

findOneAndDelete with $vectorize

updateMany - Set element value