InvalidColumnNameException["_fivetran_synced" conflicts with system column pattern]

[amotl]

Problem

Fivetran uses private column names prefixed with _. CrateDB currently blocks those, because it reserved them.

Workaround

Works slightly, but it's still a serious anomaly that may cause compatibility problems.

https://github.com/crate-workbench/cratedb-fivetran-destination/blob/078d5427c1bd0b39c33fde9d80e1c55b571bb3be/cratedb_fivetran_destination/util.py#L21-L26

References

• SQL DDL error InvalidColumnNameException["_foo" conflicts with system column pattern] crate#15161