none
Stored Procedure with an input parameter of Array type

    Question

  • Hi Team

    I am working on U-SQL. I want to write a stored procedure in U-SQL to handle the duplicate records while loading a table in ADLA. I want to write it with Parameters so that One can use this procedure/function dynamically. The Parameters I am planning i are

    1. Data base name as String type

    2. Schema name as String Type

    3. Table name as String Type

    4.Column names as Array type (One or more columns can be part of the GROUP BY).

    I am actually looking for any reference in this context. If you come across any sort of this scenario, please do help me with your ideas. Thank you.

    Monday, July 16, 2018 1:02 PM

All replies

  • Hi SitaramNLN,

    ADFv2 can support you to achieve this goal. You need involve an U-SQL activity in pipeline, select the ADLA linked service, specify the store procedure script and then define parameters and pass value to the script parameters. Please see the picture below:

    For your reference: https://docs.microsoft.com/en-us/azure/data-factory/transform-data-using-data-lake-analytics#data-lake-analytics-u-sql-activity

    Thanks.


    Tuesday, July 17, 2018 2:28 AM