dbt-tap-theme-parks

dbt models for tap-theme-parks raw data.

This dbt project turns the raw data from tap-theme-parks into models about destinations, parks and their attractions, restaurants, shows and so on.

This project also includes a `live_data_snapshot``, which keeps track of the most recent live data synced from an entity. This snapshot then feeds a fact model containing the most recent live data across everything you have live data for.

See the descriptions and lineage below.

---

Snapshots

snapshot	description
live_data_snapshot	Snapshot to track live theme park data.

Models

model	description
dim_destination	Destination dimension table.
dim_park	Park dimension table.
dim_park_Children	Park child entity (attractions, restaurants, shows and so on) dimension table.
fact_recent_live_data	The most recent live data from all entities the user has synced live data for. This relies on live_data_snapshot.

Lineage

erDiagram
    "source.tap_theme_parks.theme_parks_source.park_children" }|--|{ "model.tap_theme_parks.dim_park_children" : ""
    "source.tap_theme_parks.theme_parks_source.destination_detail" }|--|{ "model.tap_theme_parks.dim_destination" : ""
    "source.tap_theme_parks.theme_parks_source.park_detail" }|--|{ "model.tap_theme_parks.dim_park" : ""
    "snapshot.tap_theme_parks.live_data_snapshot" }|--|{ "model.tap_theme_parks.fact_recent_live_data" : ""
    "source.tap_theme_parks.theme_parks_source.live_data" }|--|{ "snapshot.tap_theme_parks.live_data_snapshot" : ""

Loading

---

Installation Instructions

Check dbt Hub for the latest installation instructions, or read the dbt docs for more information on installing packages.

Include in your packages.yml

packages:
  - package: DanielPDWalker/dbt-tap-theme-parks
    version: [">=0.1.0", "<1.0.0"]

One time setup (after creating a python virtual environment)

```
pip install dbt
dbt deps
```

development

```
dbt test
```

Database Support

This package has been tested on Postgres.