BigQuery replication plugin does not handle datetime correctly

Description

The CDAP datetime logical type allows setting a LocalDateTime java object, which goes up to nanosecond precision. This is more precise than BigQuery datetime, which only goes up to microsecond precision ( ).

This causes issues when reading datetimes from sources that are more precise than microsecond. For example, sql server type datetime2 has 7 digits of precision, which will cause the BigQuery load jobs to fail with errors like:

Release Notes

Fix issue in BigQuery replication plugin which caused pipeline to fail when replicating datetime from sources that are more precise than microsecond, for example datetime2 data type in sql server.