Technical requirements

You will need a running instance of Metabase with a connection to the pies database. As we'll be writing a lot of SQL in this chapter, it's helpful to have some knowledge of the language. If you don't know SQL, you'll still be able to copy, paste, and run all the queries, but you will get more out of the chapter if you also understand what they do.

Important Note

NoSQL databases, as their name suggests, cannot be queried with SQL. They can still be queried with their own query languages, and these can be run inside Metabase, but they tend to look very different from SQL. In this chapter, we will only cover SQL, as most Metabase users tend to use relational databases.