• kdb+

  Tableau incremental refresh not working as expected on kdb, through kdb odbc driver.

  Posted by sundeepnd on August 16, 2023 at 12:00 am

  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.

   

  sundeepnd replied 9 months, 2 weeks ago 2 Members · 2 Replies
• 2 Replies

• 

  rocuinneagain

  Member

  August 17, 2023 at 12:00 am

  Could you format you code. This will make it easier for others to read/understand it so that they can help.

• 

  sundeepnd

  Member

  August 17, 2023 at 12:00 am

  Hi, thank you! its taken care.

Log In to Reply