Skip to content

To easily find which datasets in a project contain a given column name

Notifications You must be signed in to change notification settings

llcclarke/bigquery_column_finder

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 

Repository files navigation

bigquery_column_finder

Helper to find which tables have a given column

Currently there is no way to find where certain columns are used within BigQuery tables without query each dataset individually

Use

  1. Add the path to your GCS/BigQuery credentials
  2. Add your project_id to the bigquery_client
  3. run with python bigquery_columns.py project_id_to_search column_name_to_search_for

About

To easily find which datasets in a project contain a given column name

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages