Overview

Consumer Pricing Service is a a pricing layer on top of Clear Rates.

Visit the Clear Rates Technical Documentation Here and User-Friendlier Documentation Here

---

Where to Find the Data

Latest tables are here:

• tq_production.consumer_prices.pricing_service_ssp
• tq_production.consumer_prices.pricing_service_rates
• tq_production.consumer_prices.pricing_service_ref_provider

---

Table of Contents

Core Pricing Service:

Methodology

• Pipeline - Data processing pipeline overview
• Clear Rates Logic Divergence - Differences from Clear Rates logic

Automated QA

• Data Integrity Tests - Data validation checks
• Data Quality Tests - Quality assurance tests

Schemas

• Pricing Service Rates - Line-item level rates table
• Pricing Service SSP - SSP-level prices table

ClickHouse Configs

• Rates ClickHouse - ClickHouse rates config example
• SSP ClickHouse - ClickHouse SSP config example

Analytics

• Analytics Overview