How to get Structure from Field list in Azure Data Factory pipeline?

King Java 665 Reputation points
2023-07-28T03:50:09.9733333+00:00

I am trying to get Structure from Field list (like shown on the second example below) on Get Metadata (shown below), but I am not sure on what condition Structure would be shown from the Field list.

So, I am trying to get Structure from the first example (second example is fine).

I was watching this YouTube from "All About BI!", but it does not show how Structure was displayed.

https://youtu.be/LKjewkeNiJ0?t=122

On the time stamp of 2:02 (of this video), it displays Structure, but it does not explain how it was shown.

First example:

User's image

Second example:

User's image

Can someone explain on what condition "Structure" could be displayed under Field list please? Thank you!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,209 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nandan Hegde 33,946 Reputation points MVP
    2023-07-28T04:43:05.3266667+00:00

    Basically if your datatset path is mapped to a folder , you wont get the structure option but in case if it is file, then you would get it.
    As structure is a property of file

    Also :
    User's image

    Scenario 1 ) Binary dataset :

    User's image

    Scenario 2) Path

    User's image

    User's image

    Scenario 3) file delimited/excel

    User's image

    User's image


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.