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

gautier

I also need this feature

WH

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