We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Google BigQuery Input Connector Error

Pong
5 - Atom

What does this error mean?  I'm trying to connect to data sources in a project in GCP.

 

Error: Google BigQuery Input (1): Traceback (most recent call last):  File "main.py", line 4, in <module>  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\big_query_input\__init__.py", line 1, in <module>    from .engine import BigQueryInputEngine  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\big_query_input\engine.py", line 7, in <module>    from connectors_core.bigquery.base import AbstractBigQueryPlugin  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\connectors_core\bigquery\base.py", line 9, in <module>    from connectors_core.bigquery.helpers import ayx_update_proxy_environ, ayx_restore_proxy_environ  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\connectors_core\bigquery\helpers.py", line 5, in <module>    import pypac.parser  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\Lib\site-packages\pypac\__init__.py", line 20, in <module>    from pypac.api import get_pac, collect_pac_urls, download_pac, PACSession, pac_context_for_url  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\Lib\site-packages\pypac\api.py", line 10, in <module>    from pypac.parser import PACFile  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\Lib\site-packages\pypac\parser.py", line 6, in <module>    import dukpy  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\Lib\site-packages\dukpy\__init__.py", line 1, in <module>    from .evaljs import evaljs, JSInterpreter  File "C:\Users\user\AppData\Roaming\Alteryx\Engine\../Tools\big_query_input_v3.0.0\Lib\site-packages\dukpy\evaljs.py", line 7, in <module>    from . import _dukpyImportError: cannot import name '_dukpy'

3 REPLIES 3
apathetichell
20 - Arcturus

Seems to be an issue with the python back end to the BQ input tool. What version Alteryx are you running?  Did you have any issues when you installed the .yxi package? Also - are you running as administrator or regular?

Pong
5 - Atom

I'm running 2019.4.8.22007.  I didn't have any install issues.  I'm probably running regular as I see that I'm "Running Non-Elevated", though I'm not sure if that answers your last question.

apathetichell
20 - Arcturus

my hypothesis is that you need to upgrade to a version of Alteryx after 2020.4 to use the Google Big Query tool. Python version conflict.

 

Try an earlier version of the Big Query tool like:

https://alteryxdownload.s3.amazonaws.com/Tools/big_query_v2.0.1.yxi

 

 

Labels
Top Solution Authors