In this query, Teradata Wallet replaces $tdwallet(abc) with the corresponding password stored on the client Teradata Wallet.
select * from cfilter(
on (select 1)
partition by 1
database('beehive')
userid('beehive')
PASSWORD('$tdwallet(abc)')
inputtable('cfilter_test')
outputTable('cfilter_test1')
inputColumns('item')
joinColumns('tranid')
droptable('true'));