09-29-2022 05:24 PM - edited 09-29-2022 05:32 PM
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
Defect GDC-3086
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'
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?
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.