Writing your first BigQuery query

Thank for posting all of these videos. I felt like I was diving in the deep end until I found these!

Yeah these are awesome. I think they may have removed the GA data set though.

I still can't find the dataset and i looked at your post. Attempted to pin the table since the query does show up but the table is still missing. Your link doesn't work btw, the one to the google analytics table.


SELECT channelGrouping
FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801`

LIMIT 1000

Hey David, got a quick question for you. I am trying to get some results using the same dataset by even the simplest query with a where condition is giving me syntax error when I know that the query is correct. for example i am running...
SELECT * FROM `bigquery-public-data.google_analytics_sample.ga_sessions_20170801` LIMIT 2
where date = "20170801"


and the error it gives is Syntax error: Unexpected keyword WHERE at [2:1]


how to fix this? thanks cheers!

What was totals. in the query? Those cloumns are not in this table I believe.

tks u