In this series we are going to utilize metadata tables and views available in bigquery to address some common use cases.