DSL構文
下記のDSL構文を使用して、「rest/execute/v1/アクション/dsl/invoke」REST APIをCUDビューに対して実行できます。
DROP DATA VIEW (IF EXISTS)? /path/name
———————————————————————————————————————————————————————————————
CREATE DATA VIEW (IF NOT EXISTS)? /path/name
DEFINE AS sql
(SET PROPERTIES {"name":{value}})?
(SET ANNOTATION 'this is a view created using DSL api' | NULL)?
———————————————————————————————————————————————————————————————
ALTER DATA VIEW /path/name
(RELOCATE AS /path/newName)?
(DEFINE AS sql)?
(SET PROPERTIES {"name":{value}})?
(SET ANNOTATION 'this view is altered using DSL api' | NULL)?
———————————————————————————————————————————————————————————————
SELECT * FROM model.ALL_TABLES where TABLE_NAME = 'name';
———————————————————————————————————————————————————————————————
SELECT * FROM model.ALL_RESOURCE_PROPERTIES WHERE
PROPERTY_NAME = 'propName' AND
METADATA_ID =
(SELECT TABLE_ID FROM model.ALL_TABLES
WHERE TABLE_NAME = 'name' AND //name of view
PARENT_PATH = '/path'); //parent path of the view
注：データビューを作成する場合、プロパティと注釈はオプションです。