Asking questions, running queries

Running queries is one of the most fundamental ways to gain valuable insights from your data. In this episode of BigQuery Spotlight, we’ll show you how to write and run SQL queries in the BigQuery UI.. Watch as we use public data to determine which NCAA jersey number has the best basketball stats from the three-point line. You can even follow along in your own BigQuery sandbox for free!

Product: BigQuery, BigQuery sandbox; fullname: Nick Orlove;

#BigQuerySpotlight

[warblade]

The video is a bit oudated as the GCP has changed its UI for BigQuery (and also many other services).

As of Jan 8, 2023, I can see the data after adding the data through the 'Analytics Hub' tab (you also have to enable the API).

[kford]

I am unable to find the tables for the dataset in the example in this video. That option is not available on my screen.

When I open the dataset, all I see is the Dataset Info. My options are to "Create Table", "Sharing", or "Copy". Did I click on the wrong thing?

[jakubosobka]

Is COUNTIF funcfion a unique feature of BigQuery? I have not seen such a function in other dialects of SQL.

[UmarAbdull-lqls]

Wow I love it
Big query data its meaningful..which is am very interested on it..an its very great.

[pbiscayart]

#45 has a high percentage because it does not shoot that much. Don't jump to conclusions quickly as more analysis should be done. 🙂 I understand that the goal of the video is to show how to use BigQuery to run queries, and the goal is achieved.

[TheMitali_]

Can you help us understand working with array of struct for large data.

[UmarAbdull-lqls]

But my question as follows in data query its possible to make money very easy..?
2. The second question is that in data query in what way can make early to make money online without big steps to or ways to follows..?
3. I need steps by step setting to do that.
Thank you.

[marceltawamba]

this video is outdated. the bigquery-public-data is nowhere to be found. I've tried everything. can't open the NCAA dataset but can see it. please help.

[Dannydrinkbottom]

in the new update for bigqueary, I can't see the data tables, where do i find them?

[Piliponful]

every tutorial series from big corporation looks like HR watching every move and every syllable of a teacher, cool..

[akshaybhandare]

i was trying to add the public datasets for a while now but as soon as i click on view dataset it again takes me to the public datasets homepage

[yuanzhou]

How do I even add a public dataset to BigQuery project?

[endritpasho]

is it possible to execute multiple queries within same editor? any tables with partitions and encrypted data?

[MemoUnscripted]

Could you guys please update this video series? It's not as simple as showed in the video no more...

Anyone that knows a step by step process to get data and actually see it to be able to analize it?

[shyamUthaman]

This is just Standard SQL 101.. I am trying to understand how why a business should choose this data warehouse over SAP HANA, or SAP BW or Oracle DW

[bratbalal]

You don't need group by for count

[ShortDigitalMarketingTutorials]

I don't see this data set in there.

[TheCsePower]

im getting Access Denied: Project bigquery-public-data: User does not have bigquery.jobs.create permission in project bigquery-public-data.