How is it compatible? If NAMEINSOURCE is not defined for column, generated N1QL is missing back quotes (`) around ShortValue which, from my testing, does not work.

From the Couchbase documentation it appears that it should be compatible. Can you provide more details, like the exception, from a failing case?

In fact, after talking with other QE we would not recommend using NATIVE metadata for Couchbase.

Do you think how can we do some enhance to make this more clear?

Couchbase - NAMEINSOURCE required for all the columns and tables ---------------------------------------------------------------- Key: TEIID-4928 URL: https://issues.jboss.org/browse/TEIID-4928 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 9.3 Reporter: Juraj Duráni Assignee: Kylin Soong Option *NAMEINSOURCE* is de facto required for all the columns and tables. If it is not present then: # column name in source query is not enclosed in back quotes - e.g. *`$cb_t1`.ShortValue* instead of *`$cb_t1`.`ShortValue`* # name of the table is not added to the source query - e.g. *SELECT ... FROM null `$cb_t1` LET ... WHERE ...* instead of *SELECT ... FROM `smalla` `$cb_t1` LET ... WHERE ...* This should work OOB without need to add NAMEINSOURCE option. Teiid should automatically translate column name from e.g. *MyColumn* to *`MyColumn`* if option is not set. Same with name of the table. In case of table I think this is more serious as it does not even try name of the table but supplies *null* to the query