Editing table creation sql

[ys91]

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:

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?

[ys91]

Bump.

If it's possible with the API, I'll be glad to hear about it too.