We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

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

Suskil
Alteryx
Alteryx
Created

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

      Comments
      ysy95858
      5 - Atom

      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
      5 - Atom

      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?