Analyzer

-- Step 1: one-time setup (run create_analyze_sp.sql first)

-- Step 2: create a point-in-time snapshot of a table
CALL datamodder.create_pit();

-- Or with explicit parameters:
CALL datamodder.create_pit(
  source_db  => 'MY_DB',
  source_sch => 'RAW',
  source_tbl => 'CUSTOMERS'
);

-- Step 3: register new snapshots in the statistics register
CALL datamodder.register_pits();

-- Step 4: calculate column statistics over all registered snapshots
CALL datamodder.update_statistics();

-- View the results:
SELECT * FROM datamodder.statistics
ORDER BY snapshot_ts DESC;