Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
I tried to sync a PostgreSQL table in a dataset but columns of type `array` are converted to type `string`.
I need to keep those columns as `array` to be able to use functions such as `unnest` or `string_agg` in a further recipe.
If I change the schema manually in the tab type of the dataset, I get this error when running the job:
Can't handle column type ARRAY in SQL
I am using Dataiku DSS version 3.1.0 with a PostgreSQL 9.4 database
Does anyone have an idea?