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

Options
Benoit
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?

Answers

Setup Info
    Tags
      Help me…