# Verifying Row and Column Counts
Pointblank Validation
2026-07-13|17:44:54 DuckDB
STEP COLUMNS VALUES TBL EVAL UNITS PASS FAIL W E C EXT
#4CA64C 1
gzOCBDNTYuNTcxNDgyOCwxMy4zMjQ3NDIxIDU2LjY1MjY2MTIsMTMuNDgwNzA3MiA1Ni42NzU4Mzg5LDEzLjcwNDE3MDcgTDU2LjY3NTgzODksMTMuNzA0MTcwNyBMNTYuNjgyODk1Myw1My4xODEzMzYgQzU2LjY4Mjg5NTMsNTMuNDYwMzIyIDU2LjYwOTE4OSw1My42NTUxNzU2IDU2LjQ4Mzk0MTYsNTMuNzc5MTQ4MSBDNTYuMjY0OTY4Nyw1My45OTU4OTIyIDU1Ljk0ODcwODMsNTQuMDExMjE3NCA1NS44MzAwNzUyLDU0LjAxNDI0OTMgTDU1LjgzMDA3NTIsNTQuMDE0MjQ5MyBMNTMuNzMwNTE0Myw1NC4wMTQ1ODg2IEw1My43MzA1MTQzLDEzLjAxNDc1MDIgWiIgaWQ9InJvd3NfdHdvIiBzdHJva2U9IiMwMDAwMDAiIGZpbGwtcnVsZT0ibm9uemVybyIgdHJhbnNmb3JtPSJ0cmFuc2xhdGUoNDkuMTgyODk1LCAzMy41MTQ2NjkpIHJvdGF0ZSgtMTgwLjAwMDAwMCkgdHJhbnNsYXRlKC00OS4xODI4OTUsIC0zMy41MTQ2NjkpICIgLz4KICAgICAgICAgICAgPGcgaWQ9InZlcnRpY2FsX2VxdWFsIiB0cmFuc2Zvcm09InRyYW5zbGF0ZSgzNC4xMzUxOTUsIDMzLjcyNjkwMykgcm90YXRlKC05MC4wMDAwMDApIHRyYW5zbGF0ZSgtMzQuMTM1MTk1LCAtMzMuNzI2OTAzKSB0cmFuc2xhdGUoMzAuNjM1MTk1LCAyOS4yMjY5MDMpIiBzdHJva2U9IiMwMDAwMDAiIHN0cm9rZS1saW5lY2FwPSJzcXVhcmUiPgogICAgICAgICAgICAgICAgPGxpbmUgeDE9IjIuMjEyMjMzOTciIHkxPSIwLjUxNDY2OTM1MyIgeDI9IjIuMjEyMjMzOTciIHkyPSI3LjU4NTczNzE2IiBpZD0iTGluZSI+PC9saW5lPgogICAgICAgICAgICAgICAgPGxpbmUgeDE9IjUuMjEyMjMzOTciIHkxPSIwLjUxNDY2OTM1MyIgeDI9IjUuMjEyMjMzOTciIHkyPSI3LjU4NTczNzE2IiBpZD0iTGluZSI+PC9saW5lPgogICAgICAgICAgICA8L2c+CiAgICAgICAgICAgIDxwYXRoIGQ9Ik0xMS41OTMxODYzLDEyLjUxNDY2OTQgQzExLjM4MzY2MjUsMTIuNTE0NjY5NCAxMC4yMTIyMzQsMTIuNTY0NjY5NCAxMC4yMTIyMzQsMTMuODQ4MDAyNyBMMTAuMjEyMjM0LDUzLjE4MTMzNiBDMTAuMjEyMjM0LDU0LjQ2NDY2OTQgMTEuMzgzNjYyNSw1NC41MTQ2Njk0IDExLjU5MzE4NjMsNTQuNTE0NjY5NCBMMTQuMTY0NjE0OSw1NC41MTQ2Njk0IEwxNC4xNjQ2MTQ5LDEyLjUxNDY2OTQgTDExLjU5MzE4NjMsMTIuNTE0NjY5NCBaIE0yMC4xNzIxNzcxLDEyLjUxNDY2OTQgTDIwLjE3MjE3NzEsNTQuNTE0NjY5NCBMMTYuMjUyMjkwOCw1NC41MTQ2Njk0IEwxNi4yNTIyOTA4LDU0LjUxNDY2OTQgTDE2LjI1MjI5MDgsMTIuNTE0NjY5NCBMMTYuMjUyMjkwOCwxMi41MTQ2Njk0IEwyMC4xNzIxNzcxLDEyLjUxNDY2OTQgWiBNMjQuODY1NjE0OSwxMi41MTUwOTA0IEMyNS4xNDQ4Nzg2LDEyLjUyMTc2MyAyNi4yMTIyMzQsMTIuNjIzMDAyNyAyNi4yMTIyMzQsMTMuODQ4MDAyNyBMMjYuMjEyMjM0LDEzLjg0ODAwMjcgTDI2LjIxMjIzNCw1My4xODEzMzYgQzI2LjIxMjIzNCw1NC40NjQ2Njk0IDI1LjA0MDgwNTQsNTQuNTE0NjY5NCAyNC44MzEyODE2LDU0LjUxNDY2OTQgTDI0LjgzMTI4MTYsNTQuNTE0NjY5NCBMMjIuMjU5ODUzLDU0LjUxNDY2OTQgTDIyLjI1OTg1MywxMi41MTQ2Njk0IFoiIGlkPSJyb3dzX29uZSIgZmlsbD0iIzAwMDAwMCIgZmlsbC1ydWxlPSJub256ZXJvIiB0cmFuc2Zvcm09InRyYW5zbGF0ZSgxOC4yMTIyMzQsIDMzLjUxNDY2OSkgcm90YXRlKC0xODAuMDAwMDAwKSB0cmFuc2xhdGUoLTE4LjIxMjIzNCwgLTMzLjUxNDY2OSkgIiAvPgogICAgICAgIDwvZz4KICAgIDwvZz4KPC9zdmc+" /> col_count_match()
-- 11 ✓ 1 1
1.00		 0
0.00		 -- -- -- --
#4CA64C 2
row_count_match()
-- 2000 ✓ 1 1
1.00		 0
0.00		 -- -- -- --
#4CA64C 3
row_count_match()
-- ≠ 0 ✓ 1 1
1.00		 0
0.00		 -- -- -- --
#4CA64C 4
col_count_match()
-- 11 ✓ 1 1
1.00		 0
0.00		 -- -- -- --
2026-07-13 17:44:54 UTC< 1 s2026-07-13 17:44:54 UTC
``` python import pointblank as pb validation = ( pb.Validate( data=pb.load_dataset(dataset="game_revenue", tbl_type="duckdb") ) .col_count_match(count=11) # expect 11 columns in the table .row_count_match(count=2000) # expect 2,000 rows in the table .row_count_match(count=0, inverse=True) # expect that the table has rows .col_count_match( # compare column count against count=pb.load_dataset( # that of another table dataset="game_revenue", tbl_type="pandas" ) ) .interrogate() ) validation ``` Preview of Input Table
DuckDBRows2,000Columns11
player_id string
session_id string
session_start timestamp
time timestamp
item_type string
item_name string
item_revenue float64
session_duration float64
start_day date
acquisition string
country string
1 ECPANOIXLZHF896 ECPANOIXLZHF896-eol2j8bs 2015-01-01 01:31:03+00:00 2015-01-01 01:31:27+00:00 iap offer2 8.99 16.3 2015-01-01 google Germany
2 ECPANOIXLZHF896 ECPANOIXLZHF896-eol2j8bs 2015-01-01 01:31:03+00:00 2015-01-01 01:36:57+00:00 iap gems3 22.49 16.3 2015-01-01 google Germany
3 ECPANOIXLZHF896 ECPANOIXLZHF896-eol2j8bs 2015-01-01 01:31:03+00:00 2015-01-01 01:37:45+00:00 iap gold7 107.99 16.3 2015-01-01 google Germany
4 ECPANOIXLZHF896 ECPANOIXLZHF896-eol2j8bs 2015-01-01 01:31:03+00:00 2015-01-01 01:42:33+00:00 ad ad_20sec 0.76 16.3 2015-01-01 google Germany
5 ECPANOIXLZHF896 ECPANOIXLZHF896-hdu9jkls 2015-01-01 11:50:02+00:00 2015-01-01 11:55:20+00:00 ad ad_5sec 0.03 35.2 2015-01-01 google Germany
1996 NAOJRDMCSEBI281 NAOJRDMCSEBI281-j2vs9ilp 2015-01-21 01:57:50+00:00 2015-01-21 02:02:50+00:00 ad ad_survey 1.332 25.8 2015-01-11 organic Norway
1997 NAOJRDMCSEBI281 NAOJRDMCSEBI281-j2vs9ilp 2015-01-21 01:57:50+00:00 2015-01-21 02:22:14+00:00 ad ad_survey 1.35 25.8 2015-01-11 organic Norway
1998 RMOSWHJGELCI675 RMOSWHJGELCI675-vbhcsmtr 2015-01-21 02:39:48+00:00 2015-01-21 02:40:00+00:00 ad ad_5sec 0.03 8.4 2015-01-10 other_campaign France
1999 RMOSWHJGELCI675 RMOSWHJGELCI675-vbhcsmtr 2015-01-21 02:39:48+00:00 2015-01-21 02:47:12+00:00 iap offer5 26.09 8.4 2015-01-10 other_campaign France
2000 GJCXNTWEBIPQ369 GJCXNTWEBIPQ369-9elq67md 2015-01-21 03:59:23+00:00 2015-01-21 04:06:29+00:00 ad ad_5sec 0.12 18.5 2015-01-14 organic United States