Execute SQL recipe from code stored on Git?

info-rchitect Registered Posts: 169 ✭✭✭✭✭✭


Is it possible to run a SQL recipe using code stored on Git? The advantage is here is a single source of truth vs relying on dataiku revision control. The reason this is advantageous is we want to be able to run the exact same code outside of dataiku.


Operating system used: Windows 10


Best Answer


  • info-rchitect
    info-rchitect Registered Posts: 169 ✭✭✭✭✭✭


    Yeah I figured as much and I am familiar with using Python to execute SQL. Just think the ability to directly load and execute SQL from Git is a valuable feature. While I am happy that dataiku uses Git under-the-hood, I don't want multiple sources of truth. Being able to retrieve a Git tag and know the SQL being executed is not altered in any way is crucial. If I use a Python recipe I have to do the following:

    1. Import the library into my project, exposing it to possible edits

    2. Create an extra Python recipe and execute the SQL


Setup Info
      Help me…