Solarvista

This package models Solarvista Live data from Matatika's Tap.

The main focus of the package is to transform the revenue, project, work item, and engineer data into analytics for management, planning and performance insights.

This package along with the Analyze Bundle are designed intended to work together to provide instant insights on the Matatika Platform.

Models

model	description
dim_customer	Customer name and reference information.
dim_date	Date information including retail weeks of year.
dim_equipment	Equipment reference information.
dim_project	Project information with type-2 Slowly Changing Dimensions available in `dim_project_snapshot`.
dim_site	Site reference information.
dim_territory	Territory reference information.
dim_site	User reference information.
dim_territory	Territory reference information.
dim_user	User reference information with type-2 Slowly Changing Dimensions available in `dim_user_snapshot`.
fact_activity	Activity facts.
fact_appointment	Appointment facts.
fact_workitem	Work item facts including duration, travel time, and charges.
fact_workitem_history	History of work item stage changes (Assigned, Accepted, Travelling to, Working, Closed, etc).
fact_workitem_stages	Work item stage facts implemented as an Accumulating Snapshot Fact Table.
vw_daily_projects	Daily summary of projects for customers.
vw_project_sla	Summary of project service level performance.
vw_workitem_stages	Summary of work item stages.

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: Matatika/dbt-tap-solarvista
    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.

Cloud hosting and SaaS

Deploy on the Matatika Platform within minutes. www.matatika.com

Contributions

Additional contributions to this package are very welcome! Please create issues or open PRs against master. Check out this post on the best workflow for contributing to a package.

Resources:

Have questions, feedback, or need help? Please email us at support@matatika.com
Find all of Matatika's pre-built dbt packages in our dbt hub
Learn how to orchestrate dbt transformations with Matatika
Learn more about Matatika in our docs
Learn more about dbt in the dbt docs

License

You are granted use of this library under the AGPLv3 License terms.

This license grants you the freedom to use the software without any warranties, but requires you to open source your platform with the same terms if you distribute or host a service using any part of this library. Contact us for a commercial embedded license to remove this restriction.

mike-aboagye/dbt-tap-solarvista