Remove the custom access count filter for DM_BIZ etc.
@@ -203,11 +203,6 @@ class TeradataExtract:
from DBC.Tables a where a.TableKind = 'T'
AND a.DatabaseName = '%s'
%s
- AND case when a.DatabaseName in ('DM_BIZ', 'DM_SEC') and a.AccessCount < 200 then -1
- when a.DatabaseName in ('DM_DA', 'DM_DSC', 'NCRM') and a.AccessCount < 100 then -1
- -- else a.AccessCount
- else 1 -- include all other tables
- end >= 1
AND a.TableName NOT LIKE ALL ('INFA%%', 'tmp!_%%', 'temp!_%%', 'ut!_%%', '!_%%', '#%%' 'ET!_%%', 'LS!_%%', 'VT!_%%', 'LOGTABLE%%', 'backup%%', 'bkp%%', 'W!_%%') ESCAPE '!'
AND RTRIM(a.TableName) NOT LIKE ALL ('%%!_tmp', '%%!_temp', '%%!_ERR!_.', '%%!_bkp', '%%!_backup') ESCAPE '!'
AND REGEXP_SIMILAR(RTRIM(a.TableName), '.*_tmp_[0-9]+','i') = 0
