Hi, does anyone know why I get this error message;
# ask-questions
m
Hi, does anyone know why I get this error message;
w
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
@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
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 šŸ™‚ )