From the course: Advanced SQL for Data Science: Time Series

Unlock the full course today

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

Example data set 1: Temperature by time and location

Example data set 1: Temperature by time and location - SQL Tutorial

From the course: Advanced SQL for Data Science: Time Series

Start my 1-month free trial

Example data set 1: Temperature by time and location

- [Instructor] Now it's time to load some data. Once again I'm in the Time Series Schema and I'm going to just click on tables. I'm going to open a new query window. Now I have a script which loads data into the location temp table, so I'm going to open that, open that script. Now you'll notice I've already navigated to my directory and where I have the exercise files. So I've opened the exercise files and I'm just going to pop up and just point out that I'm in chapter four. And under chapter four there are several files. I'm going to select the file that starts with the name 4.1, and that's the load Time Series data script. So I will select that, and you'll notice when I open the file, it inserts a copy command. Now what it's doing, is it's copying to the time series dot location temp table and it's copying from a file in my home directory, sub-directory data called location temp dot txt. So important for you to know, is that you'll have to change that file name to whatever path is…

Contents