You can calculate the values of the Google Analytics 4 Total Users metric in BigQuery by counting the unique values of the ‘user_pseudo_id’ for users who generated at least one event within the date range.
Use the following SQL (automatically generated via a text prompt in ChatGPT) to track GA4 Total Users in BigQuery: