Spotfire data size limits? (1.02 billion row table)

Having some issues loading one of my data from a SQL View. It is not loading all 1.02 billion rows.

1. Any recommendations? What is Spotfire's maximum loadable rows?

2. Which would be better load proceedure: Import Data Table or Keep data table external?

                      On some larger files, I noticed difficulty getting my filter scheme using keep table external.

I'd like to avoid creating smaller data sets to analyze different analysis components because of fewer drill down opportunties


Version: Tibco Spotfire Analyst

(1) Answer