Raw Tables

“Raw” tables include unmodified JSON objects, as they are stored in Element451’s application database. During ETL, certain parameters are extracted from the JSON and appended as columns to the table, for ease of use.

Raw Tables

Lookup Tables

“Lookup” tables connect identifiers to their metadata.

Lookup Tables

Staging Tables

“Staging” tables perform some initial modeling that you can further develop.

Staging Tables