Comments (1)
@rjh336 Thanks for opening the issue!
The reason these values are missing for SELECT
+ UPDATE
statements is because we don't have logic to handle those statement types within execute
:
dbt-bigquery/dbt/adapters/bigquery/connections.py
Lines 393 to 432 in 95ca84b
We totally could! From a little poking around, I think:
UPDATE
should be a simple addition to the conditional branch that includes['INSERT', 'DELETE', 'MERGE']
SELECT
needs its own new conditional branch, which might look something like:
elif query_job.statement_type == 'SELECT':
code = 'SELECT'
bytes_processed = query_job.total_bytes_processed
# these are internal properties, so we should be cautious
# maybe more trouble than it's worth?
if (
hasattr(query_job, '_query_results')
and hasattr(query_job._query_results, '_properties')
and hasattr(query_job._query_results._properties, 'get')
):
num_rows = query_job._query_results._properties.get('totalRows')
I'm going to mark this a good first issue
, and I'd welcome a PR to add those in :)
from dbt-bigquery.
Related Issues (20)
- [ADAP-1061] [Regression] Source freshness never sends query and never finishes/fail if loaded_at_field is not specified HOT 8
- [ADAP-1062] [Bug] Retries on wait for result step is recreating the whole job HOT 1
- [ADAP-1063] [Bug] BigQueryException: Error while reading data, error message: Schema mismatch HOT 8
- [ADAP-1067] [Regression] New default batch_id does not always conform to the required Dataproc batch ID pattern HOT 2
- [ADAP-1069] Custom batch_id prevents rebuilding the model on subsequent builds HOT 6
- [ADAP-1072] [Feature] Reduce data scanned of incremental `merge` strategy using partition filter in MERGE predicates HOT 3
- [ADAP-1073] [Bug] Not able preview structs when the struct is `null` HOT 1
- [ADAP-1075] [Bug] Python models are hard to change after a first run HOT 3
- the partition expiry is set to 7 days by default for temp table
- [ADAP-1082] [Feature] Migrate base adapter references to match dbt-core
- [ADAP-1090] [Feature] Adding Pyspark job options to the model config
- [Regression] `docs generate` raises error when querying external tables
- [Regression] Resolve broken proto build in CI HOT 2
- [Bug] jobs timing out early regardles of job_execution_timeout_seconds HOT 9
- [Feature] Support Python Stored procedure as a way to submit python models HOT 1
- [Feature] Submit bigframe syntax in python models HOT 1
- [Bug] For BigQuery, a multiline string needs to be escaped with 3 quotes instead of 1 like in `default__string_literal()`
- [Unit Testing] Support primative types + objects and arrays in dbt-bigquery
- [Feature] Change BigQuery `labels` to be additive instead of "clobber" HOT 5
- [Bug] Enforced contracts break recursive CTE rules HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbt-bigquery.