Skip to content

Instantly share code, notes, and snippets.

@doit-mattporter

doit-mattporter/import_temperature_csv.sh

Created February 9, 2021 21:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save doit-mattporter/830e16c7dd426d1ea2df2dcaae1a3e1c to your computer and use it in GitHub Desktop.
Save doit-mattporter/830e16c7dd426d1ea2df2dcaae1a3e1c to your computer and use it in GitHub Desktop.
Download ZIP
Import Kaggle-provided temperature dataset into BigQuery
Raw
import_temperature_csv.sh
bq load \
--replace \
--skip_leading_rows 1 \
--source_format=CSV \
${PROJECT_ID}:sensordata.temperature \
gs://${BUCKET_NAME}/temperature.csv.gz \ timestamp_utc:DATETIME,timestamp_epoch:INTEGER,temp_f:FLOAT,temp_c:FLOAT,device_id:INTEGER
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment