assert_table_count_equal.sql

create or replace procedure yoshioka_test1.assert_table_count_equal(table_name1 string, table_name2 string)
begin
  execute immediate '''
    with
      results as (
        select
          (select count(*) from ''' || table_name1 || ''') as expected,
          (select count(*) from ''' || table_name2 || ''') as actual,
      )
    select * from results
    where
      if(expected = actual, true, error('Not equal row counts. ''' || table_name1 || ''': ' || expected || ' rows. ''' || table_name2 || ''': ' || actual || ' rows.')) 
  ''';
end;