i am trying to replace table in sql query dynamically in adf pipeline. tried below queries to get it
select * from c where
timestampToDateTime("@{concat(variables('lastUpdatedColumn'),'*1000')}") <
"@{formatDateTime(utcnow(),'yyyy-MM-ddTHH:mm:ss.fffffffZ')}"
select * from c where TimestampToDateTime(variables('lastUpdatedColumn')*1000) <
"@{formatDateTime(utcnow(),'yyyy-MM-ddTHH:mm:ss.fffffffZ')}"
but both queries are giving same output as below
"select * from c where TimestampToDateTime("c._ts*1000") < "2024-07-
24T13:03:24.6140044Z"",
it is being replaced with “c._ts*1000” . but i want to remove those slashes(,/). how could we remove those . thanks in advance