Releases · fivetran/dbt_aws_cloud_cost

This is the initial release of the aws_cloud_cost dbt package!

📣 What does this dbt package do?

This package models AWS Cloud Cost data from Fivetran's AWS Cost Report connector. It uses data in the format described by the AWS Cost & Usage Report.

The main focus of the package is to transform the core object tables into analytics-ready models, including:

Materializes AWS Cloud Cost staging tables which leverage data in the format described by the AWS Cost & Usage Report. These staging tables clean, test, and prepare your AWS Cloud Cost data from Fivetran's connector for analysis by doing the following:
- Names columns for consistency across all packages and for easier analysis:
  - Column names are shortened for convenience and to avoid redundancy.
- Takes the latest export of each account's billing month report.
Creates analytics-ready end models for monitoring and investigating cost & usage of different AWS services across your organizations.
Generates a comprehensive data dictionary of both your AWS Cloud Cost source and modeled data through the dbt docs site.

This package does not apply freshness tests.

The following table provides a detailed list of all models materialized within this package by default.

TIP: See more details about these models in the package's dbt docs site.

model	description
aws_cloud_cost__daily_overview	Daily aggregation of the Standard Cost & Usage Report (2.0) exported from AWS. Includes slew of commonly analyzed dimensions related to billing, pricing, line item buckets, and products. Contains both high-level cost and usage metrics, along with all metrics related to reservations and savings plans. Also includes financial reporting fieds relating to invoices and billing periods.
aws_cloud_cost__daily_product_report	Daily view of each account's use of and associated costs from individual AWS products for each billing period.
aws_cloud_cost__daily_instance_report	Daily view of each account's use of and associated costs from different Amazon Elastic Compute Cloud (EC2) instances for each billing period.