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,600 points
381 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,170 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,170 points
2,843 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,170 points
5,330 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,170 points
949 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,170 points
848 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,170 points
843 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP