SOLVED Hi team I m trying to load a few files stored on GCP

Question

SOLVED Hi team I m trying to load a few files stored on GCP with my kedro pipeline but I m getting the error ```DatasetError refresh token ``` It happens on all files I try to load `xlsx` `pkl` `parquet` Any clues on that

Gabriel Bandeira · Answer

```Python 3 10 12 kedro==0 18 12 kedro datasets spark pandas ==1 5 3 gcsfs==2023 9 0```

Gabriel Bandeira · Answer

On my credentials file I don t have the key `refresh token` I only have the keys ```type project id private key id private key client email client id auth uri token uri auth provider x509 cert url client x509 cert url universe domain``` I am able to connect to the GCP account using this credentials for loading and saving directly on BigQuery but I need to open a link and authenticate on the browser to do it

Gabriel Bandeira · Answer

SOLUTION I needed to authenticate using `GOOGLE APPLICATION CREDENTIALS` environment variable pointing to a json with credentials

Elaine Resende · Answer

Hey Gabriel how is you credentials file Which keys it has I have generated mine but i am getting a DatasetError

Gabriel Bandeira · Answer

Hi < Elaine Resende> Sorry for the late response but I just saw it now My credentials file is a json with the following keys 1 type 2 project id 3 private key id 4 private key 5 client email 6 client id 7 auth uri 8 token uri 9 auth provider x509 cert url 10 client x509 cert url 11 universe domain

Elaine Resende · Answer

Thanks