错误:未找到:在美国位置未找到数据集 my-project-name:domain_public [英] Error: Not found: Dataset my-project-name:domain_public was not found in location US

问题描述

我需要查询一个公共项目提供的数据集.我创建了自己的项目并将他们的数据集添加到我的项目中.有一个名为:domain_public 的表.当我查询此表时，出现此错误:

I need to make a query for a dataset provided by a public project. I created my own project and added their dataset to my project. There is a table named: domain_public. When I make query to this table I get this error:

 Query Failed
Error: Not found: Dataset my-project-name:domain_public was not found in location US
Job ID: my-project-name:US.bquijob_xxxx

我来自非美国国家.请问这是什么问题，如何解决?

I am from non-US country. What is the issue and how to fix it please?

编辑 1:我将处理位置更改为 asia-northeast1(我在新加坡)但同样的错误:

EDIT 1: I change the processing location to asia-northeast1 (I am based in Singapore) but the same error:

Error: Not found: Dataset censys-my-projectname:domain_public was not found in location asia-northeast1 

这是我的项目和公共项目censys-io的视图:

Here is a view of my project and the public project censys-io:

请指教.

编辑 2:我以前输入的查询基于 censys 教程是:

EDIT 2: The query I used to type is based on censys tutorial is:

#standardsql
SELECT domain, alexa_rank
FROM domain_public.current
WHERE p443.https.tls.cipher_suite = 'some_cipher_suite_goes_here';

当我将 FROM 子句更改为:

When I changed the FROM clause to:

FROM `censys-io.domain_public.current`

最后一行:

WHERE p443.https.tls.cipher_suite.name = 'some_cipher_suite_goes_here';

它奏效了.我是否应该理解我应该始终包含 projectname.dataset.table(如果我使用正确的术语)并指出 Censys 的错字?还是因为某种原因这个项目的特例?

It worked. Shall I understand that I should always include the projectname.dataset.table (if I'm using the correct terms) and point the typo the Censys? Or is this special case to this project for some reason?

推荐答案

问题出在 FROM 子句中的表名错误.正确的 FROM 子句应该是:

The problem turned out to be due to wrong table name in the FROM clause. The right FROM clause should be:

FROM `censys-io.domain_public.current`

当我打字时:

FROM domain_public.current

所以FROM中需要项目名，因为项目名中有-，所以需要``.

So the project name is required in the FROM and `` are required because of - in the project name.

这篇关于错误:未找到:在美国位置未找到数据集 my-project-name:domain_public的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！