Hard Delete Fivetran Rows.sql

DO
$$
DECLARE
    s name;
    t name;
    rowc bigint;
BEGIN
   FOR s, t IN select table_schema, table_name 
   				 from information_schema.tables 
   				where table_name NOT LIKE 'pg_%' 
   				  AND table_name NOT LIKE 'fivetran_audit' 
   				  AND table_schema LIKE 'a_prefix_here_%' 
   LOOP
        EXECUTE format('delete from %I.%I where _fivetran_deleted = true', s, t);
        EXECUTE format('select count(*) from %I.%I where _fivetran_deleted = true', s, t) into rowc;
        raise notice '%.%: % rows', s, t, rowc;
   END LOOP;
END;
$$ LANGUAGE plpgsql;