SMALLINT type
Applies to: 
Databricks SQL Databricks Runtime
Represents 2-byte signed integer numbers.
Syntax
{ SMALLINT | SHORT }
Limits
The range of numbers is from -32,768 to 32,767.
Literals
[ + | - ] digit [ ... ] S
digit: Any numeral from 0 to 9.
The postfix S is case insensitive.
Examples
SQL
> SELECT +1S;
1
> SELECT CAST('5' AS SMALLINT);
5