Expected Format for BigQuery JSON Credentials

Nicolas Boussenina

·

Hello when setting my BQ json creds, it displays invalid creds and in the console ⬇️ What is the expected format

13 comments

· Sorted by Oldest

David Ebbo
·
·
Hi Nicolas. The expected format is the full json that you download from the Google Cloud service account page. However, when I try this, even though I don't get an error, the Save button never becomes enabled. Sébastien Flory what do you make of it? Maybe the Save button's disabled check is missing a needToSelectLocation condition check?
Sébastien Flory
·
·
Looking at the code, if you have only one selection, the button is disabled if:
Loading attachments
Sébastien Flory
·
·
and if you have only one:
Loading attachments
Sébastien Flory
·
·
David Ebbo there is a call to return the tables and locations, do you see an error in the network tools ?
David Ebbo
·
·
I don't even get the UI to select locations (see screenshot). The check_bigquery_locations call is returning {"locations":{}}
Loading attachments
Sébastien Flory
·
·
pasting the json should trigger a network call to get the table & locations
David Ebbo
·
·
I should add that my test is artificial, as I don't actually have tables.
Sébastien Flory
·
·
David Ebbo that will not trigger the ui then, you need at least one table
David Ebbo
·
·
Ok, so maybe this is different from Nicolas Boussenina’s problem, who gets a 1E08010C:DECODER error when pasting his json.
Sébastien Flory
·
·
the json is probably weird
Sébastien Flory
·
·
Nicolas Boussenina feel free to send me the json in DM
David Ebbo
·
·
I confirm that after creating a table, I'm able to save. So yes, it's probably a json issue in Nicolas Boussenina’s case.
Nicolas Boussenina
·
·
Thanks all of you I did not have any table!!
👍1

David Ebbo
·
·
Hi Nicolas. The expected format is the full json that you download from the Google Cloud service account page. However, when I try this, even though I don't get an error, the Save button never becomes enabled. Sébastien Flory what do you make of it? Maybe the Save button's disabled check is missing a needToSelectLocation condition check?
Sébastien Flory
·
·
Looking at the code, if you have only one selection, the button is disabled if:
Loading attachments
Sébastien Flory
·
·
and if you have only one:
Loading attachments
Sébastien Flory
·
·
David Ebbo there is a call to return the tables and locations, do you see an error in the network tools ?
David Ebbo
·
·
I don't even get the UI to select locations (see screenshot). The check_bigquery_locations call is returning {"locations":{}}
Loading attachments
Sébastien Flory
·
·
pasting the json should trigger a network call to get the table & locations
David Ebbo
·
·
I should add that my test is artificial, as I don't actually have tables.
Sébastien Flory
·
·
David Ebbo that will not trigger the ui then, you need at least one table
David Ebbo
·
·
Ok, so maybe this is different from Nicolas Boussenina’s problem, who gets a 1E08010C:DECODER error when pasting his json.
Sébastien Flory
·
·
the json is probably weird
Sébastien Flory
·
·
Nicolas Boussenina feel free to send me the json in DM
David Ebbo
·
·
I confirm that after creating a table, I'm able to save. So yes, it's probably a json issue in Nicolas Boussenina’s case.
Nicolas Boussenina
·
·
Thanks all of you I did not have any table!!
👍1