This happens because Metabase translates datetimeDiff into the SQL Server function DATEDIFF_BIG, which is not supported in Synapse's serverless SQL pools.