Specifies whether the provider enforces the row-scan limit with a TOP clause when determining column metadata for a table.

Data Type

bool

Default Value

false

Remarks

This property applies only when Schema is set to SuiteQL, and it affects only column-metadata discovery.

• When set to false, the component performs a row scan of the form SELECT * FROM <table> and limits the scanned rows through paging. This is the default behavior.
• When set to true, the component builds the row-scan query with a TOP clause, SELECT TOP 1000 * FROM <table>. The TOP value can be controlled by the RowScanDepth property with the default being 1000.

Enable this property for wide analytics views, such as transactionLine, where the default unbounded row scan is rejected by NetSuite.