Submit your innovative use case or inspiring success story to the 2023 Dataiku Frontrunner Awards! LET'S GO

Validate at SQL recipe using the public API (python)

joshlk
Level 1
Validate at SQL recipe using the public API (python)
How do you validate a SQL recipe using the public API?
0 Kudos
4 Replies
Clément_Stenac
Dataiker
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 !
0 Kudos
joshlk
Level 1
Author
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?
0 Kudos
thomaslprru
Level 2

4 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

gauviv
Level 1

I also need this feature

 

0 Kudos