Skip to main content

Organizing models by levels

You need to set up a logical folder structure right from the start.

  • Naming folders: Prefix by numerals to sort by importance
  • Base models vs query models
    • A folder of base models as standard (where you have minimal to no changes to the underlying data)
    • A folder of query models (More complex models, that contains pre-aggregated data which is not exploratory)
  • Archive folder (for data models you want to keep, but not delete)
  • Children folders by Entity Type (Customers, Sales...)

Here is an example:

project-folder-name (root)
|- 1.Base models
| |- customers
| |- sales
| |- base_model_n
|- 2. Query models
| |- query_model_1
| |- query_model_2
|- 3. Analytical models (Specific use query models)
| |- analytical_model_1
| |- analytical_model_2
|- 4. Archive

Let us know what you think about this document :)