朱皮特的卡格尔

Question

我正在尝试将我的kaggle项目链接到Google云平台，但我似乎无法完成它，即使我遵循了：https://cloud.google.com/docs/authentication/getting-started

我仍然得到这个错误：

DefaultCredentialsError:File/C:/Users/Jirah-Marie-Navarro/kagglebqtest-2999bd391350.json未找到

这是我的代码：

    # Replace 'kaggle-competitions-project' with YOUR OWN project id here --  
    PROJECT_ID = 'kagglebqtest'

    from google.cloud import bigquery
    client = bigquery.Client(project=PROJECT_ID, location="US")
    dataset = client.create_dataset('bqml_example', exists_ok=True)

    from google.cloud.bigquery import magics
    from kaggle.gcp import KaggleKernelCredentials
    magics.context.credentials = KaggleKernelCredentials()
    magics.context.project = PROJECT_ID

    # create a reference to our table
    table = client.get_table("kaggle-competition-datasets.geotab_intersection_congestion.train")

    # look at five rows from our dataset
    client.list_rows(table, max_results=5).to_dataframe()

Answer 1

似乎GOOGLE_APPLICATION_CREDENTIALS environment variable的设置不正确

我建议您验证“kagglebqtest-2999bd391350.json”文件是否位于路径“C:/Users/Jirah-Marie-Navarro/”中

我建议您也使用不带空格的路径，例如“C:/”或“C:/credentials/”，可能无法识别路径中空格的JSON凭据，因此您可以尝试以下方法：

$env:GOOGLE_APPLICATION_CREDENTIALS="C:\credentials/kagglebqtest-2999bd391350.json"