Keep a column as ARRAY when synchronizing a PostgreSQL table into a dataset

Benoit Registered Posts: 2 ✭✭✭✭
edited July 16 in Using Dataiku

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?


Setup Info
      Help me…