Skip to content


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


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


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

  - name: local_merge
        - 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 =


Field Type Default Description
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.