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'
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?
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.
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