SQL Reference Guide > SQL Reference Guide > Using External Tables (X100 Only) > Syntax for Defining an External Table
Was this helpful?
Syntax for Defining an External Table
The syntax for defining an external table is as follows:
CREATE EXTERNAL TABLE table_name (column_name data_type {,column_name data_type})
USING SPARK
WITH REFERENCE='reference'
[,FORMAT='format']
[,OPTIONS=('key'=value {,'key'='value'})]
For details, see CREATE EXTERNAL TABLE in the SQL Language Guide.
Last modified date: 04/03/2024