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'

[jmussom]

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 <module>
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\<your-username>\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

[jmussom]

protobuf has to be also upgraded for the imput tool...

cd C:\Users\<your user>\AppData\Roaming\Alteryx\Tools\big_query_input_v2.0.1

python.exe -m pip install --upgrade protobuf

Now it is working....

Thanks @walter-yx