Logic not working

[akshatrami]

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.

[akshatrami]

@blue1  can you help me on this?

[blue1]

Hi Akshatrami, do you see any errors, or what do you mean that it stops working?

[akshatrami]

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.

[blue1]

In your case, I would separate all the the parts of the logic into their own columns so you can see exactly what is going wrong. So have a column for shift_start_time , shift_end_time and current_timestamp. Then look at them in your table and figure out if you can see anything wrong. Feel free to post a picture of that here in the chat.

[akshatrami]

@blue1 any suggestions would be appreciated.