How to set the connecion of Bigquery right?

Hi there,

I am attempting to create a connection of Bigquery and Dataiku, so that my dataset used in flow can refresh itself schedueled automatically. While I need to download and upload the bigquery table by myself everytime now, which is quite unconvenient.

Should I do some setting in GCP Bigquery either before I configure the connections in Dataiku?And I'm confused with what should I entry to the blank.I entried information following but it turns out error when I click "test" button.

Project ID : I entry the project ID of the project which I attempt to connect in bigquery

Client ID: My GCP account

Client secret: My GCP account's password

Scope: the default scope

others:blank

Error messege:User 'xxxxxxxxxxxx' does not have credentials for connection 'xxxxxxxxxxxxxx'.

I guess that I should obtain OAuth 2.0 credentials from the Google API Console firstly, am I right?

And any other settings should I configure out ?

Thanks a lot,

Rakuwa

Operating system used: Dataiku Cloud