BigQuery Error: View Parsing Failure on unified_downloads

[Wafaa Hafez]

Dear M-Lab Team,

I'm encountering an error while querying the public measurement-lab.ndt.unified_downloads dataset via BigQuery. Here's the query I'm running:

SELECT

  date,

  client.Geo.Latitude,

  client.Geo.Longitude,

  client.Network.ASName,

  client.Network.ASNumber,

  client.IP,

  a.MinRTT,

  a.MeanThroughputMbps,

  LOWER(a.Direction) as `type`,

  client.Geo.Subdivision1Name as subdivision

FROM `measurement-lab.ndt.unified_downloads`

WHERE

  date >= "2025-06-28" AND date <= "2025-06-29"

  AND client.Geo.CountryName = "United States"

ORDER BY client.Geo.Latitude, client.Geo.Longitude, client.Network.ASName, client.Network.ASNumber, a.MeanThroughputMbps

However, the following error is returned:

Reason: 400 Unrecognized name: parser; Did you mean server?
Failed to parse view 'measurement-lab.ndt_intermediate.extended_ndt7_downloads'

It seems that the internal view ndt_intermediate.extended_ndt7_downloads, which may be referenced inside unified_downloads, is broken due to an invalid field parser.

Could you please take a look or advise on a temporary workaround? I rely on this dataset for my report

Thank you for your support!

FYI: This code was working fine 1 week ago.

Best regards,
Wafaa Ha,

[Nashwa Khalid]

I also got a similar error with our data set:

failed to parse view 'measurement-lab.ndt_intermediate.extended_ndt7_uploads' at [32:15]
Adding it here to learn more and find out if they're related.

Disclaimer

The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.

This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast, a leader in email security and cyber resilience. Mimecast integrates email defenses with brand protection, security awareness training, web security, compliance and other essential capabilities. Mimecast helps protect large and small organizations from malicious activity, human error and technology failure; and to lead the movement toward building a more resilient world. To find out more, visit our website.

[Nathan Kinkade]

We apologize for the disruption. A small change was made to the ndt.ndt7 view which accidentally broke the unified views. The change to ndt.ndt7 will be reverted shortly, which should resolve the issues.

While on the topic of the unified views, I recommend not using them unless you have some very specific need to query ndt5 and ndt7 at the same time. For the last 5 years, the overwhelming majority of test volume comes from ndt7 clients. This was true 5 years ago, and the ndt5 test volume is probably even less today. The unified views are backed by fairly convoluted and expensive queries. Queries to ndt.ndt7 and ndt.ndt5 will almost always be less expensive than to the unified views, sometimes substantially so. The unified views were a useful transition tool when ndt7 was still very new, but should for most use cases not be needed any longer.

Nathan 

--
You received this message because you are subscribed to the Google Groups "discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to discuss+u...@measurementlab.net.
To view this discussion visit https://groups.google.com/a/measurementlab.net/d/msgid/discuss/51d68609-0330-4ebf-b06d-9bf1dc17229bn%40measurementlab.net.