Azure Data Factory: "Quote all text" inactive in Copy Data activity
I have an existing working pipeline in ADF. However, output CSV file in the storage container has every value enclosed in double quotes. I need to get rid of double quotes.
I presume, this happens because "Quote all text" option in the Sink tab is ticked in the Copy Data activity. I am unable to untick it as it seems inactive:
Any ideas will be highly appreciated.
Solution
To remove all double quotes from the Data that is inserted into CSV you need to set the Quote character as No Quote character. Then it will not add quotes to the text.
Output for sample data:
- Trouble Passing Boolean Values in Azure Data Factory JSON Template
- Check if two files are existing in SFTP using ADF
- Using parameters and dynamic content in pre-SQL script for Azure Data Factory data flow sink transformation
- The Format of Body for a POST request in Web Activity in Azure Data Factory
- adf skip line count issue with csv having empty string
- How can I get the last day of a month in dynamic content in ADF2?
- How to use Azure Data Factory to take Business Central data and put into Azure SQL DB?
- Azure Data Factory (ADF) validate data types from incoming csv
- Running Code in Azure Repo from Azure Data Factory
- Data Filtering Issues
- How to generate .jmx file for ADF pipeline
- Azure Data Factory (ADF) create an alert to notify me when a pipeline is triggered
- Azure Data Factory (ADF) trying to delete a csv file. Error Invalid delete activity payload with 'folderPath' that is required and cannot be empty
- ADF Script Object using Snowflake Connector doesn't allow script parameters
- ADF Pipeline Scheduled Hourly Fails Occasionally with Lookup Activity Fetching Last Ingested Date from Databricks Catalog
- Suddendly error in CI CD Azure Data Factory and AzureDevOps
- Migrating current legacy driver to the latest version on ADF link service
- Fabric datafactory copy data to ingest Sharepoint files
- adf collection reference with 1 row
- Creating a ADLS Linked Service with Bicep for a Blob Container?
- Dataset parameter not available in Copy Data Activity (source tab)
- How to retrieve a List of Pipelines in azure data factory for a Specific Branch?
- How to pass an array parameter into an ADF dataflow
- How to replace a single quote with double quotes in ADF dynamic expressions
- Azure Data Factory (ADF) Is it possible to compare the schema of a .csv file against the schema of a database before writing to it
- Azure Data Factory: "Quote all text" inactive in Copy Data activity
- ADF Script Creating a Table with Parquet format using INFER_SCHEMA in Snowflake
- Azure Data Factory (ADF) Failed starting trigger after 5 attempts
- Azure Data Factory (ADF), create a csv dataset that has dynamic file path
- ADF how to set timeout dynamically in stored procedure