From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Setting up BigQuery - Google Cloud Tutorial
From the course: Data Science on Google Cloud Platform: Exploratory Data Analytics
Setting up BigQuery
- [Instructor] Let us go ahead and set up BigQuery with some data before we start using it in Datalab. The exercise files folder contains a website_visit_data.csv file. We will first load that into BigQuery. Let's go to the BigQuery console in GCP. Here create a new dataset called EDA under the current project. Now the dataset EDA is created. Let us load the website_visit_data.csv file into a new table called Website Visits. We click on Create Table and create table from an uploaded file. We can now select the file website_visit_data, open, file format is CSV. Destination project is My First Project, it is set as EDA and the table type is native. The destination table name is website_visits. We will select auto detect schema and input parameters and then we click on Create Table. The job is now running to create the table. And the table is now created. You can click on the table to see the contents and the data. Next, we will similarly load the campaign_data.csv file into a table…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.