LinkedIn
Twitter
I can't see my current shift logic working and stops all the time. In the column where it has to come 1 for current date its coming zero. My results are in this format - 2025-04-23T06:00:00+00:00. I am also attaching my logic's snap shot. I have also tried using the date time type but its not working either.
So at the very first I used it in sql itself I will attach the screenshot for that. It worked for an hour or so and I my DAG is set to run every hour so after 1 hour it was not showing me '1' for current datetime. After that I tried using in the dimension same logic but same thing happened and it stopped working after 1 hour. So basically its making all the shift/datetime as 0. However according tot he logic the current shift/datetime should be 1.
