# AWS CUR Table Schema Audit (by Table)

This file is generated from bq metadata queries. It records fields for each table in aws_nonprod_billing / aws_prod_billing, whether resource_tags / resource_id are present, and adds environment mapping notes.

## Account Mapping (manually maintained)

| account_id | account_name | env | dataset_table |
| --- | --- | --- | --- |
| 398894451188 | pingcap-security | nonprod | `aws_nonprod_billing.398894451188_aws_billing_data` |
| 316218510314 | PingCAP-test | nonprod | `aws_nonprod_billing.316218510314_aws_billing_data` |
| 510387698298 | pingcapcn | nonprod | `aws_nonprod_billing.510387698298_aws_billing_data` |
| 178851224597 | tikv-storage-dev | nonprod | `aws_nonprod_billing.178851224597_aws_billing_data` |
| 200683210682 | dbaas-infra-dev | nonprod | `aws_nonprod_billing.200683210682_aws_billing_data` |
| 470438934515 | tidbcloud-marketplace | nonprod | `aws_nonprod_billing.470438934515_aws_billing_data` |
| 385595570414 | PingCAP | nonprod | `aws_nonprod_billing.385595570414_aws_billing_data` |
| 646528577659 | compute-dev | nonprod | `aws_nonprod_billing.646528577659_aws_billing_data` |
| 166681434446 | escalation-dev | nonprod | `aws_nonprod_billing.166681434446_aws_billing_data` |
| 946646677266 | qa-infra-dev | nonprod | `aws_nonprod_billing.946646677266_aws_billing_data` |
| 495580073302 | dp-infra-dev | nonprod | `aws_nonprod_billing.495580073302_aws_billing_data` |
| 676546228356 | qa-dbaas-dev | nonprod | `aws_nonprod_billing.676546228356_aws_billing_data` |
| 448141240262 | qa-dp-testing-dev | nonprod | `aws_nonprod_billing.448141240262_aws_billing_data` |
| 986330900858 | qa-system-testing-dev | nonprod | `aws_nonprod_billing.986330900858_aws_billing_data` |
| 013690006788 | qa-perf-testing-dev | nonprod | `aws_nonprod_billing.013690006788_aws_billing_data` |
| 552185537300 | clinic-dev | nonprod | `aws_nonprod_billing.552185537300_aws_billing_data` |
| 482894109814 | cloud-ecosystem-dev | nonprod | `aws_nonprod_billing.482894109814_aws_billing_data` |
| 795292582174 | TiDBCloud-JSM-kafka | nonprod | `aws_nonprod_billing.795292582174_aws_billing_data` |
| 024848481520 | auto-deployment-test | nonprod | `aws_nonprod_billing.024848481520_aws_billing_data` |
| 886436925895 | test-auto-deploy-staging-on-prod | nonprod | `aws_nonprod_billing.886436925895_aws_billing_data` |
| 813266824626 | autonomous-dataplane-dev-01 | nonprod | `aws_nonprod_billing.813266824626_aws_billing_data` |
| 950061775591 | observability-test | nonprod | `aws_nonprod_billing.950061775591_aws_billing_data` |
| 227896186585 | byoc-cluster-server | nonprod | `aws_nonprod_billing.227896186585_aws_billing_data` |
| 131464424160 | testinfra-prod-testregion | nonprod | `aws_nonprod_billing.131464424160_aws_billing_data` |
| 757842878326 | autonomous-partner-test | nonprod | `aws_nonprod_billing.757842878326_aws_billing_data` |
| 790636686964 | staging-next-gen-dataplane | nonprod | `aws_nonprod_billing.790636686964_aws_billing_data` |
| 703227779288 | ee-infra-dev | nonprod | `aws_nonprod_billing.703227779288_aws_billing_data` |
| 487825215408 | tidb-br-dev-test | nonprod | `aws_nonprod_billing.487825215408_aws_billing_data` |
| 629891806751 | byoc-deployment | nonprod | `aws_nonprod_billing.629891806751_aws_billing_data` |
| 557537366020 | dbaas-prod-clinic | prod | `aws_prod_billing.557537366020_aws_billing_data` |
| 380838443567 | pingcap-dbaas | prod | `aws_prod_billing.aws_prod_billing_data` |
| 835830315734 | Log Archive | prod | `aws_prod_billing.835830315734_aws_billing_data` |
| 945698639225 | Audit | prod | `aws_prod_billing.945698639225_aws_billing_data` |
| 143458967504 | dbaas-prod-dataplane-000 | prod | `aws_prod_billing.143458967504_aws_billing_data` |
| 886436949658 | dbaas-prod-only-s3 | prod | `aws_prod_billing.886436949658_aws_billing_data` |
| 182399704004 | dbaas-prod-auto-task | prod | `aws_prod_billing.182399704004_aws_billing_data` |
| 730335266318 | dbaas-prod-dataplane-001 | prod | `aws_prod_billing.730335266318_aws_billing_data` |
| 296171618728 | dbaas-prod-tidbcloud-pov | prod | `aws_prod_billing.296171618728_aws_billing_data` |
| 632330501419 | dbaas-prod-dataplane-nextgen | prod | `aws_prod_billing.632330501419_aws_billing_data` |