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

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

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

ft:locale

en-US

ft:lastEdition

2024-12-11

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

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;