I used to use cloud shell for roop use to make table at Bigquery. In this case, Usually I put the google data (360) for make DMP. sql is going too long so they show below,
if you have some knowledge to solve this problem ,pls teach me. ※ I Don't wannt to cut the query