When I started using bigquery almost 10 years ago, it was obvious from the documentation and running queries in the console that LIMIT does not change the price of the query since it doesn't change the data that needs to be scanned.
The user even highlights numerous places in the documentation and hints in the UI which communicate BQ pricing model... so it's interesting they decide to post that it's hidden or dark pattern.
Bigquery has a feature in pre-release stage which will be useful for a limit-like experience while incurring much lower cost.
The user even highlights numerous places in the documentation and hints in the UI which communicate BQ pricing model... so it's interesting they decide to post that it's hidden or dark pattern.
Bigquery has a feature in pre-release stage which will be useful for a limit-like experience while incurring much lower cost.
https://cloud.google.com/bigquery/docs/table-sampling