I'm facing an intermittent issue with one automation. A month ago I received a message from SFMC reporting a timeout error in one Automation, but then I re-run the automation the error doesn't show up...until yesterday.
I have three queries in the Automation, one export and one import activity. All the queries follow the this structure:
SELECT Sub_ID ,Field1 ,Field2 ,Field3 ,Field4 ,Field5 ,Field6 ,Field7 ,Field8 ,NEWID() AS PrimaryKey ,Field9 ,Fielda ,date_1 ,date_2 ,date_3 ,Fieldb ,Fieldc ,date_enter ,date_4 ,date_5 FROM [Data_extension]
*I changed the names of the fields but that is the full structure. The amount of data is bigger than 50 million so I believe this needs to be optimized.
Any suggestion? Thanks a lot for the help