Populating dataset from another dataset automatically

[shriankur]

I want to populate one dataset from another dataset automatically in Adobe Experience platform

The target dataset has query operations applied from source dataset (View kind of feature)

I don't want to schedule my query as that will not be real-time as I want to maintain the data freshness

As there any way to achieve this?

[archit_garg · Accepted solution]

Will creating a view on top of source dataset help?

CREATE VIEW view_name AS select_query

https://experienceleague.adobe.com/docs/experience-platform/query/sql/syntax.html?lang=en