string_datatype

Usage

view: view_name {
  dimension: field_name {
    string_datatype: unicode
  }
}

Definition

The string_datatype parameter lets you specify that the dimension's string values are unicode characters, which is helpful for dialects requiring special filter handling. Specifically, you can specify string_datatype: unicode for Microsoft SQL Server and MySQL for fields that have filters with unicode characters. This applies to:

• Microsoft SQL Server (MSSQL) for non-Latin collations types
• MySQL for variable character (NVARCHAR) and fixed-number character (NCHAR) types

The string_datatype: unicode parameter applies only to dimensions of type: string (which is the default value for the type parameter).

Examples

dimension: comments {
  string_datatype: unicode
  sql: ${TABLE}.comments ;;