https://delta.io logo
s

Steve Quan

01/25/2023, 3:01 AM
Hi, does anyone know whether we can use Synapse serverless pool (Built-in) to query a delta file's previous version?
something like
SELECT
TOP 100 *
FROM
OPENROWSET(
BULK '<https://my_dir>',
FORMAT = 'DELTA'
) version as of 3
o

Omkar

01/27/2023, 7:01 AM
Hey @Steve Quan, unfortunately looks like Synapse Serverless SQL pool currently doesn't support the Time Travel feature in Delta (i.e. querying previous versions of data). You may refer to this Azure doc for the list of known issues of Delta Lake with Serverless SQL pool for more info: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand?tabs=x80070002#delta-lake
👍 1
5 Views