Examples
Create a Virtual Database
curl -d "[\"CREATE VIRTUAL DATABASE 'PUB1' SET ANNOTATION 'this is a virtual db'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
Rename a Virtual database
curl -d "[\"ALTER VIRTUAL DATABASE 'PUB1' RENAME AS 'renamedpub'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
Edit annotation
curl -d "[\"ALTER VIRTUAL DATABASE 'PUB1' SET ANNOTATION 'altered virtual db'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
Delete if exists /services/databases/renamedpub
curl -d "[\"DROP VIRTUAL DATABASE IF EXISTS 'renamedpub'\"]"
-u "admin:admin"
-X POST "http://localhost:9400/rest/execute/v1/actions/dsl/invoke"
-H "Content-Type:application/json"
Get Virtual DB properties
SELECT * FROM /services/databases/system/model/ALL_RESOURCE_PROPERTIES WHERE metadata_id=
(select datasource_id from /services/databases/system/model/ALL_DATASOURCES
where datasource_name = 'publishedDB' and parent_path = '/services/databases')