data-mesh-banking-labs/setup/resources/code/merchant-source-configs/merchantcustom.sql

SELECT *,   
to_date(dt,'yyyy-MM-dd') as ingest_date
FROM __table__