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

Unlock the full course today

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

Example data set 2: CPU utilization and application type

Example data set 2: CPU utilization and application type - SQL Tutorial

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

Start my 1-month free trial

Example data set 2: CPU utilization and application type

“

- Let's work with a different set of time series data. In this case, we'll work with some very simplified version of application performance monitoring data. I'm going to navigate to the open file and I'm going to navigate to chapter four, and I'm going to locate the file called 4.6 Load_Utilization_Data.sql, and I'll just select that. And you'll notice there is a copy command, so this is like the other copy command. I'm going to copy data into a table called utilization, which is in the time series schema, and I'm going to copy it from a file called utilization.txt. You want to change the path in the from clause to wherever you stored your exercise files. So, execute the query. And let's just take a quick look and see what the data looks like. So we'll select, let's select star, from the utilization table, and that's, of course, in the time series schema. And let's limit it to 100 rows. Now, what you'll notice is that we have several columns, we have an event time, similar to the…

Contents