List all datasets with partitioned tables, broken-down by partitioning type

list_dataset_partitioning.sql

SELECT
  TABLE_SCHEMA, 
  count(distinct table_name) as table_count,
  CASE
    WHEN IS_SYSTEM_DEFINED = 'YES' THEN 'Ingestion-Time'
    WHEN data_type = 'TIMESTAMP' THEN concat('Time-unit column')
    WHEN data_type = 'INT64' THEN concat('Integer Range')
END
  AS partitioning_type
FROM
  region-eu.INFORMATION_SCHEMA.COLUMNS
WHERE
  IS_PARTITIONING_COLUMN = 'YES'
GROUP BY
  1,3
order by 3 desc