Advanced Designer Learning Path is now live! Read More

Filter large dataset using a plugin

Filter large dataset using a plugin
I have a large dataset (~200GB) that I would like other users to be able to filter by entering configuration parameters. (e.g. column contains "term")

Plugin recipes are written in Python (or R), however the dataset is too large to load into a pandas DataFrame.

How can I write the plugin recipe so that the data can be easily filtered by a user?
2 Replies
Hi Jonathan,

In python, you can use our advanced API to read a large dataset by chunks:

Otherwise, you can design a plugin to call SQL, and do the filtering in SQL:

Best regards,

Level 1
Thanks Henri
0 Kudos
Labels (3)
A banner prompting to get Dataiku DSS