Hi, does anyone know why I get this error message;
w
white-fireman-22476
04/25/2023, 2:10 PM
Hi Kim. Your FROM clause needs three parts:
1. A project (e.g.
bigquery-public-data
)
2. A database (e.g.
hacker_news
)
3. A table (e.g.
stories
)
Like so
Copy code
`bigquery-public-data.hacker_news.stories`
š 1
b
billions-xylophone-11752
04/25/2023, 5:39 PM
@mammoth-church-11916 Was the FROM clause in your screenshot generated from the Schema Browser? (Via double clicking on the table name?) or did you type that out manually?
m
mammoth-church-11916
04/26/2023, 8:10 AM
In the example I took it from BigQuery (copied from same place as attached img. ) and it works when I double click the table name, however all my tables are split by day and then not sure how to do analysis across a time-period. Do I need to change the structure of my data in BQ first?
(Iām a total noob in BQ š )