Creates an Open Table Format table in a Datalake using columns from an existing Block File System, Object File System, or Open Table Format table, with or without its data. You must have access rights to the Datalake object.
- CREATE TABLE AS Syntax (Datalake Form)
- CREATE TABLE AS Syntax Elements (Datalake Form)
- Example: CREATE TABLE AS (Datalake Form)
To create an Open Table Format table in a Datalake without using an existing table, use CREATE TABLE (Datalake Form).