Skip to content

LocalMergeModel

Local Merge Models are models that allow you to merge data from multiple other models locally.

Note

Any joining is done in a local SQLite database. It is not designed for large datasets.

Example

Here is an example of merging two models that are defined in your project. One that is external and one that is internal.

models:
  - name: local_merge
    models:
        - ref(first_domain_model)
        - ref(external_data_model)
    sql: SELECT * FROM first_domain_model.model AS fdm JOIN external_data_model.model AS edm ON fdm.external_id = edm.id

Attributes

Field Type Default Description
path string None A unique path to this object
name string None The unique name of the object across the entire project.
sql string None The sql used to generate your base data
models Array of #/$defs/Model None A model object defined inline or a ref() to a model.