This also works and skips the view creation

SELECT * INTO [REMOTEDB].[SCHEMA].[NEW_TABLE]
FROM OPENQUERY([REMOTESERVER],'SELECT * FROM [REMOTEDB].[SCHEMA].[TARGET_TABLE]');
GO