Validate at SQL recipe using the public API (python)

[joshlk]

How do you validate a SQL recipe using the public API?

[Clément_Stenac]

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 !

[joshlk]

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]

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]

I also need this feature

[ocean_rhythm]

This method validates both datasets and recipes: https://community.dataiku.com/t5/Using-Dataiku/API-to-check-managed-SQL-dataset-schema-consistency/m...