Hi EM Folks,
I have a project that exports 78 tables into flat files that are imported into our analytics warehouse. My issue is that the warehouse doesn’t seem to recognize the timestamp format correctly. Is there a way without having to create 78 actions that would let me change the data type of the column if it is a timestamp column?
My initial thought was to somehow attack this using table metadata but not sure if that is going to lead me down a rabbit hole or not, your thoughts as to the best approach?