Skip to content

Instantly share code, notes, and snippets.

@garystafford

garystafford/athena_command.sql

Last active January 5, 2020 03:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save garystafford/413e6d1479f3960efd9314c818aa5d36 to your computer and use it in GitHub Desktop.
Save garystafford/413e6d1479f3960efd9314c818aa5d36 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
athena_command.sql
CREATE TABLE IF NOT EXISTS smart_hub_data_catalog.smart_hub_data_parquet
WITH (format = 'PARQUET',
parquet_compression = 'SNAPPY',
partitioned_by = ARRAY['dt'],
external_location = 's3://smart-hub-data-demo-account-1-us-east-1/smart_hub_data_parquet')
AS
SELECT *
FROM smart_hub_data_catalog.smart_hub_data_json
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment