@kapa.ai Is there a way for incremental load for Google Sheet

Yes, there is a way for incremental load for Google Sheets in Airbyte. According to the documentation, the Google Sheets source connector supports incremental sync modes. Specifically, the Google Sheets source connector supports the following sync modes: 1. Full Refresh - Overwrite 2. Full Refresh - Append 3. Incremental Append 4. Incremental Append-Deduplicate This information is provided in the [Features & Supported sync modes](https://docs.airbyte.com/integrations/destinations/google-sheets#features--supported-sync-modes) section of the Google Sheets destination connector documentation. It's important to note that while incremental sync is supported, Google Sheets has limitations on the amount of data it can handle. The documentation advises to use Google Sheets as a destination only for small, non-production use cases, as it's not designed for large-scale data operations [Google Sheets limitations](https://docs.airbyte.com/integrations/destinations/google-sheets#limitations). For more details on how incremental sync works in Airbyte, you can refer to the [incremental sync documentation](https://docs.airbyte.com/connector-development/connector-builder-ui/incremental-sync).

@kapa.ai Is incremental load possible with google sheet as a source and mssql as a destination for incremental load

A message from kapa.ai

Yes, incremental load is possible with Google Sheets as a source and MSSQL as a destination in Airbyte. For the Google Sheets source, it supports the following sync modes: 1. Full Refresh - Overwrite 2. Full Refresh - Append You can find this information in the [Supported sync modes](https://docs.airbyte.com/integrations/sources/google-sheets#supported-sync-modes) section of the Google Sheets source connector documentation. For the MSSQL destination, it supports the following features: 1. Full Refresh Sync 2. Incremental - Append Sync 3. Incremental - Append + Deduped 4. Namespaces You can find this information in the [MSSQL](https://docs.airbyte.com/integrations/destinations/mssql#mssql) section of the MSSQL destination connector documentation. However, please note that while Google Sheets supports Full Refresh sync modes, it does not explicitly mention support for Incremental sync modes. Therefore, while you can use MSSQL as a destination with Incremental sync modes, the source data from Google Sheets may only be synced in Full Refresh modes. For more details on how incremental sync works in Airbyte, you can refer to the [incremental sync documentation](https://docs.airbyte.com/connector-development/connector-builder-ui/incremental-sync).