SQL script (Azure Data Lake Analytics) in which I extract too large text for string. So I use byte[]. But when I save results in CSV file, this text is BASE64 encoded.
Is there a option to save it as simple string? (For saving I use Outputters.Csv() ).
OR:
Then I copy data (with Azure Data Factory) into SQL database. Is there option to store this text as varchar/text datatype in database? I found that DF has decodeBase64() function https://docs.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions#conversion-functions but I do not know how to use it while copying.