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 DuckDB database. While more efficient than SQLite, it's still primarily designed for medium-sized datasets.

Example

Internal join External

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.