title: Copy json data from Azure cosmos db to Azure sql using Azure Data Factory
body: <p>I am using Azure Data Factory V1. We want to copy the json data stored as documents from Azure cosmos to a azure sql table, using a copy activity.</p>
  
  <p>I figured out copying the data by specifying the columns in sql table to match the property names from json. However our goal is to copy the entire json data as a single field. We are doing this for the purpose of being agnostic to the schema within the json data.</p>
  
  <p>I have tried specifying a single nvarchar(max) column to store the json data, and the query on the copy activity to be "select c as "FullData" from c". But the copy activity simply generates a NULL. </p>
  
  <p>I think this is because "FullData" is of type json on the document end and it is string on the sql end. I also tried to convert the json object to string within the cosmos db query. But I couldnt find any API to do so.</p>
  
  <p>I know we could write a custom activity to accomplish what I want to do, but is this possible to do with ADF out of the box functionality?</p>