Referring to BQML documents The CREATE MODEL statement for ARIMA_PLUS models, we can include public holidays of a country (e.g. HOLIDAY_REGION = 'US') while using BQML with time series model. It has also shown the holiday data in the US region for the year 2022-2023 ("Holiday data" section).
My question is how I can view or edit the holiday data (e.g. primary_date, preholiday_days and postholiday_days) of a particular country for my own BQML time series modelling? Thanks in advance for any suggestions.
With BigQuery ML's latest release, you are now able to view and edit the holiday data.
To view the built in holiday, you can inspect the bigquery-public-data.ml_datasets.holidays_and_events_for_forecasting table. Or you can feed your ARIMA model to the ML.HOLIDAY_INFO TVF.
To customize the holiday, you can feed custom holiday data in the same CREATE MODEL statement with new syntax. This tutorial also has a step by step walk through.