Ashley Penney apenney
apenney
/ dependencies.sh
Last active
October 19, 2018 21:09
— forked from shantanuo/mysql_to_big_query.sh
Copy MySQL table to big query. If you need to copy all tables, use the loop given at the end.Exit with error code 3 if blob or text columns are found. The csv files are first copied to google cloud before being imported to big query.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env bash | |
| # install google utilities | |
| wget http://commondatastorage.googleapis.com/pub/gsutil.tar.gz | |
| tar xfz gsutil.tar.gz -C $HOME | |
| vi ~/.bashrc | |
| export PATH=${PATH}:$HOME/gsutil | |
| cd gsutil | |
| python setup.py install | |
| gsutil config |