[teiid-issues] [JBoss JIRA] (TEIID-5040) Add translator override to change the Google spreadsheet

[ https://issues.redhat.com/browse/TEIID-5040?page=com.atlassian.jira.plugi... ] Steven Hawkins updated TEIID-5040: ---------------------------------- Original Estimate: 5 hours Remaining Estimate: 5 hours Git Pull Request: https://github.com/teiid/teiid/pull/1285 Story Points: 1 Sprint: DV Sprint 65 It seemed like a good idea to try and tackle this before pulling the functionality into teiid spring boot. The proposed change is to add a config property spreadsheetMap that will take a url like key/value pair list - prefix1=sheetid1;prefix2=sheetid2... This precludes the teiid name prefix from containing = or ;, but that seems acceptable. On import we'll add the each worksheet as prefix + sheet title. That ensures there can be no collisions across spreadsheets. If the user specifies on spreadsheetId in the config, it will still work as before and import with an empty prefix. The functionality is only added for the v4 api. On a side note it an alternative design to the current is to use extension metadata on each table representing a sheet - we need to know the sheet id, work sheet id, and title (which could default to the table name). That would allow the translator to work more independently of the source. A reason for not doing that possibly is so that you could differentiate between different sheets (testing vs. prod) by just changing a source property, rather than adjusting the metadata. -- This message was sent by Atlassian Jira (v7.13.8#713008)