# Find GCP BigQuery tables without partitioning enabled

**URL:** <https://community.cloudquery.io/t/find-gcp-bigquery-tables-without-partitioning-enabled/1211>\
**Category:** Queries & Insights\
**Tags:** queries, gcp\
**Created:** [August 6, 2025, 7:50am UTC](https://community.cloudquery.io/t/find-gcp-bigquery-tables-without-partitioning-enabled/1211 "2025-08-06T07:50:12Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![pilvikala](https://sea1.discourse-cdn.com/flex001/user_avatar/community.cloudquery.io/pilvikala/32/11_2.png) [@pilvikala](https://community.cloudquery.io/u/pilvikala)\
**Post date:** [August 6, 2025, 7:50am UTC](https://community.cloudquery.io/t/find-gcp-bigquery-tables-without-partitioning-enabled/1211/1 "2025-08-06T07:50:13Z")

</div>

Tables without partitioning lead to expensive queries due to full table scans. Here’s a PostgreSQL query that you can use to find all expired certificates from your GCP CloudQuery sync.

```sql
SELECT
	friendly_name, project_id, location
FROM
	gcp_bigquery_tables
WHERE
	num_partitions = 0;

```