Thank you! Very helpful!

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

Thank you for the information.

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

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).

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?

@maxpj

2 жыл бұрын

I am in the same boat as you, I am wondering if BigQuery updated since this video but they haven't updated their tutorials....

@KostiantynKostin

Жыл бұрын

Click ADD DATA -> Pin a project -> Enter project name -> enter bigquery-public-data

Thanks. Time 7:36 pm Nigerian Time.

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

@googlecloudtech

2 жыл бұрын

You can execute multiple statements separated by semicolons. Here's an example: github.com/GoogleCloudPlatform/training-data-analyst/blob/master/blogs/bqblog/2019-10/multiple_statements.md

@googlecloudtech

2 жыл бұрын

For the second question, do you mean customer-managed encryption keys? If so, yes, you can use partitioning with CMEK. More on CMEK here: cloud.google.com/bigquery/docs/customer-managed-encryption

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

@aliciawilliams5520

3 жыл бұрын

Instead of clicking "Explore public datasets", try clicking "Pin a project" and typing in bigquery-public-data. This should add all the public datasets to your resources tree. The "Explore public datasets" button is still the best place to find more information on each public dataset including example queries. Just a workaround in case it's not launching!

@Younessss_

2 жыл бұрын

look for "public" on the tab to the left, once you find no results, click "extend search", first result should be Google's public datasets. pin it, then you should have it in on the explorer tab (to the left). once this is done, just select the google public project you just pinned and you should be able to add the public datasets now. if you still can't then try looking for the public dataset you want on the explorer tab above your projects.

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

@aliciawilliams5520

3 жыл бұрын

Click "Pin a project" in the left hand nav of the BQ console and then type 'bigquery-public-data'. Let me know if this doesn't get you there for any reason!

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.

@djarcadian

Жыл бұрын

I'm having the same issue. Did you figure this out?

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

@aliciawilliams5520

2 жыл бұрын

Projects with their datasets (and their tables) can be found in the Explorer section of the Console: cloud.google.com/bigquery/docs/bigquery-web-ui#overview. If you don't see the project where your dataset lives, you can add/pin it: cloud.google.com/bigquery/docs/bigquery-web-ui#pinning_adding_a_project

@TheCsePower

2 жыл бұрын

Same problem here!

@keliu2313

2 жыл бұрын

@@aliciawilliams5520 Thanks for your help. However, after we pinned the project and tried add DATA as instructed by this video, I still don't see any data/table listed under the project.

@aliciawilliams5520

2 жыл бұрын

@@keliu2313 The dataset is hosted in the 'bigquery-public-data' project (owned by Google Cloud), which you can pin by clicking '+Add Data' in the BigQuery Console, and then providing 'bigquery-public-data' as the project name, then click 'Pin'. Official instructions for pinning a project here: cloud.google.com/bigquery/docs/bigquery-web-ui#option_2_select_from_a_list_of_projects. Once 'bigquery-public-data' is pinned, click to the left on the expand node icon (little triangle) which will show all the datasets, including 'ncaa_basketball'. If you click on the expand node icon next to the dataset, then you will see all the tables in the dataset listed.

@kernadan000

Жыл бұрын

@@aliciawilliams5520 thank you

#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.

I don't see this data set in there.

@aliciawilliams5520

29 күн бұрын

The queries are linked from the video description if you'd like to open them directly in BigQuery Studio. Thanks!

You don't need group by for count

@TheCsePower

2 жыл бұрын

you need it for ORDER

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?

@AllYay

Жыл бұрын

That's how I got here. I can get the dataset, but after that, I really don't know what's next.

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

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

@aliciawilliams5520

2 жыл бұрын

How are you running the query (console, command line, API)? Make sure you are running it from a project that you have permission to run queries in (and not in the bigquery-public-data project).