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 in GCP by anonymous
• 6,650 points
12 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 by Sirajul
• 40,980 points
I want to set maximum bytes billed to 1000000. How do I do this?

Related Questions In GCP

0 votes
1 answer
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 in GCP by Sirajul
• 40,980 points
65 views
0 votes
1 answer

How do I create a BigQuery Dataset using the console?

To create a dataset: Open the BigQuery web ...READ MORE

answered Nov 15 in GCP by anonymous
• 40,980 points
23 views
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 in GCP by Sirajul
• 40,980 points
28 views
0 votes
1 answer

Permissions required to update a dataset.

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

answered Nov 15 in GCP by Sirajul
• 40,980 points
31 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 in GCP by Sirajul
• 40,980 points
28 views
0 votes
1 answer