[DRILL-8395] Add Support for INSERT and Drop Table to GoogleSheets Plugin

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.3
• Fix Version/s: 1.21.0
• Component/s: Storage - GoogleSheets
• Assignee: Charles Givre
• Reporter: Charles Givre
• Created: 05/Feb/23 16:30
• Updated: 14/Feb/23 15:01
• Resolved: 14/Feb/23 15:01

Description

This PR adds support for INSERT queries which allow a user to append data to an existing GoogleSheets tab.  It also:

• Adds support for DROP TABLE queries which were not implemented
• Modifies CTAS queries so that if a user executes a CTAS query with a file token, Drill will add a new tab to an existing document, but if the user executes a CTAS with a file name, it will create an entirely new document.