Although I was able to setup Google BigQuery successfully on my primary notebook my graduate students (this is being used in a course) could not use BigQuery connector after installing it. (errors below). I tried tried to replicate their problem on another notebook of mine and ran into the same problem. This later notebook did not have a previous version of Alteryx on it as I was trying to replicate the conditions my students had. I did try to use the big_query_v2.0.1_cryptography "fix" suggested in another note in the Community but that didn't work either. Error: Google BigQuery Input (2): Traceback (most recent call last): File "main.py", line 4, in File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\big_query_input\__init__.py", line 1, in from .engine import BigQueryInputEngine File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\big_query_input\engine.py", line 5, in from connectors_core.bigquery import BigQuerySchemaReader, SchemaConversionException, AuthorizedSession File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\connectors_core\bigquery\__init__.py", line 1, in from .schemas import SchemaConversionException File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\connectors_core\bigquery\schemas.py", line 4, in import google.cloud.bigquery File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\__init__.py", line 35, in from google.cloud.bigquery.client import Client File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\client.py", line 58, in from google.cloud.bigquery import _pandas_helpers File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\_pandas_helpers.py", line 40, in from google.cloud.bigquery import schema File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\schema.py", line 19, in from google.cloud.bigquery_v2 import types File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery_v2\__init__.py", line 23, in from google.cloud.bigquery_v2 import types File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery_v2\types.py", line 23, in from google.cloud.bigquery_v2.proto import encryption_config_pb2 File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery_v2\proto\encryption_config_pb2.py", line 18, in from google.api import field_behavior_pb2 as google_dot_api_dot_field__behavior__pb2 File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\api\field_behavior_pb2.py", line 39, in create_key=_descriptor._internal_create_key, AttributeError: module 'google.protobuf.descriptor' has no attribute '_internal_create_key'

protobuf has to be also upgraded for the imput tool... cd C:\Users\ \AppData\Roaming\Alteryx\Tools\big_query_input_v2.0.1 python.exe -m pip install --upgrade protobuf Now it is working.... Thanks @walter-yx

In my case, I am still having the same issue after following the @walter-yx solution. The same message "C:\Users\###\AppData\Roaming\Alteryx\Engine/../Tools\big_query_input_v2.0.1\Lib\site-packages\google\api\field_behavior_pb2.py", line 39, in create_key=_descriptor._internal_create_key, AttributeError: module 'google.protobuf.descriptor' has no attribute '_internal_create_key' When I open up a cmd window and type: cd C:\Users\ \AppData\Roaming\Alteryx\Tools\big_query_output_v2.0.1 python.exe -m pip list I got this: Package Version ------------------------- --------- adal 1.2.6 azure-common 1.1.14 azure-datalake-store 0.0.27 azure-mgmt-datalake-nspkg 2.0.0 azure-mgmt-datalake-store 0.5.0 azure-mgmt-nspkg 2.0.0 azure-mgmt-resource 2.0.0 azure-nspkg 2.0.0 cachetools 4.2.1 certifi 2020.12.5 cffi 1.14.5 chardet 4.0.0 cryptography 3.4.6 dukpy 0.2.3 fastavro 0.17.5 google-api-core 1.26.2 google-auth 1.28.0 google-cloud-bigquery 1.23.1 google-cloud-core 1.3.0 google-resumable-media 0.5.1 googleapis-common-protos 1.53.0 idna 2.10 isodate 0.6.0 msrest 0.6.21 msrestazure 0.6.4 oauthlib 2.0.6 onedrivesdk 1.1.8 packaging 20.9 pip 20.1.1 protobuf 3.15.7 pyasn1 0.4.8 pyasn1-modules 0.2.8 pycparser 2.20 PyJWT 2.0.1 pypac 0.12.0 pyparsing 2.4.7 python-dateutil 2.8.1 pytz 2021.1 requests 2.25.1 requests-oauthlib 1.3.0 rsa 4.7.2 setuptools 54.2.0 six 1.15.0 tld 0.12.5 urllib3 1.26.4 wheel 0.34.2 wincertstore 0.2 protobuf was already upgraded to 3.15.7 but it still doesn't work after restarting Alteryx

I had the same error and can confirm that @walter-yx solution works. In my case I had to do the steps twice though since I needed "big_query_input_v2.0.1" to work as well.

Error While Installing Big query input tool v2.0.1 on Alteryx V2021.3 (and 2021.1.2)

ProfSherman

Although I was able to setup Google BigQuery successfully on my primary notebook my graduate students (this is being used in a course) could not use BigQuery connector after installing it. (errors below). I tried tried to replicate their problem on another notebook of mine and ran into the same problem. This later notebook did not have a previous version of Alteryx on it as I was trying to replicate the conditions my students had.

I did try to use the big_query_v2.0.1_cryptography "fix" suggested in another note in the Community but that didn't work either.

Error: Google BigQuery Input (2): Traceback (most recent call last):
File "main.py", line 4, in <module>
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\big_query_input\__init__.py", line 1, in <module>
from .engine import BigQueryInputEngine
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\big_query_input\engine.py", line 5, in <module>
from connectors_core.bigquery import BigQuerySchemaReader, SchemaConversionException, AuthorizedSession
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\connectors_core\bigquery\__init__.py", line 1, in <module>
from .schemas import SchemaConversionException
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\connectors_core\bigquery\schemas.py", line 4, in <module>
import google.cloud.bigquery
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\__init__.py", line 35, in <module>
from google.cloud.bigquery.client import Client
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\client.py", line 58, in <module>
from google.cloud.bigquery import _pandas_helpers
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\_pandas_helpers.py", line 40, in <module>
from google.cloud.bigquery import schema
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery\schema.py", line 19, in <module>
from google.cloud.bigquery_v2 import types
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery_v2\__init__.py", line 23, in <module>
from google.cloud.bigquery_v2 import types
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery_v2\types.py", line 23, in <module>
from google.cloud.bigquery_v2.proto import encryption_config_pb2
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\cloud\bigquery_v2\proto\encryption_config_pb2.py", line 18, in <module>
from google.api import field_behavior_pb2 as google_dot_api_dot_field__behavior__pb2
File "C:\ProgramData\Alteryx\Tools\big_query_input_v2.0.1\Lib\site-packages\google\api\field_behavior_pb2.py", line 39, in <module>
create_key=_descriptor._internal_create_key,
AttributeError: module 'google.protobuf.descriptor' has no attribute '_internal_create_key'

Error Message

Accepted answers

All comments

gangeles

I was able to move ahead in this error by installing protobuf python package in C drive by using pip install --upgrade protobuf .

Atfirst you need to set path variable for python in environment variable

But after doing this I am getting this error. Someone from Alteryx Team needs to assist on this.

Can someone from team help in this

bugalteryx.PNG

RUSA

We are experiencing the same error and we are no longer able to interact with BigQuery. The "pip install --upgrade protobuf" didn't address the issue.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703