From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Create a table from CSV

Create a table from CSV

From the course: Data Science on Google Cloud Platform: Designing Data Warehouses

Start my 1-month free trial

Create a table from CSV

“

- Let's see how we we can create a table directly from csv, and let the BigQuery to autodetect the schema. For this we will use a csv file called test_results, that is available in our exercise files. Here we see the contents of the test_results file. It contains tests that have been run on patients, including test date, patient diary, the blood pressure levels that were found, the cholesterol levels, blood sugar, and heart rate. This is the file we will load now. So go to the dataset once again, select Create New Table, and you'll select Create From Source. The location would be file upload, and you can then choose a file, test_results. Now note that in the location, we can also provide other locations like Cloud Storage, Google Drive and Cloud Bigtable. Set the schema to automatically detect, and provide the table name as test_results. Then you go ahead and click Create Table, the job status shows that it has been loaded, the table newly created shows up on the left pane, clicking…

Contents