0

I want schema through get metadata activity so it can be passed as an output to stored procedure

sakshi agarwal
  • 1
  • could you please edit your question to add any sample data and expected result? – Rakesh Govindula Aug 08 '22 at 08:32
  • https://stackoverflow.com/questions/68545929/dynamic-creation-of-external-tables-in-synapse/73274581#73274581 In this getmetadata activity is helping to get schema using structure property but i dont find this property inside metadata – sakshi agarwal Aug 08 '22 at 08:42

1 Answers1

0

If you give only folder in the dataset that you provided for, Get Meta Data activity it won't show the structure property in the list.

enter image description here

It will show the Folder properties like Item name, type.


enter image description here

To get the structure property, you need to give the file name in the Dataset and check on First row as header.

enter image description here

Now, you can see file properties like structure and columns count in the activity.

enter image description here

Sample Output of a Blob file:

enter image description here

You can pass this JSON string to your stored procedure activity.

Rakesh Govindula
  • 5,257
  • 1
  • 2
  • 11
  • Thanks for this can we create get metadata recursively to get folder name inside another folder @RakeshGovindula – sakshi agarwal Aug 12 '22 at 08:43
  • @sakshiagarwal, you can try this approach https://richardswinbank.net/adf/get_metadata_recursively_in_azure_data_factory from Richard Swinbank. – Rakesh Govindula Aug 13 '22 at 09:51
  • Thank you but i need some simple approach – sakshi agarwal Aug 16 '22 at 08:31
  • As far as I know, Meta data activity does not have any feature for recursive file inside subfolders. and we cannot call same pipeline within it in ADF like recursion in programming languages. So, we have to use this kind of techniques to get the desired result from Meta data activity in ADF. Please try asking another question on it, so other community members able to answer it – Rakesh Govindula Aug 16 '22 at 10:45