How to resolve the Spotfire Statistica error: "Write Spreadsheet To Database: Overflow" using the "Write Spreadsheet to Database" node
Article ID: KB0138226
Updated On:
| Products | Versions |
|---|---|
| Spotfire Data Science - Statistica | 14.x and higher |
| Spotfire Statistica | 14.x and higher |
Description
When writing data to a database using the "Write Spreadsheet to Database" node, the following errors can occur:
Environment
OS: Windows
Resolution
Before writing data from Statistica to a database, consider reducing the number of columns (variables) by 1) filtering or 2 ) subsetting the data.
Resolution One
There are several filtering nodes available for filtering data:
Resolution Two
Subsetting options:
Typical use is to subset by variable, i.e., removing unnecessary variables:
Maximum Column Limits by Database
| Database | Standard Table Limit | Special Table Limit / Conditions |
| Microsoft SQL Server | 1,024 | Up to 30,000 using "Wide Tables" (Sparse Columns). |
| Oracle Database | 1,000 | Up to 4,096 in Oracle 23c+ (Wide Tables feature). |
| PostgreSQL | 1,600 | Limited by the 8KB page size; actual count depends on data types. |
| MySQL | 4,096 | 1,017 for InnoDB engine; also restricted by the 65,535-byte row size. |
| Snowflake | Unlimited* | While technically unlimited, Snowflake recommends staying under 1,000–2,000 for performance. |
| Starburst (Trino) | Connector Dependent | Limited by the underlying source (e.g., if querying Hive, the limit is ~32,767). |
| SQLite | 2,000 | Can be increased up to 32,767 at compile time. |
*Though techncially the number of rows is "unlimited", performance degrades with large tables.
Issue/Introduction
How to resolve the Spotfire Statistica error: "Write Spreadsheet To Database: Overflow" using the "Write Spreadsheet to Database" node
Additional Information
Was this article helpful?
Yes
No
Powered by
