When using run BigQuery Data Transfer Service to ingest data from S3, I needed to use run-time parameters to provide the current month and day in the URI.

Example: s3://bucket/year=2022/month=6/day=6/*.json

I was unable to find single digit month. Looks like we have the single digit day yet the preceding space makes it not usable. Please refer

%m seems to cover the single digit of month.

SELECT PARSE_DATE('year=%Y/month=%m/day=%e', 'year=2022/month=6/day=6') AS uri_date;