The Watson Query REST API connects to your service and allows you to manage your virtual data, data sources, and user roles.
| Method | Path | Summary |
|---|---|---|
| GET | /dvapiserver/v2/datasource/connections | Get data source connections |
| POST | /dvapiserver/v2/datasource/connections | Add data source connection |
| DELETE | /dvapiserver/v2/datasource/connections/{connection_id} | Delete data source connection |
| GET | /dvapiserver/v2/datasource/objectstore_connections | Gets the object store connection details. |
| POST | /dvapiserver/v2/privileges/users | Grant user access |
| DELETE | /dvapiserver/v2/privileges/users/{authid} | Revoke user acccess |
| POST | /dvapiserver/v2/privileges/roles | Grant user role |
| DELETE | /dvapiserver/v2/privileges/roles/{role_name} | Delete role |
| GET | /dvapiserver/v2/privileges/tables | Get virtualized tables by role |
| PUT | /dvapiserver/v2/security/policy/status | Turn policy enforcement status on or off |
| GET | /dvapiserver/v2/security/policy/status | Get policy enforcement status |
| POST | /dvapiserver/v2/virtualization/tables | Virtualize table |
| DELETE | /dvapiserver/v2/virtualization/tables/{virtual_name} | Delete virtualized table |
| POST | /dvapiserver/v2/virtualization/cloud_object_storages | Create a remote table for the ORC or Parquet file on a cloud object store (COS). |
| POST | /dbapi/v4/dv/delete_virtualize_task | Delete virtualized data |
| GET | /dvapiserver/v2/catalog/primary | Get primary catalog ID |
| POST | /dvapiserver/v2/catalog/primary | Add primary catalog |
| DELETE | /dvapiserver/v2/catalog/primary | Delete primary catalog |
| POST | /dvapiserver/v2/integration/catalog/publish | Publishes virtual tables to a catalog. |
| POST | /dvapiserver/v2/caching/caches | Create a new cache |
| GET | /dvapiserver/v2/caching/caches/{id} | Return details of a specific cache |
| DELETE | /dvapiserver/v2/caching/caches/{id} | Drop an existing cache |
| PATCH | /dvapiserver/v2/caching/caches/{id} | Edit an existing cache |
| POST | /dvapiserver/v2/caching/caches/{id}/enable | Enable an inactive cache |
| POST | /dvapiserver/v2/caching/caches/{id}/disable | Disable an active cache |
| POST | /dvapiserver/v2/caching/caches/{id}/refresh | Refresh an active cache |
| GET | /dvapiserver/v1/caching/caches | List caches |
| GET | /dvapiserver/v1/caching/caches/{id} | List a cache |
| GET | /dvapiserver/v1/caching/storage | Fetch the cache storage |