Comments (2)
Just to get the obvious question out the way, does xxx.ml_models.mdl_revenue_forecast
definitely exist? Does select * from xxx.ml_models.mdl_revenue_forecast
return data?
I haven't used BigQuery ML at all - do these models create a table like a typical SQL model? If not I'll have to do some digging to see how they behave. Do you have any other ML models that are giving this error?
from upstream-prod.
Yes! It is somewhat like a 'table', it appears in the search panel like an object, and you can do something like a select * from, but a little different. Here is an example from Bigquery ML docs:
SELECT
*
FROM
ML.PREDICT(MODEL `mydataset.mymodel`,
(
SELECT
label,
column1,
column2
FROM
`mydataset.mytable`))
from upstream-prod.
Related Issues (17)
- The modified "ref" macro breaks when using "dbt run-operation" HOT 2
- macro 'dbt_macro__ref' takes no keyword argument 'v' HOT 4
- Ephemeral models are not supported HOT 3
- 'dict object' has no attribute 'file_key_name' in macro ref (macros/ref.sql) HOT 4
- CLI sending a large number of `True` and `False` messages to console when running `upstream-prod` on `dbt-bigquery` HOT 2
- Typo error in : raise_ref_not_found_error HOT 1
- Error When Using ref.sql Macro HOT 1
- --no-partial-parse flag fails with this library enabled on branch HOT 4
- Package not working with metrics HOT 2
- Env schemas don't seem to work with snapshots that use the `target_schema` config. HOT 1
- Dict object has no attribute `file_key_name` on Singular tests HOT 1
- Error with `prefer_recent` variable in ref.sql HOT 2
- `check_reqd_vars` Contradictory Error Message HOT 2
- `ref()` returns `None` when prod table doesn't exist even if `upstream_prod_fallack: True` HOT 1
- Recreate all changed models in development environment HOT 6
- redshift adapter.get_relation always returns null? HOT 9
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 upstream-prod.