Skip to main content

Table

In simplest terms, a table is the direct storage of data in rows and columns. Think excel sheet with raw values in each of the cells.

Here is an example of a table:

character_idfirst_namelast_nameemail
01FrodoBagginsfrodo@lotr.com
02BilboBagginsbilbo@theshire.co.uk
03GandalfThe Greygreywizard1@gmail.com

Tables do use storage in your data warehouse. The data can be queried directly because you are directly pulling from the raw data itself. If a particular table was created by underlying data, the table will not be automatically updated.

This table definition applies to most data warehouses, however, there are different flavors of tables for different warehouses. For example, Snowflake has transient and temporary tables that support different features.

Why are tables useful?

Tables are an excellent choice for persisting transformed data in your warehouse at the time of execution. However, if the underlying data used is changed, the table will not reflect the underlying changes. If that is something you need, dbt Labs recommends views.

0