Forum Discussion

BI_Master123's avatar
BI_Master123
New Member
1 year ago
Solved

Direct Query

Hi Folks,   I have created this query in snowflake to convert JSON format data into table structure: select *, doc:"_class"::STRING AS Class, doc:"_id"::STRING AS Id, doc:"mvrId"::STRING AS ...
Need Help
  • v-prasare's avatar
    v-prasare
    1 year ago

    Hi BI_Master123.,

    Thanks for reaching MS Fabric community support.

     

    The error Expression.Error: The field 'SEQ' already exists in the record arises because the field SEQ is being introduced multiple times in the query, possibly due to it being present in both the main JSON object and within one or more nested arrays (such as in the Address_List, Event_List, or other flattened structures).

    The SEQ field is likely appearing in both the main document (doc) and within the arrays being flattened (Event_List, Address_List, etc.), causing Snowflake to throw a conflict when creating the result set.

     

    Please let me know if this helps resolve your query?

     

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

v-prasare's avatar
v-prasare
Community Support
1 year ago

BI_Master123, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?

 

 

 

Thanks,

Prashanth Are

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query