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.
SELECT
friendly_name, project_id, location
FROM
gcp_bigquery_tables
WHERE
num_partitions = 0;