I am trying to run the following flow using the following SQL code:
select adv.`Account`, adv.`LDGRDATE` Adv_Ledgerdate, cre.`LDGRDATE` Prorate_LedgerDate, adv.`Total_Amnt`,
cre.`Total_Amnt` Prorate_Amount, adv.`Ledger Type`, cre.`Ledger Type` Prorate
from `test_grp` adv
left outer join `credit_prorate` cre ON cre.`Account` = adv.`Account`
and month(cre.`LDGRDATE`) = month(adv.`LDGRDATE` - interval 1 month)
The first table is about 599K rows, the second is 300K rows. When running this query in the sample it runs fine, however when running it for the whole flow, it just runs and doesn't stop (has been running now for about 5 hours).
Can anyone assist with why this wouldn't work? Does DOMO not do well with joins? Or are the tables too big?