What is the record limit for a remote table in servicenow

[sanga2]

HI all,

We have created a remote table to pull the data from an external source dynamically. However, only 1000 records are being created on the remote table, where as when we check the response from the REST message the data is more than 2000 records.

Please let me know if there is a record limit of 1000 on the remote tables?

[Priyanka Vasant]

Hi Sanga,

Find the below link that might help you.

Benefits of Remote Tables

Regards,

Priyanka

[sanga2]

Hi Priyanka,

Thanks for the reply. I have already checked it. But nowhere it is mentioned as limit of 1000 records there.

[Priyanka Vasant]

Its mentioned as “All data that is retrieved from the external source lives in the memory, so make sure that your data set is small. To minimize query times, don’t add more than 1000 rows to a remote table.”

[Ankur Bawiskar]

@sanga 

As per docs it is recommendation not to add more than 1000 rows to remote table.

I don't think any configuration allow us to change it to lower or higher value

Regards
Ankur