Breaking News: Grepper is joining You.com. Read the official announcement!

athena create table

Comfortable Camel answered on March 21, 2022 Popularity 8/10 Helpfulness 4/10

answer athena create table

athena create table

Comment

CREATE EXTERNAL TABLE [IF NOT EXISTS]
 [db_name.]table_name [(col_name data_type [COMMENT col_comment] [, ...] )]
 [COMMENT table_comment]
 [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)]
 [CLUSTERED BY (col_name, col_name, ...) INTO num_buckets BUCKETS]
 [ROW FORMAT row_format]
 [STORED AS file_format] 
 [WITH SERDEPROPERTIES (...)]
 [LOCATION 's3://bucket_name/[folder]/']
 [TBLPROPERTIES ( ['has_encrypted_data'='true | false',] ['classification'='aws_glue_classification',] property_name=property_value [, ...] ) ]

Popularity 8/10 Helpfulness 4/10 Language sql

Source: docs.aws.amazon.com

Tags: athena create-table sql

Link to this answer
Share Copy Link