Skip to main content

Pentaho+ documentation has moved!

The new product documentation portal is here. Check it out now at


Hitachi Vantara Lumada and Pentaho Documentation


Parent article

The SQL expression for a particular database dialect.


AttributeData TypeDefinition
dialectStringDialect of SQL the view is intended for. Valid values include, but are not limited to:
  • generic
  • access
  • db2
  • derby
  • firebird
  • hsqldb
  • mssql
  • mysql
  • oracle
  • postgres
  • sybase
  • teradata
  • ingres
  • infobright

Constituent Elements