A derived table in Looker is a query whose results are used as simple database tables.
Let's imagine we have a database table called orders, which includes a lot of columns. We can create a derived table called customer order summary that contains a subset of the columns from the orders table.