I Have question about Azure Data Factory Expression for function IF in SQL we can create using CASE WHEN 'A' Then 1 when 'B' then 2 when 'C' then 3 else 100 is this correct expression to IF? @if(equals(variables('varInput'), 'a'),…
I am using odbc connector to connect to AS400 DB2 system. I am fetching metadata from copy activity and it is throwing the following error. Failure happened on 'Source' side. ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [IBM][System i Access ODBC Driver][DB2 for i5/OS] -…
I have a JSON type SQL column in SQL table as below example. I want the below code to be converted into separate columns such as drugs as table name and other attribute as column name, how can I use…
The problem is after each row is inserted I need to store the identity and update again it in the source. How is it possible in ADF, in ssms we can use identity_insert? in first database, i have a table…
I have input col as 12/03/08 viz dd/MM/yy . So I beed it in the format of dd/MM/yyyy . SO I have use the below transformation as : toString(toDate(col,'dd/MM/yy'),'dd/MM/yyyy') This works fine. But at the end i need to conver…
I need to convert the YYYYMM to YYYY-MM-01 using azure data factory pipeline expression. I tried the below expression but it giving me error that date value should follow the ISO 8601 format. @formatDateTime(concat('202301','01'),'YYYY-MM-DD') It should return in this format…
I have data in one storage acc in dev subscription. I need to move the data to other storage acc in other subscription. Is there any way to do this by ADF by copy activity?
I need to Maintain Folder Structure to store files in yyyy/MM/DD format and I am getting date like this "2021-12-01T00:00:00Z" I need to Extract year from the date and to store in one variable and need to extract Month from…
I am using the below code to get some information in the Azure Databricks notebook, but runOutput isn't appearing even after the successful completion of the notebook activity. Code that I used. import json dbutils.notebook.exit(json.dumps({ "num_records" : dest_count, "source_table_name" :…
Validation Error I've got this weird issue where validation fails on 'additional columns' for my data sink to Azure SQL coming from a blob storage source in the Azure Data Factory GUI. No matter how many times we recreate the…