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

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

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.

> Add translator override to change the Google spreadsheet
> --------------------------------------------------------
>
>                 Key: TEIID-5040
>                 URL: https://issues.redhat.com/browse/TEIID-5040
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: Misc. Connectors
>            Reporter: Deborah Steigner
>            Assignee: Steven Hawkins
>            Priority: Major
>             Fix For: 15.0
>
>   Original Estimate: 5 hours
>  Remaining Estimate: 5 hours
>
> We would like to add a "sheet name" override to the googlesheet resource adapter. So we can configure multiple google sheets without having to configure multiple resource adaptors (1 for each google sheet.)



--
This message was sent by Atlassian Jira
(v7.13.8#713008)