Is there an up-to-date Hive DDL for Snowplow canonical/enriched events?
https://github.com/snowplow/snowplow/blob/master/4-storage/hive-storage/hiveql/table-def.q is definitely outdated and missing event_name among other things.
AWS announced Athena (based on Presto, running on managed infrastructure) that allows dead simple querying of data in S3. Presto uses the Hive metastore so Hive DDL will come handy for Athena and Qubole users.