You can calculate the values of the Google Analytics 4 New Users metric in BigQuery by counting the distinct values of user_pseudo_id whose first interaction date occurs within the specified time period.
Use the following SQL (automatically generated via a text prompt in ChatGPT) to track GA4 New Users in BigQuery: