Hi Beatiful People - 


I was able to learn how to create a snapshot etl dataflow,


just a quick question,

where in the dataflow can I add a column that shows the date for the historical data and the date column for the appended data?



Best Answers


  • GrantSmith
    GrantSmith Indiana 🔴

    Hi @WorldWarHulk 


    It appears that the screenshot you posted is from the Knowledge base article ( which is what I'm going off of. The way that's configured is it joins the historical with the live data and ignores / filters any historical data which exists in the live file thus you lose and information from the historical dataset.


    Are you wanting to keep a date of when it was first added to the dataset and another when it was last updated on the dataset?


  • you mean to say, it will lose any data when the new data is appended? 


    I need a data to be appended and create a snapshot of historical data...


    my data comes from salesforce which doesnt store historical data... 

  • subscribed to your youtube channel Onyx Reporting