Dedupe of sql text dumps

We want to use kopia to dedupe our daily sql text dumps of databases.
So the files and some content on the files will change but overall there is very little actual data churn.
How well does kopia work in this scenario?
Will it save less data i the backup side? What sort of gain might be expected?
And is compression also applied and still helping after it has done the deduping of the sql text backup dumps?