Limits on Treasure Data

Below are some of the commonly asked limits on Treasure Data.

# Property Limit Comment
1 Console user password 8-128 characters
2 Database name 128 chars Error:
Name is too long must be between '3 and 128 characters long'
3 Table name 128 chars Error:
Name is too long (maximum is 128 characters)
4 Column name 128 chars Error:
Validation failed: Schema SQL column alias 'column_name'
must be same or shorter than 128 characters
5 # of Databases No Limit
6 # of Tables No Limit
7 # of Users No Limit
8 # of columns in a table 4096
9 # of imported columns (Streaming) 512
10 # of imported columns (Bulkimport & Dataconnector) 4096 if exceeded, further records are skipped
11 # of bulkimport sessions 2,448
12 Schema size 16,777,215 chars This character limit includes name of the column,
datatype and any SQL alias name in table schema

NOTE: assuming 1 byte characters
13 Result download size (via Browser) 50 MB
14 Result download size (via td CLI) 16 GB Error:
TreasureData::API::IncompleteError:

Last modified: May 20 2016 09:29:50 UTC

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels.