![alt text](docs/images/orchard.png)
# Introduction
Welcome to The Orchard dbt Cloud Project. dbt cloud is a hosted instance of the open source dbt project combined which combines an integrated ide and a job scheduler. You can find the project [here](https://cloud.getdbt.com/). To request access to the documentation then please contact [Tech Help](tech.help@sonymusic.com).

You can find links to key documentation about this project below:

  - [dbt Model Building Guidance](docs/guides/dbt_model_building_guidance.md)
  - [SQL Style Guide](docs/guides/sql_style_guide.md)
  - [dbt Pull Request Template](docs/pull_request_template.md)

These documents takes heavy inspiration from:

- [Brooklyn Data Co](https://github.com/brooklyn-data/co)
- [dbt Labs](https://docs.getdbt.com/guides/best-practices)
- [Gitlab](https://about.gitlab.com/handbook/business-technology/data-team/platform/sql-style-guide/)

If you have any questions or want to get in touch with the analytics team you can [email us](analytics@theorchard.com) us or ping us on [Slack](https://orcd.slack.com/archives/C054VEGBVDH).

# Overview of the Analytics Infrastructure

This project drives all the objects to be found in the Intelligence database in Snowflake. The majority of the transformation and aggregation done to data picked up from the Data Ingestion team is done in dbt. These models are then exposed & joined together in Looker for general BI use.


The core analytics models are as follows:
- Aggregated Store Models
- Summary Streams
- Playlist Model

A top level overview of how these are put together is as follows:

![alt text](docs/images/infra_top_level.png)

The source & enrichment data to drive these models is taken from across the various data sources in Snowflake available for general use. These models power the majority of Looker reports.