Is there a way to limit the query costs by restricting the number of bytes

0 votes
Is there a way to limit the query costs by restricting the number of bytes? How can I enable this?
Nov 21, 2019 in GCP by anonymous
• 19,590 points
172 views

1 answer to this question.

0 votes

Yes, you can limit the number of bytes billed for a query using the maximum bytes billed setting. 

When you set maximum bytes billed, if the query will read bytes beyond the limit, the query fails without incurring a charge.

If a query fails because of the maximum bytes billed setting, an error like the following is returned:

Error: Query exceeded limit for bytes billed: 1000000. 10485760 or higher required.
answered Nov 21, 2019 by Sirajul
• 59,030 points
I want to set maximum bytes billed to 1000000. How do I do this?

Related Questions In GCP

0 votes
1 answer

Is there any limit on the number of VPC per project in GCP?

The default limit for number of networks ...READ MORE

answered Oct 9, 2019 in GCP by Sirajul
• 59,030 points
1,262 views
0 votes
1 answer

Is there a way to mount a cloud storage as a local disk?

You could probably try using Gcsfuse for ...READ MORE

answered Oct 9, 2019 in GCP by Sirajul
• 59,030 points
3,426 views
0 votes
2 answers
0 votes
1 answer

Assign access control to a BigQuery Dataset.

You can apply access controls during dataset creation by ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 59,030 points
588 views
0 votes
1 answer

Permissions required to update a dataset.

At a minimum, to update dataset properties, ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 59,030 points
393 views
0 votes
1 answer

Change default expiration time for a dataset.

You can update a dataset's default table ...READ MORE

answered Nov 15, 2019 in GCP by Sirajul
• 59,030 points
376 views
0 votes
1 answer