SNAPSHOT ETL DATAFLOW

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

Answers

  • GrantSmith
    GrantSmith Indiana 🔴

    Hi @WorldWarHulk 

     

    It appears that the screenshot you posted is from the Knowledge base article (https://knowledge.domo.com/Prepare/DataFlow_Tips_and_Tricks/Creating_a_Recursive%2F%2FSnapshot_ETL_DataFlow) 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