SPOOL - Teradata Vantage - Analytics Database

SQL Data Definition Language Syntax and Examples
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-11-06
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

Number of bytes to be allowed for spool and volatile temporary tables in database_name. The default is the largest value that is not greater than the immediate owner spool space and that is a multiple of the number of AMPs on the system.

n
Nonnegative integer, decimal, or floating point value. Can use exponential notation (for example, you can write one thousand as 1E3).
Cannot exceed the number of bytes in the SPOOL parameter in the profile of the owner. If no spool space is defined for that profile, then Vantage uses the spool space limit defined for the individual user-creator.
constant_expression
SQL expression without column references. Must have a nonnegative value that does not exceed the number of bytes in the SPOOL parameter in the profile of the owner. If no spool space is defined for that profile, Vantage uses the spool space limit defined for the individual user-creator.
Specifying an appropriate constant expression for SPOOL enables Vantage to assign an optimal quantity of spool space that scales to the size of your system by allocating spool space on a per AMP basis.
The assigned size does not automatically scale if, for example, you add AMPs to your system.
BYTES
Optional keyword that redundantly specifies the unit for the amount of space allowed.
SKEW
Keyword that you use to specify a skew limit for SPOOL space. You can specify a skew limit percentage that allows the maximum AMP space usage to be more than the per-AMP quota, that is, the system maximum space limit divided by the number of AMPs.
constant_expression
Constant expression or constant from 0 through 10000. Specify a value from 1 to 9999 to indicate an AMP-level limit, which is the per-AMP quota * (1+spoolskewlimit/100). Specify 0 to set space accounting to the per-AMP level, that is, no skew. A value of 10000 indicates unlimited skew, up to the system maximum space limit.
DEFAULT
Use the value of DBS Control DefaultSpoolSkewLimitPercent.
PERCENT
Optional keyword that you can include for readability to indicate that the constant_expression or DEFAULT keyword specifies a percentage of allowable skew.