none
Setting Quote character causing Conditions are not met to run polybase copy directly

    Question

  • I have a CSV input files which is delimited using commas(,). There are also values in the CSV that may have a comma character, however these values are enclosed in quotes("), which is standard CSV way.

    This is data is loaded into a Azure DataWarehouse using a copy activity. To avoid the copy activity from splitting the value's with commas in them I set the Quote Character (quoteChar) on the DataSet to quotes("). However when I run the activity I get the following error

    Quote character has been set. Conditions are not met to run polybase copy directly, please specify storage account

    I suppose polybase loads don't like having to deal with quoted strings. Is there a solution/workaround for this?


    Friday, September 28, 2018 1:28 PM

All replies