Arm Treasure Data limits how you name entities, and the number of characters you can use in entities.
Also refer to Upper Limits (MAX) for size and volume limits on Treasure Data entities.
Naming Conventions
Name rules exist for:
- Tables
- Databases
- Columns
- User passwords
- User names
- Account policies
- Account permissions
Tables and Databases
Name rules for tables and databases are as follows:
- only lower case letters, numbers, and the _ (underscore)
- 3 and 255 characters long
Columns
Name rules for columns are as follows:
- only lower case letters, numbers, the _ (underscore)
- cannot begin with a number, for example:
0422colis not an acceptable column name
If an illegal column name is detected, a system alias is generated. You can use this alias to query or change this column to another acceptable column name, if you want to.
Passwords
The TD account owner or administrator specify password criteria.
The general, default rules for user passwords are as follows:
- 8-128 characters long
- consists of Basic Latin (ASCII) characters
For a list of Basic Latin (ASCII) characters, go to the Library of Congress Basic Latin (ASCII) Code Table.
Names for Users, Policies, and Permissions
User and Policy names must be unicode characters and can include symbol, control characters, emoji, whitespace, up to 255 characters.
Comments
0 comments
Please sign in to leave a comment.