Inspect fill rates, distinct counts and common values for every column of the sample table.
44 columns. Counts describe the sample table, rather than specification requirements.
| Column | Type | Filled | Distinct | Most common values |
|---|---|---|---|---|
id | bigint | 100% | 100,000 | High cardinality; common values omitted |
availability_zone | text | 10.63% | 185 | us-east-11,132 rows 0.021,036 rows 0.00036773 rows us-west-2686 rows 0.004497 rows |
billed_cost | numeric | 100% | 25,306 | High cardinality; common values omitted |
billing_account_id | text | 100% | 4 | 123456789012394,351 rows /providers/Microsoft.Billing/billingAccounts/86115374,964 rows 20209880683 rows 00DD8H-A57456-A2H9652 rows |
billing_account_name | text | 99.32% | 1 | SunBird99,315 rows |
billing_currency | text | 100% | 1 | USD99,996 rows |
billing_period_end | timestamp with time zone | 100% | 3 | 2026-04-01 00:00:00+0099,961 rows 2026-05-01 00:00:00+0037 rows 2025-09-30 07:00:00+002 rows |
billing_period_start | timestamp with time zone | 100% | 3 | 2026-03-01 00:00:00+0099,961 rows 2026-04-01 00:00:00+0037 rows 2025-09-01 08:00:00+002 rows |
charge_category | text | 100% | 6 | Usage99,451 rows Credit282 rows Adjustment256 rows Tax6 rows Purchase3 rows |
charge_class | text | 0% | 0 | – |
charge_description | text | 100% | 1,409 | $0.000 per GB - data transfer in per month21,006 rows $0.085 per GB - next 40 TB / month data transfer out8,768 rows $0.090 per GB - first 10 TB / month data transfer out beyond the global free tier5,838 rows $0.010 per GB - regional data transfer - in/out/between EC2 AZs or using elastic IPs or ELB5,795 rows $0.005 per In-use public IPv4 address per hour4,448 rows |
charge_frequency | text | 100% | 4 | Usage-Based99,030 rows Usage-based683 rows One-Time282 rows Recurring3 rows |
charge_period_end | timestamp with time zone | 100% | 722 | 2026-03-14 00:00:00+00528 rows 2026-03-17 00:00:00+00522 rows 2026-03-12 00:00:00+00520 rows 2026-03-06 00:00:00+00519 rows 2026-03-18 00:00:00+00512 rows |
charge_period_start | timestamp with time zone | 100% | 722 | 2026-03-12 00:00:00+00464 rows 2026-03-14 00:00:00+00462 rows 2026-03-17 00:00:00+00415 rows 2026-03-15 00:00:00+00412 rows 2026-03-09 00:00:00+00408 rows |
commitment_discount_category | text | 0.24% | 2 | Spend229 rows Usage14 rows |
commitment_discount_id | text | 0.24% | 10 | arn:aws:savingsplans::365499461711:savingsplan/37985e61-4fcb-4023-9dd7-e524c80342a2143 rows arn:aws:savingsplans::961082193871:savingsplan/493f5705-db1c-4867-8e5c-ee9a66fa6d3f82 rows /providers/Microsoft.BillingBenefits/savingsPlanOrders/802a9e8b-e860-4d5f-b63b-c5bdf7ee2446/savingsPlans/09ff8291-64ac-45fb-afed-b9b39dbd88d74 rows /providers/Microsoft.Capacity/reservationOrders/26fa9d6f-645f-4c37-ad3b-ffbf6facfc58/reservations/888dc73f-de14-4b62-b936-786d746e8da64 rows arn:aws:ec2:eu-north-1:407116685360:reserved-instances/fb702b5e-81f6-4cc1-9e5d-d7a481d1202e3 rows |
commitment_discount_name | text | 0.01% | 7 | Compute_SavingsPlan_11-07-2022_09-554 rows TransferPatchTest4 rows Reservation_03-12-2018_14-202 rows VM_WUS_DS3_Upfront2 rows CSP_RI_purchaseTest_03-09-2018_10-591 rows |
commitment_discount_status | text | 0.24% | 2 | Used242 rows Unused1 rows |
commitment_discount_type | text | 0.24% | 2 | Savings Plan229 rows Reservation14 rows |
consumed_quantity | numeric | 99.71% | 42,065 | High cardinality; common values omitted |
consumed_unit | text | 99.71% | 73 | GB55,267 rows GB-Months16,759 rows Hours11,038 rows Requests5,297 rows Units2,862 rows |
contracted_cost | numeric | 99.32% | 1,045 | 0.0000000000093,592 rows 2.00000000000420 rows 1.00000000000334 rows 0.00000000053263 rows 0.00000000002192 rows |
contracted_unit_price | numeric | 99.31% | 160 | 0.0000000000092,244 rows 1.000000000001,354 rows 0.020000000001,036 rows 0.00036000000773 rows 2.00000000000613 rows |
effective_cost | numeric | 100% | 1,088 | 0.0000000000094,221 rows 2.00000000000447 rows 1.00000000000330 rows 0.00000525600261 rows 0.00000400000173 rows |
invoice_issuer_name | text | 100% | 5 | Amazon Web Services, Inc.89,932 rows Microsoft4,964 rows Amazon Web Services Canada, Inc.3,115 rows Amazon Web Services EMEA SARL1,304 rows Oracle683 rows |
list_cost | numeric | 99.99% | 25,316 | High cardinality; common values omitted |
list_unit_price | numeric | 99.89% | 532 | 030,550 rows 0.0859,076 rows 0.096,170 rows 0.015,980 rows 0.0055,386 rows |
pricing_category | text | 99.32% | 5 | Standard98,712 rows Other286 rows Committed229 rows Dynamic88 rows standard2 rows |
pricing_quantity | numeric | 99.99% | 42,040 | High cardinality; common values omitted |
pricing_unit | text | 99.99% | 73 | GB55,333 rows GB-Months16,764 rows Hours11,186 rows Requests5,335 rows Units2,862 rows |
provider_name | text | 100% | 4 | AWS94,351 rows Microsoft4,964 rows Oracle683 rows Google Cloud2 rows |
publisher_name | text | 99.99% | 8 | Amazon Web Services, Inc.89,915 rows Microsoft4,952 rows Amazon Web Services Canada, Inc.3,115 rows Amazon Web Services EMEA SARL1,304 rows Oracle683 rows |
region_id | text | 99.31% | 50 | us-west-240,782 rows us-east-129,575 rows us-east-24,834 rows eu-central-14,327 rows ap-northeast-12,694 rows |
region_name | text | 99.6% | 64 | US West (Oregon)31,565 rows US East (N. Virginia)22,027 rows External21,195 rows EU (Frankfurt)3,549 rows US East (Ohio)3,371 rows |
resource_id | text | 91.55% | 44,603 | High cardinality; common values omitted |
resource_name | text | 4.96% | 549 | zmltestplayground712 rows zfinopswkspace143 rows kubernetes41 rows storshrew37 rows finopshubsadlsgen236 rows |
resource_type | text | 20.14% | 61 | volume7,997 rows Storage account3,142 rows instance3,072 rows bucket2,836 rows distribution960 rows |
service_category | text | 99.97% | 17 | Compute42,592 rows Storage19,124 rows Networking17,471 rows Management and Governance9,176 rows Other5,447 rows |
service_name | text | 100% | 97 | Amazon Elastic Compute Cloud53,025 rows Elastic Load Balancing9,690 rows AmazonCloudWatch7,055 rows Amazon Virtual Private Cloud5,959 rows Amazon Elastic Container Service4,480 rows |
sku_id | text | 99.99% | 1,660 | HSRFWQ3TJGWVZ2EK9,210 rows 9MG5B7V4UUU2WPAV7,241 rows HQEH3ZWJVT46JHRG6,506 rows 5M4327XEUKBBTWAT6,284 rows MN45SJANDTCPR9QA4,315 rows |
sku_price_id | text | 99.03% | 1,648 | HSRFWQ3TJGWVZ2EK.JRTCKXETXF.6YS6EN2CT79,210 rows 9MG5B7V4UUU2WPAV.JRTCKXETXF.6YS6EN2CT77,241 rows HQEH3ZWJVT46JHRG.JRTCKXETXF.VF6T3GAUKQ5,884 rows MN45SJANDTCPR9QA.JRTCKXETXF.6YS6EN2CT74,315 rows PNUBVW4CPC8XA46W.JRTCKXETXF.6YS6EN2CT73,696 rows |
sub_account_id | text | 100% | 102 | 1893848484222,388 rows 1135389020421,504 rows 857428514575,745 rows 699188856314,665 rows /subscriptions/64e355d7-997c-491d-b0c1-8414dccfcf423,764 rows |
sub_account_name | text | 100% | 91 | Orion Zenith22,388 rows Atlas Orion22,178 rows Orion Odyssey5,745 rows Orion Pioneer5,231 rows Odyssey Horizon4,665 rows |
tags | jsonb | 68.66% | 8,756 | High cardinality; common values omitted |