HOME/🔍 Google BigQuery/

🔍 ERROR

Article Outline

|| BigQueryのエラー

|

Query exceeded resource limits. This query used 96791 CPU seconds but would charge only 170M Analysis bytes. 
This exceeds the ratio supported by the on-demand pricing model. 
Please consider moving this workload to the flat-rate reservation pricing model, which does not have this limit. 
96791 CPU seconds were used, and this query must use less than 43500 CPU seconds.

|

To copy a table, the destination and source datasets must be in the same region. 
Copy an entire dataset to move data between regions.

作成したクエリの抽出結果(300万レコード程)を一時的にテーブル化しようとしたら、以下のようなエラーが出て困った。。

似たような事象の人が相談していた。(*2)

|

|

|| REFERENCE