Its odd that what they return seems to flip back and forth. Sometimes is does use the column label. Whenever it is returned as concat data values, there is a corresponding NAMEINSOURCE option that has the correct column label.

Is there any way to detect that and force it to use the column label?

problems with DDL returned for dynamic vdb with google spreadsheet source ------------------------------------------------------------------------- Key: TEIID-2998 URL: https://issues.jboss.org/browse/TEIID-2998 Project: Teiid Issue Type: Bug Security Level: Public(Everyone can see) Components: AdminApi Affects Versions: 8.7 Reporter: Mark Drilling Assignee: Steven Hawkins Attachments: ChromeSheet.png, FirefoxSheet.png, GoogleSpreadsheetJIRA.txt I am seeing inconsistent DDL returned for dynamic VDB with a google spreadsheet source. In the same google account, I created two spreadsheets. One was created in firefox browser, one was created in chrome browser (don't know why that matters) See the attached document showing a comparison of the dynamic VDBs and the DDL that I got back. The only difference is that the source was pointing to a different spreadsheet. Notice that the DDL for the "ChromeSheet" returns the concatenated datavalues for the column name. But it includes a NIS OPTION for the column name.