-
Tableau incremental refresh not working as expected on kdb, through kdb odbc driver.
Hi Team,
I need your help.
Incremental refresh query:
q('.function.[`commTrades2;`startTime`endTime!(2023.06.01;.z.d-1)]')n) Custom_SQL_QuerynWHERE (Custom_SQL_Query.date > {d '2023-08-14'})","query-category":"Extract","query-hash":368329134},"ctx":{"wb":"gwGetCommodities"}}I could see where clause in logs for incremental refresh but strangely what’s happening on kdb is its running fully query, as you could see above, from 2023.06.01 to till date and then after fetching entire query data its applying where clause on date column (nWHERE (Custom_SQL_Query.date > {d ‘2023-08-14’})”,”). Ideally incremental refresh should only query max of date directly but its not happening. Please may you advise.
-
2 Replies
-
Could you format you code. This will make it easier for others to read/understand it so that they can help.
-
Hi, thank you! its taken care.
Log in to reply.