Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone!
I would like to provide an incremental refresh for one of our biggest tables.
It is a oracle/ odbc table that is currently accessed by this sql:
SELECT F5801.AA1 AS "Date",
F5801.AA11 AS "Order",
CASE
WHEN F5801.AA12 ='1B' THEN Replace(REGEXP_SUBSTR(F5801.AA12 , '(^|[:])[0-9]+'), '+', '')
END AS "Value"
FROM PROD.F5801 F5801
WHERE F5801.AA1 > 120000
AND NOT EXISTS (SELECT *
FROM PROD.F5801 F5801_2
WHERE F5801_2.AA13 = F5801.AA14)
As you can see, there is a Case within Select, a Date filter based on a Number, and the last filter based on Values within two columns.
Is it possible to get this transformed for an incremental refresh?
Hi. I don't think you can handle this in a query. Incremental refresh is managed in power query. You can check this video to understand how to try it:
https://www.youtube.com/watch?v=BQahH53ayKU
Hope that helps 🙂
Happy to help!