This is the error:
SQL compilation error: error line 2 at position 1 Invalid argument types for function 'IFF': (VARCHAR(3), VARCHAR(3), VARCHAR(2))
This is what causes it:
dimension: is_transient {
type: yesno
sql: ${TABLE}.IS_TRANSIENT ;;
description: "Whether the database is transient"
}
"yesno" should be changed to "string", the Snowflake field is VARCHAR(3) not BOOLEAN, doesn't need conversion