Snowflake Data Dictionary

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→