iterate over all views in all datasets and saving source to a local sql files

get-bigquery-view-source.sh

#!/bin/bash

dataset_list="$(bq ls -n 500 | awk '{print $1}')"

for dataset in ${dataset_list}; do

    view_list="$(bq ls --dataset_id ${dataset} -n 500 | awk '{if($2 == "VIEW"){print $1}}')"

    for view in ${view_list}; do
        echo "${dataset}.${view}"
        bq show --format=prettyjson ${dataset}.${view} \
        | jq -r '.view.query' \
        > ${dataset}.${view}.sql
    done

done