Asking questions, running queries

[@kford9271]

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]

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

[@war0blade159]

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

[@jakubosobka4414]

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

[@UmarAbdull-lq5ls]

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.

[@BrentCunningham-ug6ri]

Thank you for the information.

[@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.

[@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.

[@djarcadian]

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

[@UmarAbdull-lq5ls]

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

[@edithamaliri2588]

Thanks. Time 7:36 pm Nigerian Time.

[@Dannydrinkbottom]

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

[@aliciawilliams5520]

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]

Same problem here!

[@keliu2313]

@@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]

@@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

[@Italjamer]

Thank you! Very helpful!

[@TheMitali_]

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

[@endritpasho5578]

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

[@googlecloudtech]

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]

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

[@akshaybhandare5991]

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]

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_]

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.

[@yuanzhou4477]

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

[@aliciawilliams5520]

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!

[@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?

[@AllYay]

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

[@Piliponful]

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

[@bratbalal9042]

You don't need group by for count

[@TheCsePower]

you need it for ORDER

[@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

[@ShortDigitalMarketingTutorials]

I don't see this data set in there.

[@aliciawilliams5520]

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

[@TheCsePower]

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

[@aliciawilliams5520]

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