This is likely due to expectations around seeing a resource level BQ table in CH, which is currently not supported.
Supported BQ table: gcp_billing_export_v1_<billing_account_id>
Not supported in CH >> gcp_billing_export_resource_v1_<billing_account_id>