How to check if two SQL tables are the same(github.com)

    sqldiff -t mytable database1.sqlite database2.sqlite

  select * from (
    (
      select *
      from table1
      minus
      select *
      from table2
    )
    union all
    (
      select *
      from table2
      minus
      select *
      from table1
    )
  )

  SELECT count(q.*)
  FROM (SELECT a, b FROM table_a a
        NATURAL FULL OUTER JOIN table_b b
        WHERE a IS NOT DISTINCT FROM NULL
           OR b IS NOT DISTINCT FROM NULL) q;

  proc compare base=proclib.one compare=proclib.two printall;

  from io import StringIO
  import pandas as pd
  import datacompy

  compare = datacompy.Compare(
      df1,
      df2,
      join_columns='acct_id',  #You can also specify a list of columns
      abs_tol=0, #Optional, defaults to 0
      rel_tol=0, #Optional, defaults to 0
      df1_name='Original', #Optional, defaults to 'df1'
      df2_name='New' #Optional, defaults to 'df2'
      )
  compare.matches(ignore_extra_columns=False)
  # False

  # This method prints out a human-readable report summarizing and sampling differences
  print(compare.report())