start new:
tmux
start new with session name:
tmux new -s myname
brandon brandonmp
shantanuo
/ mysql_to_big_query.sh
Last active
February 21, 2025 07:44
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
| #!/bin/sh | |
| TABLE_SCHEMA=$1 | |
| TABLE_NAME=$2 | |
| mytime=`date '+%y%m%d%H%M'` | |
| hostname=`hostname | tr 'A-Z' 'a-z'` | |
| file_prefix="trimax$TABLE_NAME$mytime$TABLE_SCHEMA" | |
| bucket_name=$file_prefix | |
| splitat="4000000000" | |
| bulkfiles=200 |
A personal diary of DataFrame munging over the years.
Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)
oyvindholmstad
/ schema-generator.js
Last active
September 21, 2018 06:54
BigQuery JSON schema generator in Javascript and Scala
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
| /* | |
| A script to generate a Google BigQuery-complient JSON-schema from a JSON object. | |
| Make sure the JSON object is complete before generating, null values will be skipped. | |
| References: | |
| https://cloud.google.com/bigquery/docs/data | |
| https://cloud.google.com/bigquery/docs/personsDataSchema.json | |
| https://gist.github.com/igrigorik/83334277835625916cd6 | |
| ... and a couple of visits to StackOverflow |