Also, why wouldn't you use the following?

INSERT INTO REDSHIFT64.databasename.testschema.testoperation

(viasatsubscriptionID, subscriptionrowdate,

phonenumberday, viasatcustomerid)

SELECT viasatsubscriptionID, subscriptionrowdate,

phonenumberday, viasatcustomerid

FROM rdata.dbo.testoperation