ADF Mapping Data Flows: Alter Row Transformation

[@kenichisegawa3981]

How do you allow delete in the sink for file type scenario by using alter row transformation? Is there any link or documentation for that?

[@harithamarripudi5622]

Hi, sir. Could you please help me with connecting/sending the ADLS, containing delta Parquet data, to MySQL Server as an SQL table using data flow in Azure

[@zikoraswrld]

How do I include a timer trigger in the data set to periodically delete specific rows

[@bobreddert7547]

Good tutorial. However I got to the end thinking that UPSERT would also be covered (it was not)

[@NeumsFor9]

Any idea what would cause a "code not found for stream" error?

[@fun_facts168]

Linked service with Self-hosted Integration runtime is not supported in data flow. Please utilize the Azure IR with managed vnet I am getting this error while accessing sql from data flow can you please help me how can I fix?

[@Alicia_BPHC]

Thank you 🦋

[@PatrickAlexanderThePilot]

Can SQL Table be created dynamicly and based on the source file ?

[@kromerm]

Yes. In the Destination Sink dataset, type in a new name for your target table and one will be created using that name and the schema of the incoming data stream.

[@ShanmugarajRaja]

@@kromerm Can you share a link for this description

[@MSDataFactory]

@@ShanmugarajRaja In your SQL dataset, in the "Table" field, click "Edit" and then type in the name of the table you wish to create. You can also parameterize this field and use dynamic content to generate table names on the fly. docs.microsoft.com/en-us/azure/data-factory/connector-azure-sql-database#dataset-properties

[@ricardomerin8688]

how to delete in target the rows that not exists in source? Delete if...?. thank you

[@DrDiabolical000]

Thanks a lot man!

[@nitindamle5380]

How to do Update on columns base on some condition in same table (source and destination table is same)

[@MSDataFactory]

Use datasets for your Source and Sink that point to the same table. Set the key column in your Sink and turn on "Allow updates" on your sink. Then create an update expression in your Alter Row transformation that defines your criteria. Think of the Alter Row policy as your WHERE clause in a SQL UPDATE statement. docs.microsoft.com/en-us/azure/data-factory/data-flow-alter-row

[@vicvic553]

how to change a numeric value, integer fo example? how to reassing a value? by =, ->, => it doesn't work...

[@MSDataFactory]

Use the Derived Column transformation to modify an existing value