data-mesh-banking-labs/setup/resources/code/customer-source-configs/customercustom.sql

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