Select Latest Snapshot Date Data in the Synapse View
Sharukh Kundagol
145
Reputation points
Hi Team,
I have delta table which will have multiple snapshot dates and I need to create view in synapse server less to select the data for latest snapshot.
something like below, but it is not working can you please assist.
CREATE or ALTER view myiew as
SELECT top 10 SnapshotDate FROM
OPENROWSET(
BULK '/SCFW/TransformLayer/TransactionObject/SCFWCategoryWasteManagementSnapshot/',
data_source = 'adlsLocalPassthrough',
FORMAT = 'DELTA'
) AS SCFWCategoryWasteManagementSnapshot where SnapshotDate
= ( SELECT max(SnapshotDate) from SCFWCategoryWasteManagementSnapshot);
Sign in to answer