BigQuery - Select Top N Records
insights Stats
Data analytics with Google Cloud Platform (GCP). For BigQuery SQL mentioned in the articles, they are all using standard SQL dialect unless specified differently.
In BigQuery, there is no TOP N clause implemented however there is LIMIT clause available.
LIMIT clause
The following query retrieves 10 records from table table_name of data set data_set in project project_test.
select * from `project_test.data_set.table_name` limit 10;
Cost implications
It's very important to understand that LIMIT doesn't reduce your query cost. In the above example, all the records in the table will be read and then only 10 will be returned. Thus please take this into consideration.
Preview feature
If the purpose is to inspect the sample data in the table, please use preview feature of BigQuery which is free.
Follow these steps to do that:
- Expand your BigQuery project and data set.
- Select the table you'd like to inspect.
- In the opened tab, click Preview.
Preview will show the sample data in the table.