Using Query Database Smart Service

Hello friends,

I'm attempting to use the "Query Database" smart service to connect to an external database and I'm running into some issues. I've successfully connected to the external database and my select statement is a simple SELECT _____ FROM ______ but for some reason the query is only returning 1000 records even though I know the table I am querying has 603,000 records available. 

I was hoping someone might have run into a similar situation before and could shed some light on this problem.

Thanks

  Discussion posts and replies are publicly visible