Views

The SQL commands for views enable you to create, replace, and drop views in the Nessie repository.

Creating or Replacing a View

Syntax

CREATE [ OR REPLACE ] VIEW <view_path> AS 
  <select_statement>

Parameters

{{< sql-section file="data/sql/views.json" data="creatingAView" >}}

Examples

Create a view

CREATE VIEW demo.example_view AS 
  SELECT * 
  FROM "oracle_tpch".DREMIO.JOBS

Replace a view

CREATE OR REPLACE VIEW demo.example_view AS 
  SELECT * 
  FROM "oracle_tpch".DREMIO.INVENTORY

Dropping a View

Syntax

DROP VIEW <view_path>

Parameters

{{< sql-section file="data/sql/views.json" data="droppingAView" >}}

Examples

Drop a view

DROP VIEW demo.example_view