When loading AVRO files into BigQuery, the useAvroLogicalTypes parameter must be set in order to load timestamps properly typed.
External tables for BigQuery can specify this. We have verified it works correctly when doing a load job (not external tables) with an avro file with logical types.
However the Config Connector does not allow this field when creating a config connector!
Importance
This is a blocker to our company using AVRO as our loading mechanism (which we currently are).
If we cannot get this feature, we will need to re architect our entire loading for 200+ pipelines in the near future.
Describe the feature or resource https://issuetracker.google.com/issues/210367196
When loading AVRO files into BigQuery, the useAvroLogicalTypes parameter must be set in order to load timestamps properly typed.
External tables for BigQuery can specify this. We have verified it works correctly when doing a load job (not external tables) with an avro file with logical types.
However the Config Connector does not allow this field when creating a config connector!
Importance This is a blocker to our company using AVRO as our loading mechanism (which we currently are).
If we cannot get this feature, we will need to re architect our entire loading for 200+ pipelines in the near future.
Related to https://github.com/hashicorp/terraform-provider-google/issues/10119