Type Hints

Manual type hints allow users to specify an expression type that will override the automatically inferred type or provide one when automatic inference is not possible.

This may be useful when a type of an expression cannot be inferred or inferred incorrectly by the resolver which is necessary for type-safe conversion in specific situations.

During conversion Alchemist will notify when type hint is necessary and even create a configuration template for you.

Configuration

Field	Description	Default Value	Localizable	Environment Variable
type_hint_mapping	Mapping an expression node id to sql type.	Empty	No	None

List of valid types:

• STRING
• DOUBLE
• INTEGER
• BOOLEAN
• DATE
• TIMESTAMP

Example

resolver:
  type_hint_mapping:
    id1: STRING
    id2: INTEGER