Integrations

Integrations read definitions, data-quality logic, and dependencies from connected data systems. The current dbt integration uses a read-only GitHub connection and adds source-backed records to the memory graph used during analysis.

The dbt integration reads code and dependencies

For each model, Sienna reads its code, upstream assets, and project context. It identifies what the model represents, how its rows are shaped, and which business decisions or data issues the logic contains.

Connected dbt projectanalytics

GitHub · read-onlyProject reviewed

models/marts/fct_orders.sqlExample

select
order_id,
customer_id,
net_amount
from {{ ref('stg_orders') }}
where order_id is not null
and status = 'completed'

dbt evidence is attached to memory-graph records

Business decisions found in dbt are recorded as definitions. Source-quality issues are recorded as data-quality observations. Both retain evidence and dependency links for use during analysis.

Example recordsmodels/marts/fct_orders.sql

Source evidence attached

DefinitionCompleted order

What it means: An order whose status is completed.
Source evidence: fct_orders.sql · line 50
Depends on: stg_orders.status

Data qualityOrders without an ID are excluded

Affected data: FCT_ORDERS.ORDER_ID
Source evidence: fct_orders.sql · line 49
Affects: Completed order

New evidence is reconciled with existing records

Sienna compares new evidence with existing records, adds source and dependency links, and surfaces conflicting meanings for review. The reconciled records are then available anywhere Sienna uses the memory graph.

Memory graph updateCompleted order

Example from the connected dbt project

Source evidence

fct_orders.sqlCompleted-order filter
orders.ymlOrder ID constraint
ref('stg_orders')Upstream dependency

Reconcile with memory graph

Match existing records
Attach evidence and dependencies
Keep conflicting meanings separate

Connected records

DefinitionCompleted orderDepends on STG_ORDERS.STATUS

Data qualityOrders without an ID are excludedAffects Completed order