Data Analyst Learning Path: 02.Introduction to Data Analytics on Google Cloud course

[hyhy8]

I have a problem finding the source:spls/gsp072/baby-names/yob2014.txt on task 4: Load data into a new table on the part: big query: Qwik Start - Console. 

It seems very sample. Does anyone take this course or give any advice on how to pass it?

[jangemmar]

Hi @hyhy8,

Welcome to Google Cloud Community!

I understand the challenges you’re facing with BigQuery: Qwik Start - Console Google Cloud Skills Boost course. Simply follow the steps below to ingest the source: spls/gsp072/baby-names/yob2014.txt to your babynames dataset.

In your Create table panel:

1. Choose Google Cloud Storage in the “Create table from” field
2. Copy and paste the source URI “spls/gsp072/baby-names/yob2014.txt” like shown in the image below and set file format to CSV
3. Set the correct table name “names_2014” as required in the skillsboost course.
   
   
   
   
4.  On the Schema, enable the Edit sa text and copy and paste the required schema “name:string,gender:string,count:integer” as shown in the image below.
   
   
   
5. Click the “Create Table” button. You should be able to see the “names_2014” table in your BigQuery explorer
   
   
6. For the last step of the course, Copy and paste the following command in the SQL query then click RUN
   
   

   #standardSQL
   SELECT
    name, count
   FROM
    `babynames.names_2014`
   WHERE
    gender = 'M'
   ORDER BY count DESC LIMIT 5;

Note: Check your progress at the bottom of each action item to validate if you've performed all the necessary actions correctly. Goodluck!

I hope the above information is helpful.

[hyhy8]

@jangemmar 

Thank you for your reply.

The problem is that there is no file under spls/gsp072/baby-names/yob2014.txt. but I got the solution from the support team.  They provide me a walk around solution and works for me.  Here is.

-----------------

We kindly request you to follow the workaround steps provided below for the lab:
 
 
bq query --use_legacy_sql=false \
'

standardSQL

SELECT
weight_pounds, state, year, gestation_weeks
FROM
bigquery-public-data.samples.natality
ORDER BY weight_pounds DESC LIMIT 10;
'
 
bq mk babynames
 
https://labshell-service-mvrcyiow4a-uc.a.run.app
 
gsutil cp gs://spls/gsp072/baby-names.zip .
 
unzip baby-names.zip
 
bq load --autodetect --source_format=CSV babynames.names_2014 gs://spls/gsp072/baby-names/yob2014.txt name:string,gender:string,count:integer
 
 
bq query --use_legacy_sql=false \
'

standardSQL

SELECT
name, count
FROM babynames.names_2014
WHERE
gender = "M"
ORDER BY count DESC LIMIT 5;

------------------

Thank you