I have a Snapshot dataflow running daily. I want to take this resulting dataset into another Dataflow and then add a filter to dynamically only look at the rows of data with a Snapshot date reflecting the 1st of the month. Any hints on the SAQL I could use for this? Thanks.
FYI @Gabriel Kacarab
댓글 2개
Hi @Peter Lyons thank you. That resolved the issue. My syntax hapened to be 01 as you notated. I checked in a Lens. MY SAQL statement was as follows: Snapshot_Date_Day == "01"