Geremie/load_to_bq.sh

Created May 19, 2022 14:52

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Geremie/60e406654520c6efc186450eb85addaa.js"></script>
Save Geremie/60e406654520c6efc186450eb85addaa to your computer and use it in GitHub Desktop.

Download ZIP

Do Yourself a Favor and Stay Away from BigQuery Schema Auto-detection

Raw

load_to_bq.sh

	!bq load --autodetect \
	--source_format NEWLINE_DELIMITED_JSON \
	tmp.test_sample_2 gs://<path_to_folder_containing_the_file>test_sample_2.jsonl address_schema.json

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment