Currently the schemas of the external tables are autodetected from the csv. This is causing tasks to fail if the autodetected type does not match the target type. For example, app version should be a string because of values like 60.0.1 but if for a particular date, all values are coercible to a float, e.g. 60.0, then the detected type will be a float.
Setting the schema will allow values like 60.0 to be treated as a string.
Currently the schemas of the external tables are autodetected from the csv. This is causing tasks to fail if the autodetected type does not match the target type. For example, app version should be a string because of values like
60.0.1but if for a particular date, all values are coercible to a float, e.g.60.0, then the detected type will be a float.Setting the schema will allow values like
60.0to be treated as a string.