The process to derive new sub billing account is scheduled to be executed at at 9:00AM and 9:00PM UTC.

This means that after adding new sub-billing accounts to a BigQuery View, CH takes minimum of 12 hours to derive those accounts into the platform.