How to use snapshot clause in the Query Service | Community
Skip to main content
Level 2
September 6, 2023
Solved

How to use snapshot clause in the Query Service

  • September 6, 2023
  • 1 reply
  • 1386 views

Hello,

 

we have a requirement to keep the data in two datasets in sync. For some reason, we can't ingest the same payload in both the datasets. We are planning to leverage the scheduled query service for this. For the incremental approach, I think snapshot clause is the way to move forward. However, I am not sure where do I get the snapshot ids to use in the query.

 

Can someone please help here?

Best answer by arijitg

Hi @mittalabhi86-1 

 

Please run below query in data lake :

select history_meta('<your_dataset_table_name_here>');

 

 

1 reply

arijitg
Adobe Employee
arijitgAdobe EmployeeAccepted solution
Adobe Employee
October 10, 2023

Hi @mittalabhi86-1 

 

Please run below query in data lake :

select history_meta('<your_dataset_table_name_here>');