Question

Is there a way to limit the query costs by restricting the number of bytes? How can I enable this?

Answer 1

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.