What is the best way to write to the blobstorage?
At present, I have an audit mechanism where I use a copy activity to write some log details into blobstorage container in parquet format. So in the sink I have the dataset pointing to the blobstorage container. In the mapping I capture the PipelineName. so the audit only contains the pipelinename.
As you see I am using a copy activity which requires source. And to get this to work I connect to the sql server and in the sql query I just put select 1 so that there is no error.
Is copy activity the only activity to use for this simple audit capture?