From the course: Build a No-Code ETL Pipeline with Google BigQuery
Unlock this course with a free trial
Join today to access over 24,500 courses taught by industry experts.
Introduction to data - BigQuery Tutorial
From the course: Build a No-Code ETL Pipeline with Google BigQuery
Introduction to data
- [Instructor] Let us now download our data and examine it. So, our data is hosted in Kaggle, which is a website where people can share interesting datasets. And I'm on the main page for our dataset here in Kaggle. And you can see that I have my World Stock Prices dataset. Note that in order to download this data, you will need to sign up for Kaggle and then log in, but this is free. So, if I scroll down here, I can see a description for my data. I can see a description of the features, which is another way to say the columns of the dataset, and I can even see some more detail about each column. Now, if you look here on the right, you can see this version number, and if I click on it, I can see that this dataset has different versions. And how this works is that each day a new version of the dataset is published, and every daily version of my dataset contains the whole data. But compared to the previous version, there will be some fresh rows which will show the data from that day. So…
Contents
-
-
-
-
(Locked)
How data load will work1m 40s
-
(Locked)
Introduction to data4m 44s
-
(Locked)
What is Google Cloud Storage?2m 42s
-
(Locked)
Put data in Google Cloud Storage3m 35s
-
(Locked)
Create table in BigQuery4m 35s
-
(Locked)
Introduction to BigQuery Data Transfer Service1m 43s
-
How we will manage data6m 4s
-
(Locked)
Use Transfer Service to ingest data6m 40s
-
(Locked)
Schedule transfers with Transfer Service3m 19s
-
(Locked)
Identify data transfer issues6m 18s
-
(Locked)
Common issues with data transfer5m 21s
-
(Locked)
-
-
-