Getting error "catalog-name.schema-name.INFORMATION_SCHEMA.PARTITIONS is not a valid identifier" when trying to retrieve metadata from BigQuery INFORMATION_SCHEMA
Create a view in BigQuery that extracts the required metadata from BigQuery INFORMATION_SCHEMA, then query that view from Lakehouse Federation....