Comments (1)
I am trying to follow the tutorial here to create a python stored procedure, and found that I got stuck trying to to create a connection.
On page https://cloud.google.com/bigquery/docs/working-with-connections#bq_1, I am not sure how to create the connection I need to use in stored prodedure.
UPDATE:
- found https://cloud.google.com/bigquery/docs/connect-to-spark and created a connection, let's see if it works.
- successfully created the stored procedure, running it, been 4 mins and still executing
- job failed, realized connection do not have permission, found the service account associated with the connection, granted permission and rerunning
- still trying to figure out the right permission to get it working
- still
- It do not seems like I can find the generated service account and give it access to things
Based on this experience, I feel like it is even more opaque than dataproc serverless, where it took less time to setup.
from dbt-bigquery.
Related Issues (20)
- [Bug] materialized view failed to compile and re-run after upgrading to 1.7.4
- Pass (modify/append) BigQuery job label as a CLI flag
- [Bug] Missing container image for dbt-bigquery-1.7.5 HOT 5
- [Bug] List types don't save to BigQuery using 1.7 (but did in 1.5) HOT 1
- [Bug] _dbt_max_partition created in full-refresh runs if mentioned in the comments HOT 1
- [Bug] Cluster order for Materialized Views is mixed up HOT 1
- [Bug] Temporary table does not use partition expiry from incremental model configuration
- [Bug] Incremental model run `CREATE` statement though the table exists HOT 2
- [Bug] Add test for 9682 in core HOT 1
- [Bug] Add test for 9682 in core against 1.8
- [Bug] Add test for 9682 in core against 1.7 HOT 1
- [Bug] Incremental model with insert_overwrite strategy does not work with derived/calculated field in partition_by config block HOT 2
- [Bug] Custom Incremental Strategy does not work with BigQuery adapter HOT 1
- [Feature] Allow for Setting of IAM Tags HOT 3
- [Bug] Seeds get duplicated in bigquery when service account doesn't have enough permissions HOT 1
- [Feature] Log BigQuery console link at the info level (instead of debug level)
- [Feature] Support the updating of incremental model description after initial creation HOT 6
- [Bug]hard pin ddtrace version to 2.3
- [Feature] support `grant_access_to` for materialized views HOT 3
- [Bug] Remove `keyfile` from BigQueryCredentials._connection_keys
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.