Skip to content

Instantly share code, notes, and snippets.

@zkan

zkan/alter_athena_table.sh

Last active January 7, 2020 01:53
Show Gist options
  • Save zkan/5c3674465945baee909c878b21028288 to your computer and use it in GitHub Desktop.
Save zkan/5c3674465945baee909c878b21028288 to your computer and use it in GitHub Desktop.
Download ZIP
Change the location for the Athena table
Raw
alter_athena_table.sh
ALTER TABLE pw_accounts_accountstatuslogentry SET LOCATION 's3://data-swarm/pronto-world/prontoworlddb/accounts_accountstatuslogentry';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment