Manage Semantic View

DROP SEMANTIC VIEW

Deletes the specified semantic view.

Syntax:

DROP SEMANTIC VIEW [ IF EXISTS ] <view_name>;

IF EXISTS prevents errors when the view does not exist. It is recommended to always include it in scripts.

Example:

DROP SEMANTIC VIEW IF EXISTS doc_test.emp_dept_analysis;

ALTER SEMANTIC VIEW

Currently only supports renaming. Does not support dynamically adding/removing dimensions, metrics, or modifying comments via SQL -- to modify the view structure, you must DROP and rebuild.

Syntax:

ALTER SEMANTIC VIEW <view_name> RENAME TO <new_name>;

The new name must not include a schema prefix; after renaming, the view remains in the original schema.

Example:

ALTER SEMANTIC VIEW emp_dept_analysis RENAME TO emp_dept_v2;

SHOW SEMANTIC VIEWS

Lists all semantic views under the specified schema, returning two columns: schema_name and table_name.

Syntax:

SHOW SEMANTIC VIEWS [ IN <schema_name> ];

It is recommended to always include IN <schema_name>. Without it, views under the current default schema are returned.

Example:

SHOW SEMANTIC VIEWS IN doc_test;

+-------------+-------------------+
| schema_name |    table_name     |
+-------------+-------------------+
| doc_test    | emp_dept_analysis |
+-------------+-------------------+

You can also query via information_schema.tables to get additional metadata:

SELECT table_name, comment, create_time, last_modify_time
FROM information_schema.tables
WHERE table_schema = 'doc_test'
  AND table_type = 'SEMANTIC_VIEW';

DESC EXTENDED

View the complete definition of a semantic view, including logical table structures, primary/foreign key relationships, dimension metadata, and metric definitions.

Note: DESC <view_name> (without EXTENDED) returns an empty result set. You must include EXTENDED.

Syntax:

DESC EXTENDED <view_name>;

Example:

DESC EXTENDED doc_test.emp_dept_analysis;

Returned content includes:

• Basic view information: workspace, schema, creator, created_time, last_modified_time, comment
• Logical table list: alias, full physical table name, primary key, foreign key
• Dimension list: name, expression, isUnique, isTime, enumValues, comment
• Metric list: name, aggregation expression, comment

Access Control

Semantic views support standard GRANT/REVOKE permission management, but only read-only permissions (SELECT, ALL) are supported. INSERT, UPDATE, and DELETE are not supported.

GRANT

-- Grant query permission to a role
GRANT SELECT ON SEMANTIC VIEW doc_test.emp_dept_analysis TO ROLE test_readonly_role;

-- Grant all permissions (equivalent to SELECT)
GRANT ALL ON SEMANTIC VIEW doc_test.emp_dept_analysis TO ROLE workspace_dev;

REVOKE

REVOKE SELECT ON SEMANTIC VIEW doc_test.emp_dept_analysis FROM ROLE test_readonly_role;

SHOW GRANTS

View the permission grants on a semantic view:

SHOW GRANTS ON SEMANTIC VIEW doc_test.emp_dept_analysis;

Returned columns: granted_type, privilege, granted_on (value is SEMANTIC_VIEW), object_name, granted_to, grantee_name, grantor_name, grant_option, granted_time.

Command Quick Reference

Related Documents

• Create Semantic View
• Best Practices