SSP: Clickhouse Config

[
    {
        "target_schema": "tq_dev_csong",
        "target_table": "api_pricing_service_2025_06_ssp",
        "s3_location": "s3://turquoise-health-data-lake/tq_dev/internal_dev_csong_consumer_pricing_service/pricing_service_ssp_2025_06",
        "file_format": "Parquet",
        "is_iceberg": true,
        "cast_function": "accurateCast",
        "table_definition": {
            "columns": [
                {
                    "name": "roid",
                    "type": "Int64"
                },
                {
                    "name": "source",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "network_provider_ssp_id",
                    "type": "Int64"
                },
                {
                    "name": "network_provider_sub_package_id",
                    "type": "Int64"
                },
                {
                    "name": "ssp_id",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "ssp_name",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "provider_id",
                    "type": "String"
                },
                {
                    "name": "provider_type",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "state",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "cbsa",
                    "type": "Nullable(String)"
                },
                {
                    "name": "cbsa_name",
                    "type": "Nullable(String)"
                },
                {
                    "name": "max_price_id",
                    "type": "Int64"
                },
                {
                    "name": "facility_fee",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "professional_fee",
                    "type": "Nullable(Float64)"
                },
                {
                    "name": "professional_rate_ids",
                    "type": "Array(Nullable(Int64))"
                },
                {
                    "name": "max_price",
                    "type": "Float64"
                },
                {
                    "name": "max_price_validated",
                    "type": "Nullable(Bool)"
                },
                {
                    "name": "max_price_claims_validated",
                    "type": "Nullable(Bool)"
                },
                {
                    "name": "max_price_sub_package_id",
                    "type": "String"
                },
                {
                    "name": "max_price_billing_code",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "max_price_billing_code_type",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "contract_methodology",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "network_id",
                    "type": "Int64"
                },
                {
                    "name": "network_name",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "payer_id",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "payer_name",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "plan_alias",
                    "type": "LowCardinality(String)"
                },
                {
                    "name": "hosp_payer_id",
                    "type": "Int32"
                }
            ],
            "order_by_keys": [
                "ssp_id",
                "provider_id",
                "payer_id"
            ]
        }
    }
]