Editing table creation sql

ys91
ys91 Registered Posts: 2 ✭✭✭✭

Hi,

I'm using mariadb jdbc connector from Dataiku to Memsql.

When creating an output dataset and storing it in the database, the table is created in the db as memory stored (because this is the default in Memsql), but I want to change it to be created always as columnstore by default - for all output datasets.

I saw that after the output dataset is created, I can edit its table creation sql under Advanced->settings, change it to "manually define", and there add the necessary syntax to make it columnstore:

Capture.PNG

indeed when I do this and drop and recreate the table, it is created the right way.

Is there a way I can add this "suffix" to every table creation sql in Dataiku, so that way it will be added by default each time I create an output dataset?

Answers

Setup Info
    Tags
      Help me…