Open whd opened 5 years ago
Another example: incompatible GC data
There is also expected future support for variable BQ types. Generally I'm not a fan of this approach because it makes querying more difficult, but the fact of the matter is if the data is multiple types then we'd have to deal with that at query time no matter what.
Even if we use UDFs/Views, wouldn't we still need the coercion in the decoder, since the improper schemas would be invalid?
This was discussed briefly in our Monday meeting with the outcome being to file an issue to hammer out the details.
There are a few classes of special cases where it is perhaps desirable to transform input data in some way beyond what we already do. The ones discussed have been:
This is specifically to accommodate bad clients or clients that we can't fix, since getting clients to submit schema-conformant types is obviously preferred.
Examples include: a. pre-account ping scalars (maybe not an issue in GCP due to probe-scraper infrastructure) b. Sync pings c. DSMO schema evolution (implemented late enough on GCP that we started with the changed type).
See #633 for an example and relevant discussion.
Some potential resolutions:
additionalProperties
or will otherwise be considered decoder errors.