Execute SQL recipe from code stored on Git?

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

Hi,

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.

thx


Operating system used: Windows 10

Tagged:

Best Answer

Answers

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

    @CatalinaS


    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

    regards

Setup Info
    Tags
      Help me…