> ## Documentation Index
> Fetch the complete documentation index at: https://developers.stellar.org/llms.txt
> Use this file to discover all available pages before exploring further.

# Architecture

> In general stellar-dbt-public runs by.

## Architecture Overview

![](https://mintcdn.com/stellardevelopmentfoundation/nXKshiEJBuAoHF5T/img/hubble/stellar_dbt_architecture.png?fit=max\&auto=format\&n=nXKshiEJBuAoHF5T\&q=85\&s=940389879dee7a37d79f24a26bbecaf7)

In general stellar-dbt-public runs by:

* Selecting a dbt model to run
* Within the model run:
  * Sources are referenced and used to create staging tables
  * Staging tables then undergo various transformations and are stored in intermediate tables
  * Finishing touches and joins are done on the intermediate tables which produce the final analytics friendly mart tables

We try to adhere to the best practices set by the [dbt docs](https://docs.getdbt.com/docs/build/projects)

More detailed information about stellar-dbt-public and examples can be found in the [stellar-dbt-public](https://github.com/stellar/stellar-dbt-public/tree/master) repo.