Azure Synapse Link - Some additional columns in workspace

Question

Azure Synapse Link - Some additional columns in workspace

KUMAR Manish 1

I have started integrating Azure Synapse Link. Just added “account” entity. After that, I compared column names with CRM attributes and found a few additional columns here in the workspace. Mainly, the names of the columns have the suffix “_entitytype”. So, would like to know more about these columns and their relevance.

workspace_entitytype

PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2023-03-27T05:01:49.3533333+00:00

KUMAR Manish - We are reaching out to the internal team to get more details on this issue. I will be update you once I hear back from the team.
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2023-03-29T07:56:37.75+00:00

@KUMAR Manish Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you

1 answer

Your answer

PRADEEPCHEEKATLA 91,656 Reputation points Moderator

2023-03-27T05:01:49.3533333+00:00

KUMAR Manish - We are reaching out to the internal team to get more details on this issue. I will be update you once I hear back from the team.
KranthiPakala-MSFT 46,737 Reputation points Microsoft Employee Moderator

2023-03-29T07:56:37.75+00:00

@KUMAR Manish Just checking in to see if the below information was helpful. If it answers your query, please do click Accept Answer and Yes for "was this answer helpful", as it might be beneficial to other community members reading this thread. If you have any further query, do let us know.

Thank you

Answer 1

KranthiPakala-MSFT 46,737 Microsoft Employee Moderator

Hi @KUMAR Manish , As per the discussion with internal team, the columns with suffix _entitytype is used to track the type of the entity in dataverse. For example, modifiedby Type is Lookup in below example.

User's image

Hope this clarifies. Please let us know if you have further questions.

Thank you

Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

KUMAR Manish 1 Reputation point

2023-03-29T12:57:32.7533333+00:00

Hi - Still, I am not able to find the corresponding attributes in Dataverse. Suppose, there is a scenario in which I query Dataverse directly and would like to get metadata from the API then how I will get these "_entitytype" attributes because they are not present as attributes in Dataverse?

Share via

Azure Synapse Link - Some additional columns in workspace

1 answer

Your answer