Azure Data Factory Pipeline Sink from Azure SQL to MongoDB Atlas – DateTimeOffset being stored as string in Atlas
I have an Azure ADF pipeline which selects a delta of records from a table, of which some columns are DateTimeOffset columns. The sink is doing an upsert into a MongoDB Atlas collection. The value being stored in MongoDB is being stored as a string value instead of the required mongodb date value.