Check out the first Dataiku 8 Deep Dive focusing on Productivity on October 29th Read More

Editing table creation sql

Level 1
Editing table creation sql

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?

0 Kudos
1 Reply
Level 1
Author

Bump.

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

0 Kudos