Views (VDS)
The SQL commands for views (also known as virtual datasets) enable you to create, replace, and drop views in your home space and other spaces.
Creating or Replacing a View
CREATE [ OR REPLACE ] VIEW <view_path> AS
<select_statement>
Parameters
<view_path>
String
The path of the view that you want to create. The name of the view should be unique. The view can be in your home space or a regular space.
<select_statement>
String
The query used to populate the view.
Examples
CREATE VIEW demo.example_view_vds AS
SELECT *
FROM "oracle_tpch".DREMIO.JOBS
CREATE OR REPLACE VIEW demo.example_view_vds AS
SELECT *
FROM "oracle_tpch".DREMIO.INVENTORY
Dropping a View
DROP VIEW <view_path>
Parameters
<view_path>
String
The path of the view that you want to drop. The view can be in your home space or a regular space.
Examples
DROP VIEW demo.example_view_vds
Was this page helpful?
Glad to hear it! Thank you for your feedback.
Sorry to hear that. Thank you for your feedback.