Ready for Dataiku 10? Try out the Crash Course on new features!GET STARTED

Editing table creation sql

ys91
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
ys91
Level 1
Author

Bump.

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

0 Kudos
A banner prompting to get Dataiku DSS