Alteryx Designer GCP Big Query Connection Issue

[MohammadMoin]

Hi,

We having Alteryx Input Data connection issue to GCP Big Query. Using "Google BigQuery" connector I am able to connect to GCP and can see all databases and Tables but once select individual table, in canvas it showing this error below.

'Error: Google BigQuery Input (1): Generic error received: HTTPSConnectionPool(host='bigquery.googleapis.com', port=443): Max retries exceeded with url: /bigquery/v2/projects/xxx/datasets/dm_lus/tables/dim_Age?prettyPrint=false (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1123)')))"

Just wondering if anyone has a solution for this?

Thanks in advance.

[VojtechT]

Hi @MohammadMoin , it's a generic SSL validation error most probably due to a proxy server in your environment. 

Please see this article which describes how to mitigate the issue. 

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Connection-Errors-with-Python-based...