What you would like to accomplish:

When inserting rows through streaming (with dataflow and the 'STREAMING_INSERTS' option), it is possible to have the insertion timestamp in a column but putting "AUTO" as a value of a column of type TIMESTAMP (see https://issuetracker.google.com/issues/72080883). However, this does not work with bq load, which means that one cannot switch to 'FILE_LOADS' insertion option in dataflow as it throws the error :

- Error while reading data, error message: JSON parsing error in row
starting at position 0: Couldn't convert value to timestamp: Could
not parse 'AUTO' as a timestamp. Required format is YYYY-MM-DD
HH:MM[:SS[.SSSSSS]] or YYYY/MM/DD HH:MM[:SS[.SSSSSS]] Field:
foo; Value: AUTO

How this might work:

Make this feature available to data loaded though bq load.

If applicable, reasons why alternative solutions are not sufficient:

I do not know of an alternative.

Other information (workarounds you have tried, documentation consulted, etc):

N/A