sqlmetadataazure-synapseopenrowset

SQL Server Serverless - Openrowset - Metadata functions?

I am using Openrowset with OpenJson to query files in a data lake using a Synapse SQL Serverless database.

I have found the filename() and filepath() file metadata functions. https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/query-specific-files#filepath

Are there more functions or is that it? I would really like to be able to get the file modified timestamp.

Solution

  • File metadata features are not supported via serverless function.

    You should use Synapse spark notebook to query the blob metadata instead. You can find more information at BlobProperties Class