在Azure数据工厂中何处设置allowLargeResults设置 [英] Where to set allowLargeResults settings in Azure Data Factory

问题描述

大家好，

我正在尝试通过Azure数据工厂通过复制数据活动带来大约500 GB的数据。

I am trying bring about 500 GB of data through Copy Data Activity via Azure Data Factory.

来源Connection Manager：Google BigQuery

源数据集：Google BigQuery



目的地将 是Azure Data Lake。

Source Connection Manager: Google BigQuery
Source DataSet: Google BigQuery

Destination would  be Azure Data Lake.

当 我正在运行副本数据活动我得到低于粗体字突出显示的错误。我不知道在Azure Data Factory中为property / attribute  allowLargeResult s
设置上述设置的位置。有人可以帮我这个吗？



错误：

活动GA大查询数据失败：失败发生在"来源"方面。 ErrorCode = UserErrorOdbcOperationFailed，'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message = ERROR [HY000] [Microsoft] [BigQuery]（100）与
REST API交互时出错：响应太大而无法返回。考虑在作业配置中将allowLargeResults设置为true。有关详细信息，请参阅https://cloud.google.com/bigquery/troubleshooting-errors,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,'TypeTypeSystem.Data.Odbc.OdbcException,Message=ERROR
[HY000] [Microsoft] [BigQuery]（100）与REST API交互时出错：响应太大而无法返回。考虑在作业配置中将allowLargeResults设置为true。有关详情，请参阅https://cloud.google.com/bigquery/troubleshooting-errors,Source=Microsoft
Google BigQuery的ODBC驱动程序，

When  i am running the copy Data Activity I am getting below error highlighted in bold fonts. I don't know where to set the mentioned settings for property/attribute allowLargeResults in Azure Data Factory. Could anyone help me on this please?

ERROR:
Activity GA Big Query Data failed: Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Response too large to return. Consider setting allowLargeResults to true in your job configuration. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors,Source=Microsoft.DataTransfer.Runtime.GenericOdbcConnectors,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][BigQuery] (100) Error interacting with REST API: Response too large to return. Consider setting allowLargeResults to true in your job configuration. For more information, see https://cloud.google.com/bigquery/troubleshooting-errors,Source=Microsoft ODBC Driver for Google BigQuery,'

问候，

Balwant。

生活中的失败是没有尝试... ...


PGDCA-98（南古吉拉特大学），MCSA（ SQL 2012），MCTS（SQL Server 2005）



我的博客

推荐答案

你能用1G试试并测试吗

can you try it with 1G and test it

给我们一些反馈。

这篇关于在Azure数据工厂中何处设置allowLargeResults设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！