CREATE TABLE AS Example (Datalake Form) | VantageCloud Lake - Example: CREATE TABLE AS (Datalake Form) - Teradata VantageCloud Lake

Create OTF table named MyIceberg.MyDatabase.Tab1.

CREATE TABLE MyIceberg.MyDatabase.Tab1 
PARTITIONED BY (id)
SORTED BY id
AS (SELECT id FROM MyIceberg.MyDatabase.Tab2 as D) WITH DATA;