Google Spreadsheet Connector Overview

Google Spreadsheets is an online spreadsheet app that lets users create and format spreadsheets and simultaneously collaborate.

Features & Capabilities

  • Backfill: Full historical sync of your entire data
  • Data Extraction Modes: Only snapshot mode is supported
  • Data Load Modes: replace, append and merge
  • Tables and Columns selection: With google sheets connector, the destination tables can be loaded as per the selected range from the input spreadsheet
  • Data-layout: The connector by default treats all columns as strings. Apart from string, integer, and timestamp data types are supported
  • Customizations: Update the configurations easily using the UI and CLI
  • Scheduling: Highly flexible scheduling system for any frequency over 5 minutes

Read more about our Features and Capabilities in the next tab

Connector output

  • Output of this connector is stored in S3 and the destination warehouse. The stored data in AWS S3 is partitioned by date and time s3://customer_installation.datacoral/<connector-name>
  • Destination Warehouse Schema - schema name will be same as the connector name
  • A table will be produced for each loadunit added

Next Steps

Additional Information

Got a question?

Please contact Datacoral's Support Team, we'd be more than happy to answer any of your questions.