NerReplace Example: Change Text Used for Redacted Entities with ReplacementText - Teradata Vantage

select * from td_mldb.NerReplace(
    on (select id, txt as orig_txt, txt from ner_input_distilbert_NER)
    on (select model from ner_models_tst where model_id = 'distilbert-NER') DIMENSION
    on (select tokenizer from ner_tokenizers_tst where tokenizer_id = 'distilbert-NER') DIMENSION
    on (select tokenizer as config from ner_model_configurations_tst where tokenizer_id = 'distilbert-NER') DIMENSION
        using
            Accumulate('id','txt')
            ReplacementText('CONFIDENTIAL')
) a;

 *** Query completed. 8 rows found. 2 columns returned. 
 *** Total elapsed time was 2 seconds.

id          22
txt The job title is Senior Analyst, job type is Full-time, last name CONFIDENTIAL. IBAN: CONFIDENTIALCONFIDENTIAL12CONFIDENTIALCONFIDENTIALK0000000000000123456, companyname: CONFIDENTIALCONFIDENTIALCONFIDENTIAL. Age: 37, eye color: brown, CONFIDENTIALCONFIDENTIALeum address 0xE853c56864A2ebe4576a807D26Fdc4A0ada51919, phone CONFIDENTIALCONFIDENTIALCONFIDENTIAL 353072070237232.
 id          17
txt The date of the transaction is 2024-08-07. Date of birth: 1980-03-14. Phone IMEI: 356938035643809. Employer: CONFIDENTIAL, job type Full-time, job area: CONFIDENTIAL. His CONFIDENTIALCONFIDENTIALCONFIDENTIAL address is 0x742d35Cc6634C0532925a3b844Bc454e4438f44e and MAC address is 00:1B:44:11:3A:B7.
 id           5
txt Please send the package to Building 7, 300 CONFIDENTIAL, CONFIDENTIAL, 02111.
 id          13
txt CONFIDENTIAL's city is CONFIDENTIAL, and she works for CONFIDENTIALCONFIDENTIALCONFIDENTIAL. Her credit card number is 5555 4444 3333 2222, CVV 456, and the issuer is CONFIDENTIALCONFIDENTIALCONFIDENTIAL. Her CONFIDENTIALCONFIDENTIALCONFIDENTIAL address is 0x3f5CE5FBFe3E9af3971dD833D26BA9b5C936f0bE, and she also uses a CONFIDENTIALCONFIDENTIALCONFIDENTIALn address MQMcJhpWHYVeQArcZR3sBgyPZxxRtnH441.
 id          24
txt Masked number: **** **** **** 1234, middle name CONFIDENTIAL, nearby GPS coordinate 40.7128,-74.0060. Credit card number: 4000 1234 5678 9010, CVV 888, BIC: BOFAUS3N, currency: USD, currency code: USD, amount: 300.00, city: CONFIDENTIAL.
 id          11
txt Account name: CONFIDENTIAL, account number 192837465, age 34. Please send $12,500.00 to CONFIDENTIALCONFIDENTIAL DECONFIDENTIALCONFIDENTIALCONFIDENTIALCONFIDENTIALCONFIDENTIALCONFIDENTIAL. CONFIDENTIAL was born on 1989-02-14 and currently lives in building number 17, CONFIDENTIAL, CONFIDENTIAL. His email is michael.rogers@example.com and his IBAN is DE89370400440532013000.
 id           3
txt Dr. CONFIDENTIAL lives at 45CONFIDENTIAL CONFIDENTIAL, CONFIDENTIAL, 12345.
 id           9
txt CONFIDENTIAL's credit card (3714 496353 98431) is linked to her social number 678-90-1234.