Skip to content

Design log

Jump to bottom
David Liu edited this page Oct 18, 2021 · 4 revisions
  • Prefer to use command line for all purpose
  • list out all tables in a BigQuery data set
  • Knowing tables in BigQuery is having no primary key, assuming the first table column as primary key.
  • GCP service accessibility: BigQuery, Cloud Storage
  • OCI service accessibility: Buckets, MySQL
  • Dependent tools: rclone, bq (BigQuery command line), oci
  • config oci in rclone
    • for oci, you need to prepare access_key_id and secret_access_key first beforehead
Clone this wiki locally