How to get CSV output from Look Up table activity

Sudarshan Kumar 20 Reputation points
2024-02-11T06:04:03.7766667+00:00

How can we get CSV output from Look Up table and and Copy Data activity . I have Look activity followed by Copy Data The output from LookTable activity is below which is a JSON and we need in CSV format . Can some help me get this output please ?

{
	"count": 1,
	"value": [
		{
			"f_ID": 71431952,
			"f_Ctb": 8888,
			"f_isProtected": null
		}
	],
	"effectiveIntegrationRuntime": "selfhostedintegrationRuntime1",
	"billingReference": {
		"activityType": "PipelineActivity",
		"billableDuration": [
			{
				"meterType": "SelfhostedIR",
				"duration": 0.016666666666666666,
				"unit": "Hours"
			}
		],
		"totalBillableDuration": [
			{
				"meterType": "SelfhostedIR",
				"duration": 0.016666666666666666,
				"unit": "Hours"
			}
		]
	},
	"durationInQueue": {
		"integrationRuntimeQueue": 0
	}
}
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,139 questions
0 comments No comments
{count} votes

Accepted answer
  1. Suba Balaji 10,936 Reputation points
    2024-02-11T08:28:26.6933333+00:00

    @Sudarshan Kumar hi, You are right. If you want to read from a table and write to a file, copy data activity is the easiest option. Simply point your source to SQL table you want to lookup, and sink can be a CSV file in Azure storage. As per the q&a guidelines, original poster cannot accept his or her own answer. So I'm reposting your answer here, so that this thread can be accepted and closed.

    You should use copy data activity directly.

    Please accept this as answer and help the community with similar question. Thanks


0 additional answers

Sort by: Most helpful