google-bigquery - 需要通过 IR 连接 ADF 和 BigQuery

Question

我想通过 IR 连接 Azure 数据工厂和 Google Big Query，需要哪些值以及如何从 Big Query 访问数据

标签： google-bigqueryazure-data-factory

Answer 1

ADF 支持 google 大查询连接器：https ://docs.microsoft.com/en-us/azure/data-factory/connector-google-bigquery 。下面给出了一个链接服务有效负载示例：

{
    "name": "GoogleBigQueryLinkedService",
    "properties": {
        "type": "GoogleBigQuery",
        "typeProperties": {
            "project" : "<project ID>",
            "additionalProjects" : "<additional project IDs>",
            "requestGoogleDriveScope" : true,
            "authenticationType" : "UserAuthentication",
            "clientId": "<id of the application used to generate the refresh token>",
            "clientSecret": {
                "type": "SecureString",
                "value":"<secret of the application used to generate the refresh token>"
            },
            "refreshToken": {
                "type": "SecureString",
                "value": "<refresh token>"
            }
        }
    }
}