Collibra Certified Driver For Google BigQuery

Hello,
i am trying to create some data sources in the DGC catalog for a Google BigQuery database. I have downloaded the Certified driver on the marketplace (it is a CData driver)
I have created the specific form for the mandatory driver connection properties :
DatasetId
ProjectId
Schema (same as ProjectId)
InitiateOAuth : GETANDREFRESH
OAuthJWTCert : P12 service account file
OAuthJWTCertPassword (for the p12 encrypted file)
OAuthJWTCertType : PFXFILE
OAuthJWTIssuer : email address
OAuthJWTSubject : “*”
Other : SupportNativeDataType=True
UseStorageApi : true
ProxyAutoDetect : FALSE
ProxyServer : IP address of the Proxy
ProxyPort
ProxyAuthScheme : BASIC
ProxyUser :
ProxyPassword :
ProxySSLType : NEVER

I am on a linux server ‘on-premises’ that get access to Google Cloud Platform through a Squid reverse-proxy with authentication (HTTP, no SSL).

When I create my data-source with all the property values, i always get an error :

job.catalog.JdbcConnectionTestJob - error during JDBC database connection
java.sql.SQLException: Proxy error: HTTP protocol error. 407 Proxy Authentication Required.
at XcoreXgooglebigqueryX210X7891.kvc.a(Unknown Source)

I have checked my proxy authentication properties values (user and password) many times : the values are good.

When the other proxy proterties values are wrong, i get a connection time-out

Many thanks for advices for this issue.
Regards

francoisabraham

Posted 4 years ago · Edited 1 year ago·Last reply 3 years ago

3 comments

francoisabraham

OP4 years ago · Edited

Hi, thanks for your answer : i have solved my issue with ProxySSLType=AUTO rather than NEVER (we do not user HTTPS/SSL to connect to the Proxy).
The error message raised by Google BigQuery Driver is not correct : it is not an authentication issue but a connection issue.
Rergards

Alexandra Jorgenson

Admin3 years ago · Edited

Thank you for sharing your solution here @francois.abraham.ext.orange.com (and @noor.shaik, as always, for trying to help!).

noor

·4 years ago · Edited

I quickly checked what is the significance of “407 Authentication Required” as I felt the authentication is yet to take place, and you may be missing some required details in the form.

But, it seems the error message indicates authentication details are invalid. Since you are very confident that the user name/password details are correct, best thing is to raise a support ticket with Collibra first.