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:
- How to save error details in Set Variable activity if any sequential activity fails
- How to specify only the necessary files from the retrieved file names and sort them
- org.apache.parquet.schema.InvalidSchemaException:Cannot write a schema with an empty group
- Mapping Data Flow Expresson (IIF and IN)
- Azure Synapse CSV Parsing Unexpected Token
- Facing error in azure data factory ("copy activity pipeline") multiple concurrent copy activities runs
- Failure of azure data factory integration runtime with Vnet enabled
- Combining two arrays in a pipeline in Azure Data Factory
- String To DateTime Error in Azure Data Factory [Type conversion settings]
- I want to find all upcoming Fridays in the format `yyyyMMdd` using an Azure Data Factory expression
- Access denied to server in File System Linked Service in Data Factory
- Ingest Yahoo Finance data with Azure Data Factory
- Getting the deployment template exceeds the resource limit of 800 in Azure devops pipeline for Datafactory
- Azure blob-to-SQL automatic copy
- How to get error details logs in log analytics workspace for synapse analytics workspace
- CICD of data factory
- Zero padding a number in dynamic file name with dynamic expression
- How do I include an ADF parameter in the source data for a Copy Data activity?
- How does Azure Purview perform Data Lineage in Azure Data Factory when there are multiple Copy Data Activities on the same Source?
- ADF script/Copy activity not replacing parameter value at runtime
- How to dynamically select given columns from a SAP CDC linked service?
- Checking if a value is 0 and replacing it with NULL in Azure Data Factory
- Azure Data Factory error when ingesting from Mysql
- Azure Data Factory: Accessing a variable value set inside a Switch activity outside of the Switch in the same pipeline
- JSON restructuring using ADF
- How to get date String output from stored procedure?
- Azure Data Factory - data flow expression unexpectedly scrambled
- Azure Data Factory - Suggested way for ADF to trigger pipeline by SQL table change
- I'm using SSIS in ADF to move .csv from a blob container to another and then ingest into a Azure SQL database. I get an assembly error
- How to build expression in ADF from json using parameterized variable?