Skip to content
This repository has been archived by the owner on May 17, 2024. It is now read-only.

data-diff --dbt BigQuery exception while executing information_schema sql #892

Closed
hamish-turnbull opened this issue May 3, 2024 · 1 comment
Labels
bug Something isn't working triage

Comments

@hamish-turnbull
Copy link

hamish-turnbull commented May 3, 2024

Describe the bug
When performing a diff between two BigQuery tables, an exception is occurring when executing the following sql:

DEBUG    Database 'BigQuery(default_schema='dev_schema', _interactive=False, is_closed=False, _dialect=Dialect(_prevent_overflow_when_concat=False), project='dev_db', dataset='dev_schema', _client=<google.cloud.bigquery.client.Client object at              _connect.py:300
                  0x10f2e09d0>)' does not allow setting timezone. We recommend making sure it's set to 'UTC'.  
Exception when trying to execute SQL code:                                                                                                                                                                                                                dbt.py:292
                      SELECT column_name, data_type, 6 as datetime_precision, 38 as numeric_precision, 9 as numeric_scale FROM `dev_db`.`prod_schema`.INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'shadowrun' AND table_schema = 'prod_schema'  
The resulting error of this is 
```Got error: 'NoneType' object has no attribute 'token_state'
dev_db.prod_schema.shadowrun <> dev_db.dev_schema.shadowrun
New model or no access to prod table.

When I execute this sql myself in BigQuery I get the results I would expect to see based off the query. For some reason the query results is not getting assigned to python object.

Command to generate this:
dbt run --select shadowrun --target dev && data-diff --dbt --debug

data-diff --version
v0.11.1

dbt --version
core == 1.6.12 bigquery == 1.6.10

@hamish-turnbull hamish-turnbull added the bug Something isn't working label May 3, 2024
@github-actions github-actions bot added the triage label May 3, 2024
@glebmezh
Copy link
Contributor

Hi @hamish-turnbull,

Thank you for trying out data-diff and for taking the time to open this issue. We made a hard decision to sunset the data-diff package and won't provide further development or support. Diffing functionality will continue to be available in Datafold Cloud. Feel free to take it for a trial or contact us at support@datafold.com if you have any questions.

-Gleb

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
bug Something isn't working triage
Projects
None yet
Development

No branches or pull requests

2 participants