Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,704 questions
Moving data from one storage account to another using stream analytics is creating duplicate data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 38%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER7%3C/text%3E%3C/svg%3E)
RossPerry-7177
0
Reputation points
Hi,
I'm using Azure databricks for data analysis and have data going into a gen2 datalake storage account which then gets moved to another using the 'write once' mode on the output.
What I'm seeing is that data in the second account seems to be duplicating (all columns are the same) when I'm only using a simple query to move the data e.g. 'SELECT * into your_output From your_input'
What could be the cause of this? is it the write mode or something else?
Transact-SQL
Sign in to answer