Validate at SQL recipe using the public API (python)
Options
joshlk
Registered Posts: 7 ✭✭✭✭
How do you validate a SQL recipe using the public API?
Answers
-
Hi,
This feature is not available in the API. We'll have a look at adding this in a future release.
Thanks for the suggestion ! -
The reason I ask is that if I create SQL recipes using the public API the job will fail if I don't go manually validate each SQL recipe. Am I missing something? Is there another way?
-
thomaslprru Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 10 ✭Options4 years later, is there a way to do it?
I also wanted to know how the syntax check is done? Did you implement your own SQL parser or use already existing python libraries such as sqlparse, sql-metadata, etc?
Thank you in advance
-
I also need this feature
-
This method validates both datasets and recipes: https://community.dataiku.com/t5/Using-Dataiku/API-to-check-managed-SQL-dataset-schema-consistency/m-p/38407/highlight/true#M14238
