Remove the square brackets and ensure all your tables in the Openquery string

SELECT *

FROM OPENQUERY([LINKED_SERVER], 'SELECT * FROM DATABASE.SCHEMA.TABLE LIMIT 10')