How to use "Allow SQL across connections" checkbox SQL Recipe

Brett
Brett Registered Posts: 1 ✭✭✭✭

I am trying to join two tables that exist on different connections (each table resides within its own database and SQL Server instance). I thought the "Allow SQL across connections" checkbox in the Advanced tab of the SQL Recipe would enable this functionality, but I run into an error where the table that does not reside within "Main SQL Connection" cannot be found. We are using Dataiku version 6.0.5. Any help would be greatly appreciated!

Answers

  • Liev
    Liev Dataiker Alumni Posts: 176 ✭✭✭✭✭✭✭✭

    Hi @Brett

    You're not giving us much to go on here

    I recommend if this is a blocker and still unresolved to submit a job diagnostic to our support team.

    Please see here how to obtain one.

Setup Info
    Tags
      Help me…