ADF load empty strings as null using Polybase

Question

{
"name": " ",
"properties": {
"activities": [
{
"name": " ",
"type": "Copy",
"dependsOn": [],
"policy": {
"timeout": "7.00:00:00",
"retry": 0,
"retryIntervalInSeconds": 30,
"secureOutput": false,
"secureInput": false
},
"userProperties": [],
"typeProperties": {
"source": {
"type": "SqlServerSource",
"queryTimeout": "02:00:00",
"partitionOption": "None",
"treatEmptyAsNull": false
},
"sink": {
"type": "SqlDWSink",
"allowPolyBase": true,
"polyBaseSettings": {
"rejectValue": 0,
"rejectType": "value",
"useTypeDefault": false,
"treatEmptyAsNull": false
}
},
"enableStaging": true,
"stagingSettings": {
"linkedServiceName": {
"referenceName": "LS_BlobStorage",
"type": "LinkedServiceReference"
},
"enableCompression": true
},
"translator": {
"type": "TabularTranslator",
"mappings": [
{
"source": {
"name": "nvc_city",
"type": "String"
},
"sink": {
"name": "nvc_city",
"type": "String"
}
}
]
}
},
"inputs": [
{
"referenceName": " ",
"type": "DatasetReference"
}
],
"outputs": [
{
"referenceName": " ",
"type": "DatasetReference"
}
]
}
],
"folder": {
"name": "Scratch"
},
"annotations": [],
"lastPublishTime": "2021-01-18T05:39:39Z"
},
"type": "Microsoft.DataFactory/factories/pipelines"
}

Answer 1

Hello @FionaHu and welcome to Microsoft Q&A.

If you want to load empty strings as null, then there is one change you need to do in the code your shared:

"treatEmptyAsNull": false  

change to:

"treatEmptyAsNull": true  

If this solves your issue, please mark as accepted answer. If not, please explain better your ask.