Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

BigQuery with a Google service account

Hi!

I've established connections to BigQuery with normal Google accounts and it works correctly

Now, I need to connect to BigQuery with a Google service account, is that possible?

 

Thank you

Labels (2)
1 Solution

Accepted Solutions
Support (Former)
Support (Former)

Re: BigQuery with a Google service account

Hi Oscar,

Service account is not yet supported for Qlik Google BigQuery connector. Qlik is working on implementing this feature.

Meanwhile, you can use Simba ODBC driver for Google BigQuery, which supports Google service account.  More info in this article: https://support.qlik.com/articles/000057648

Hope this helps!

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.

View solution in original post

8 Replies
Support (Former)
Support (Former)

Re: BigQuery with a Google service account

Hi Oscar,

Service account is not yet supported for Qlik Google BigQuery connector. Qlik is working on implementing this feature.

Meanwhile, you can use Simba ODBC driver for Google BigQuery, which supports Google service account.  More info in this article: https://support.qlik.com/articles/000057648

Hope this helps!

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.

View solution in original post

Partner
Partner

Re: BigQuery with a Google service account

 

rkpatelqlikview
Contributor III

Re: BigQuery with a Google service account

Dear Team,

Error when am connecting the Google BigQuery.  The below error came after entering the "Confirmation code".

Error_GoogleBigquery.PNG

Does anyone know what could be the source of this issue?

Regards,

Kumar

 

 

Support (Former)
Support (Former)

Re: BigQuery with a Google service account

Hi Kumar, check this article https://support.qlik.com/articles/000047304
Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.
rkpatelqlikview
Contributor III

Re: BigQuery with a Google service account

Hi Nguyen, Thanks for your help. After i installed certificate ,getting another error. How can i overcome this issue? Please suggest

errorbigquery.PNG

 

Thanks in advance.

Highlighted
Support (Former)
Support (Former)

Re: BigQuery with a Google service account

As the error message suggests, configuration parameters Catalog and RefreshToken are missing in your connection.
After pasting the confirmation code, you need to click "Validate". This will convert the code to a token for further communication with Google BigQuery.
You will also need to select a Catalog (Project) in the dropdown below "Confirmation Code" before testing / creating the connection
Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.
rkpatelqlikview
Contributor III

Re: BigQuery with a Google service account

I need to check Nguyen, Same error throwing. Thanks for your quick respond. Great help. 

Partner
Partner

Re: BigQuery with a Google service account

Hej Vu,

Is there any update on this development? 

I have not been able to find any info on this matter.

Is SIMBA ODBC still the recomended solution ?

 

Best Regards

Eva