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.
file_path	string	None	The path to the file that contains the object definition.
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.