From the course: Data Analytics with Observable

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Manipulating data (SQL with DuckDB)

Manipulating data (SQL with DuckDB) - Observable Tutorial

From the course: Data Analytics with Observable

Start my 1-month free trial Buy for my team

Manipulating data (SQL with DuckDB)

“

- [Instructor] All right, now it's time to manipulate data using SQL. And we'll start off with our same dataset like before, and we'll do what we did earlier, where we're just going to take that dataset, use the suggestion to convert to SQL, and we'll run that. And we get a duplicate. So we have this original table here and we have the duplicate down here, which, of course, is actually based on a SQL query. Now look at the SQL query. It used to look like this, right? Select star from happiness data. Because the last time when we converted to SQL, we were converting this table up here before we had unchecked these columns. So it did, it just pulled every column. But now that we've unchecked these, when we convert to SQL, observable knows, oh, you probably only want to pull those columns that you actually still have checked off. So it actually adds those manually to the SQL query. So it's a regular SQL query. I can add a…

Contents