Global Transformation DateTime Offset - Replicate

ResMed_LesB — Fri, 13 Nov 2020 20:19:43 GMT

We have a use case where a downstream pipeline is dependent on datetime columns transformed to datetime offset . Currently the only way to do this in is to do the transformation at the table level. This is not scalable and is not able to easily allow schema additions or changes with datetime data types without precarious communication processes. The lack of global transformation to this data type is preventing us from using as our data integration tool and we have to rely on the current AWS service we purchased to replace. We're currently forced to go to production using the AWS services next week and have lost some credibility within our stakeholder community.

Example:

Source system - 2020-01-30 00:00:00.000
Preferred output - 2020-01-30T00:00:00.000Z

Re: Global Transformation DateTime Offset - Replicate - Status changed to: Delivered

Shelley_Brennan — Thu, 17 Dec 2020 15:11:07 GMT

Thank you for the feedback. This feature will be generally available in April 2021.

idea Re: Global Transformation DateTime Offset - Replicate - Status changed to: Delivered in Suggest an Idea

Global Transformation DateTime Offset - Replicate

Re: Global Transformation DateTime Offset - Replicate - Status changed to: Delivered