Rates: Clickhouse Config

[
    {
        "target_schema": "tq_dev_csong",
        "target_table": "api_pricing_service_2025_06_rates",
        "s3_location": "s3://turquoise-health-data-lake/tq_dev/internal_dev_csong_consumer_pricing_service/pricing_service_rates_2025_06",
        "file_format": "Parquet",
        "is_iceberg": true,
        "cast_function": "accurateCast",
        "table_definition": {
            "columns": [
                {
                    "name": "network_provider_sub_package_id",
                    "type": "Int64"
                },
                {
                    "name": "network_provider_ssp_id",
                    "type": "Int64"
                },
                {
                    "name": "id",
                    "type": "Int64"
                },
                {
                    "name": "roid",
                    "type": "Int64"
                },
                {
                    "name": "ssp_id",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "ssp_name",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "sub_package_id",
                    "type": "String"
                },
                {
                    "name": "payer_id",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "payer_name",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "network_id",
                    "type": "Int64"
                },
                {
                    "name": "network_name",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "provider_id",
                    "type": "String"
                },
                {
                    "name": "provider_type",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "npi",
                    "type": "Array(Nullable(String))"
                },
                {
                    "name": "state",
                    "type": "Nullable(String)"
                },
                {
                    "name": "cbsa",
                    "type": "Nullable(String)"
                },
                {
                    "name": "cbsa_name",
                    "type": "Nullable(String)"
                },
                {
                    "name": "fee_type",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "is_package_base_code",
                    "type": "Int32"
                },
                {
                    "name": "billing_code",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "billing_code_type",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "average_units",
                    "type": "Nullable(Decimal64(3))"
                },
                {
                    "name": "anesthesia_unit_conversion",
                    "type": "Decimal64(3)"
                },
                {
                    "name": "billing_code_description",
                    "type": "String"
                },
                {
                    "name": "validated_rate",
                    "type": "Bool"
                },
                {
                    "name": "validated_prof_fee_rate",
                    "type": "Bool"
                },
                {
                    "name": "claims_validated_rate",
                    "type": "Bool"
                },
                {
                    "name": "commercial_validated_reimbursement_rate",
                    "type": "Bool"
                },
                {
                    "name": "commercial_validated_cash_rate",
                    "type": "Bool"
                },
                {
                    "name": "state_avg_negotiated_rate_used",
                    "type": "Nullable(Bool)"
                },
                {
                    "name": "state_avg_discounted_cash_rate_used",
                    "type": "Nullable(Bool)"
                },
                {
                    "name": "negotiated_rate",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "discounted_cash_rate",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "state_avg_medicare_rate",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "lower_bound",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "upper_bound",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "contract_methodology",
                    "type": "Nullable(String)"
                },
                {
                    "name": "gross_charge",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "source",
                    "type": "Nullable(String)"
                },
                {
                    "name": "hosp_payer_id",
                    "type": "Int32"
                },
                {
                    "name": "plan_alias",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "validated_subpackage",
                    "type": "Bool"
                },
                {
                    "name": "price",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "allocation",
                    "type": "Decimal64(3)"
                },
                {
                    "name": "allocated_price",
                    "type": "Nullable(Float64)"
                }
            ],
            "order_by_keys": [
                "ssp_id",
                "provider_id",
                "payer_id",
                "fee_type",
                "billing_code"
            ]
        }
    }
]