Can it really be right that I can't define a dynamic datasource using Dataprep. As far as i can see i can only point on a BigQuery Table. I need to point at a certain partion within a table. The naming of the partions always includes the date. like. "ga_20171113".
使用Dataprep无法定义动态数据源真的是对的。据我所知，我只能指向一个BigQuery表。我需要指出表格中的某个部分。 partions的命名总是包括日期。喜欢。 “ga_20171113”。
I really dont understand why i just cant define a SQL thoughwards BQ and use that as a source.
我真的不明白为什么我不能定义SQL以及BQ并将其用作源。
1 个解决方案
#1
2
Dataprep can ingest data from BigQuery views, which should hopefully be able to support your use case. https://cloud.google.com/bigquery/docs/views has details on creating views. One note: Dataprep only supports views created using standard SQL rather than legacy SQL. So when creating a view from a query, please make sure that "Use Legacy SQL" is unchecked in the query options.
Dataprep可以从BigQuery视图中提取数据，希望能够支持您的用例。 https://cloud.google.com/bigquery/docs/views包含有关创建视图的详细信息。需要注意的是：Dataprep仅支持使用标准SQL而不是旧SQL创建的视图。因此，在从查询创建视图时，请确保在查询选项中取消选中“使用旧版SQL”。
#1
2
Dataprep can ingest data from BigQuery views, which should hopefully be able to support your use case. https://cloud.google.com/bigquery/docs/views has details on creating views. One note: Dataprep only supports views created using standard SQL rather than legacy SQL. So when creating a view from a query, please make sure that "Use Legacy SQL" is unchecked in the query options.
Dataprep可以从BigQuery视图中提取数据，希望能够支持您的用例。 https://cloud.google.com/bigquery/docs/views包含有关创建视图的详细信息。需要注意的是：Dataprep仅支持使用标准SQL而不是旧SQL创建的视图。因此，在从查询创建视图时，请确保在查询选项中取消选中“使用旧版SQL”。