Yep you're right I could definitely upload the json to a bucket or in temp file on my cloud function and then direct upload it in BigQuery. I usually use dataframe in order to have a flat .csv file. Maybe not the best combo for sure, but usually prefer to work that way. If I was in a production environment I will definitely not use .csv but another format. Also not a big master just trying to practice and share.