Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Why are ADF data flows creating tables and don't delete them after (using MySQL)?
Gagné, David
0
Reputation points
I'm using Azure Data Factory. The data flows are creating what looks like temporary tables in the database and these tables are never deleted. There are more and more tables. I can easily drop them but that's not very convenient. My database is MySQL and there is no "use tempDB" option in the sink transformation. Is this a normal behaviour?
Azure Data Factory
{count} votes
-
![](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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator2023-11-15T23:28:14.1366667+00:00 @Gagné, David Welcome to Microsoft Q&A forum and thanks for reaching out here.
To better assist on this query, could you please help confirm if your MySQL is regular MySQL or Azure Database for MySQL?
-
Gagné, David 0 Reputation points
2023-11-16T01:44:07.52+00:00 Hello, it’s Azure database for MySQL.
-
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
2023-12-12T05:05:01.0366667+00:00 Hi there, I tried the same in my environment and haven't noticed this behavior. Are you still experiencing this this issue or was it resolved? If the issue persists, could you please confirm your ADF and Azure database for MySQL region, so that I shall try to replicate the same on my end.
Thank you
-
Gagné, David 0 Reputation points
2023-12-12T15:46:02.94+00:00 I'm still experiencing the issue. And the Azure database for MySQL region is East US.
Sign in to comment
Sign in to answer