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