Compare columns in a struct or Records - Issues in BigQuery

[Maxime-Laine]

Is your feature request related to a problem? Please describe. I am unable to compare columns in as Struct in bigquery

Describe the solution you'd like It would be great to have the possibility of reading the columns inside a structure or records and if possible in a other version to read the columns inside a nested record

Describe alternatives you've considered A clear and concise description of any alternative solutions or features you've considered.

Additional context Add any other context or screenshots about the feat ure request here.

[erezsh]

Hello, thank you for opening this feature request.

We have not yet tested data-diff with records.

Can you please describe the current behavior? Are you getting an error message, or is the diff failing to return the correct results?

[Maxime-Laine]

Hello

Today, we get just the information that we have a records that seem the be the same (picture above) -

It would be great if data-diff read the columns inside the records and compare them, for example in the table above I have 3 records, in the recors "users". I have all the columns related to a user such as the picture below :

Thus the idea is to get the columns inside a records and compare them.

[erezsh]

If I understand correctly, data-diff currently can diff whole records, and you would like the ability to only diff specific fields inside a record? i.e. diff a subset of a record, instead of everything inside it?

[erezsh]

Closed due to inactivity