Error in copy activity with Oracel 2.0

I am trying to migrate our copy activities to Oracle connector version 2.0. The destination is parquet in Azure Storage account which works with Oracle 1.0 connecter. Just switching to 2.0 on the li...

martin_larsson_ellevio
May 19, 2025
I need to add to this that the solution to my situation was to add the following line to the Parquet dataset json code:
"useParquetV2": true
at the same level as compressionCodec
in combination with adaardor suggestion with "Support V1 data types" above. Without it the Parquet file could not be read by Databricks with the error that decimal precision of 256 is not allowed, max 38.
Full code for Parquet dataset:
{
"name": "Lake_PARQUET_folder",
"properties": {
"linkedServiceName": {
"referenceName": "DataLake",
"type": "LinkedServiceReference"
},
"parameters": {
"source": {
"type": "string"
},
"namespace": {
"type": "string"
},
"entity": {
"type": "string"
},
"partition": {
"type": "string"
},
"container": {
"type": "string",
"defaultValue": "raw"
}
},
"folder": {
"name": "Data Lakes"
},
"annotations": [],
"type": "Parquet",
"typeProperties": {
"location": {
"type": "AzureBlobFSLocation",
"folderPath": {
"value": "@concat(dataset().source, '/', dataset().namespace, '/', dataset().entity, '/', dataset().partition)",
"type": "Expression"
},
"fileSystem": {
"value": "@dataset().container",
"type": "Expression"
}
},
"compressionCodec": "gzip",
"useParquetV2": true
},
"schema": []
},
"type": "Microsoft.DataFactory/factories/datasets"
}

martin_larsson_ellevio
Brass Contributor
May 13, 2025
Now I have tried it and it works!! Thank you
- martin_larsson_ellevio
  Brass Contributor
  May 19, 2025
  I need to add to this that the solution to my situation was to add the following line to the Parquet dataset json code:
  "useParquetV2": true
  at the same level as compressionCodec
  in combination with adaardor suggestion with "Support V1 data types" above. Without it the Parquet file could not be read by Databricks with the error that decimal precision of 256 is not allowed, max 38.
  Full code for Parquet dataset:
  {
  "name": "Lake_PARQUET_folder",
  "properties": {
  "linkedServiceName": {
  "referenceName": "DataLake",
  "type": "LinkedServiceReference"
  },
  "parameters": {
  "source": {
  "type": "string"
  },
  "namespace": {
  "type": "string"
  },
  "entity": {
  "type": "string"
  },
  "partition": {
  "type": "string"
  },
  "container": {
  "type": "string",
  "defaultValue": "raw"
  }
  },
  "folder": {
  "name": "Data Lakes"
  },
  "annotations": [],
  "type": "Parquet",
  "typeProperties": {
  "location": {
  "type": "AzureBlobFSLocation",
  "folderPath": {
  "value": "@concat(dataset().source, '/', dataset().namespace, '/', dataset().entity, '/', dataset().partition)",
  "type": "Expression"
  },
  "fileSystem": {
  "value": "@dataset().container",
  "type": "Expression"
  }
  },
  "compressionCodec": "gzip",
  "useParquetV2": true
  },
  "schema": []
  },
  "type": "Microsoft.DataFactory/factories/datasets"
  }
  - Ace_Is_On_The_Case
    Copper Contributor
    Jan 27, 2026
    I don't see this parameter ("useParquetV2": true) being mentioned in MS ADF documentation.
    https://learn.microsoft.com/en-us/azure/data-factory/format-parquet
    How did you get to it ? Where is it mentioned ? ....and ...what does it do ?
    
    --------
    BTW, worked for me - great ! Thanks !
    However, the property for Oracle connector is "supportV1DataTypes" (without spaces that are seen in the screenshot)
    can be found in adf documentation: https://learn.microsoft.com/en-us/azure/data-factory/connector-oracle?tabs=data-factory#linked-service-properties

Forum Discussion

Error in copy activity with Oracel 2.0