INFOBRIGHT: Derived Tables in Infobright

[swhite]

Knowledge Drop

Last tested: Dec 5, 2019

Looker doesn't support PDTs in Infobright.

If you want to have DTs (ephemeral, not persistent), you will need to use a workaround where the SQL query is written in the sql_table_name parameter:

view: derived_table {

sql_table_name: ( SELECT * FROM table ) ;;

dimension: id {...}

...

}

This content is subject to limited support.