GDC-3086: Google Big Query Error AttributeError: 'NoneType' object has no attribute 'message_types_by_name'

[Suskil]

Error: AttributeError: 'NoneType' object has no attribute 'message_types_by_name'

 

The following error occurs when connecting to Google Big Query with Service-to-Service authentication:

 

Error: Google BigQuery Input (1): Traceback (most recent call last):
  File "main.py", line 4, in <module>
  File "C:\ProgramData\Alteryx\Tools\big_query_input_v3.0.0\big_query_input\__init__.py", line 1, in <module>
    from .engine import BigQueryInputEngine
  File "C:\ProgramData\Alteryx\Tools\big_query_input_v3.0.0\big_query_input\engine.py", line 5, in <module>
    from connectors_core.bigquery import BigQuerySchemaReader, SchemaConversionException
  File "C:\ProgramData\Alteryx\Tools\big_query_input_v3.0.0\connectors_core\bigquery\__init__.py", line 1, in <module>
    from .schemas import SchemaConversionException
  File "C:\ProgramData\Alteryx\Tools\big_query_input_v3.0.0\connectors_core\bigquery\schemas.py", line 6, in <module>
    import google.cloud.bigquery
  File "C:\ProgramData\Alteryx\Tools\big_query_input_v3.0.0\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_v3.0.0\Lib\site-packages\google\cloud\bigquery\client.py", line 43, in <module>
    import google.api_core.exceptions
  File "C:\ProgramData\Alteryx\Tools\big_query_input_v3.0.0\Lib\site-packages\google\api_core\exceptions.py", line 29, in <module>
    from google.rpc import error_details_pb2
  File "C:\ProgramData\Alteryx\Tools\big_query_input_v3.0.0\Lib\site-packages\google\rpc\error_details_pb2.py", line 39, in <module>
    _RETRYINFO = DESCRIPTOR.message_types_by_name["RetryInfo"]
AttributeError: 'NoneType' object has no attribute 'message_types_by_name'

1. Install Google BigQuery Tools
2. Drag BigQuery Input Tool to canvas
3. Select authentication mode as Service-to-Service > click Select a File to choose JSON file
3. Click Select Table to choose a table
4. Click on canvas or running the workflow will result in the above error

 

Environment Details

• Alteryx Designer, Server
  • 2021.2, 2021.4, 2021.4, 2022.1
• Google Big Query
• Google Big Query Input and Output tools v3.0

Cause

 

Defect GDC-3086

 

 

 

Resolution

Defect GDC-3086 is targeted for resolution in a future release
 

Workaround A

Install Google BigQuery ODBC Driver available from the Alteryx Downloads page (create a support case via the Case Portal, to assist with setup, if required)
 

Workaround B

Submit a support case via the Case Portal to request valid Google BigQuery tool folders and instructions. Please reference Defect ID:GDC-3086
 

Additional Resources

• How To Use Case Portal
• Product Downloads (Select Drivers)

[ysy95858]

he following error occurs when connecting to Google Big Query with Service-to-Service authentication:

Error: Google BigQuery入力 (1): Traceback (most recent call last):
File "main.py", line 4, in <module>
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\big_query_input\__init__.py", line 1, in <module>
from .engine import BigQueryInputEngine
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\big_query_input\engine.py", line 5, in <module>
from connectors_core.bigquery import BigQuerySchemaReader, SchemaConversionException
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\connectors_core\bigquery\__init__.py", line 1, in <module>
from .schemas import SchemaConversionException
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\connectors_core\bigquery\schemas.py", line 6, in <module>
import google.cloud.bigquery
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\Lib\site-packages\google\cloud\bigquery\__init__.py", line 35, in <module>
from google.cloud.bigquery.client import Client
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\Lib\site-packages\google\cloud\bigquery\client.py", line 43, in <module>
import google.api_core.exceptions
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\Lib\site-packages\google\api_core\exceptions.py", line 29, in <module>
from google.rpc import error_details_pb2
File "C:\Users\usei\AppData\Roaming\Alteryx\Tools\big_query_input_v3.0.0\Lib\site-packages\google\rpc\error_details_pb2.py", line 39, in <module>
_RETRYINFO = DESCRIPTOR.message_types_by_name["RetryInfo"]
AttributeError: 'NoneType' object has no attribute 'message_types_by_name'

[sultania_p]

Similar issue persists for me. Although ODBC driver (Simba) works as an alternative, but wanted to check if there will be any performance difference in data transfer using connector vs odbc connection?

[savio_henriques]

This error also still occurs with version 2022.3. I had a version of the tool folders for bigquery which do not manifest the error and was able to replace the installed folders and the error goes away.