Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
My dataiku recipes are taking too long to run because of the absence of indexes in the parent datasets. How do i add indexing in the output data so that the next recipe in the flow can take advantage of the indexing. I need help urgently. Thanks in advance
Hi akuma,
Should you need indexes on your tables, go under the dataset in question and follow these steps:
Go to Settings > Advanced. There you will find pre and post write statements. As an example in the pre-write statement you could drop the index and post-write create it again. This needs to follow the specific SQL syntax of your database.
So for postgres it would look like:
Pre-write statements:
DROP INDEX IF EXISTS some_index;
Post-write statements:
CREATE INDEX some_index ON "${projectKey}_table_name"(column);