are you sure the csv does not contain special characters etc?

csv files are known for shenanigans like that.

Passing variables from ADF to Databricks itself works fine, many people use it.

So my guess is there is something fishy in the values themselves so Spark cannot read them or the table does not exist (because of invalid characters etc).