The Get Metadata activity is used to retrieve the metadata of any data in the Azure Data Factory or a Synapse pipeline. We can use the output from the Get Metadata activity in conditional expressions to perform validation or consume the metadata in subsequent activities.
It takes a dataset as input and returns metadata information as output. Currently, the following connectors and the corresponding retrievable metadata are supported. The maximum size of returned metadata is 4 MB.
Please refer to the snapshot below for supported metadata which can be retrieved using the Get Metadata activity.
Get Metadata Activity in Azure Data Factory
Source: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-get-metadata-activity#metadata-options