none
Usql query

    Question

  • Below is a Usql query written in Azure Data Lake Analytics for fetching data from data.csv (Which is stored in Azure Data Lake) and again saving the data received to a new file newdata.csv (Which is again stored in Azure Data Lake) .
    @a  = EXTRACT customer string  FROM "/data.csv"
     USING Extractors.Csv();
    OUTPUT @a
        TO "/newdata.csv"
        USING Outputters.Csv();
    But now I want to write a Usql Query in  Azure Data Lake Analytics for fetching data from data.csv (Which is stored in Azure Data Lake) and this time output is Azure SQL DB table.
    So I am not getting how to write the U sql query for it.
    Could you please write it down and let me know.
    Thursday, August 3, 2017 3:33 AM

All replies

  • A U-SQL query cannot write to SQL DB directly. Instead you should (1) generate the data you want in Data Lake Store as a CSV and then (2) use the Copy Activity in Azure Data Factory to copy the data in the CSV to Azure SQL DB


    Thursday, August 3, 2017 12:29 PM
    Moderator