Skip to main content

indexes

Creates, updates, deletes, gets or lists a indexes resource.

Overview

Nameindexes
TypeResource
Iddigitalocean.databases.indexes

Fields

NameDatatypeDescription
column_anon``

Methods

NameAccessible byRequired ParamsDescription
databases_list_opeasearch_indexesSELECTdatabase_cluster_uuidTo list all of a OpenSearch cluster's indexes, send a GET request to /v2/databases/$DATABASE_ID/indexes. The result will be a JSON object with a indexes key.
databases_delete_opensearch_indexDELETEdatabase_cluster_uuid, index_nameTo delete a single index within OpenSearch cluster, send a DELETE request to /v2/databases/$DATABASE_ID/indexes/$INDEX_NAME. A status of 204 will be given. This indicates that the request was processed successfully, but that no response body is needed.

SELECT examples

To list all of a OpenSearch cluster's indexes, send a GET request to /v2/databases/$DATABASE_ID/indexes. The result will be a JSON object with a indexes key.

SELECT
column_anon
FROM digitalocean.databases.indexes
WHERE database_cluster_uuid = '{{ database_cluster_uuid }}';

DELETE example

Deletes the specified indexes resource.

/*+ delete */
DELETE FROM digitalocean.databases.indexes
WHERE database_cluster_uuid = '{{ database_cluster_uuid }}'
AND index_name = '{{ index_name }}';