# Ingestion Methods

## Available Table Ingestion Methods

<div align="left"><img src="/files/-MUyD5__ytD9UIBNpfF_" alt=""></div>

### Full Data Sync

* The entire contents of the table is pulled every time on a regular schedule (with a minimum frequency of 1 hour).
* This is the least preferred method as it is accounts for a very large amount of data processed and is the heaviest performance hit on the server.

### Incremental Column Data Sync

* A column with a date or integer value is used to track data changed since the last scheduled query (usually every 5 to 60 minutes).
* Your application is responsible for updating that column with a new timestamp or value any time the data in that row changes.
* Typically, this method only tracks Insert and Update changes. Delete changes are often not tracked unless they are performed as Updates with null data for all columns.
* It is **highly recommended** that you create an index on the column used as the incremental column. This is especially important on very large tables (500K+ rows) to ensure ingestion happens quickly.

### Change Tracking (CT)

* A light-weight method built into some database engines using triggers that allows Verb to query only rows that have changed since the last query.
* This removes the need for your application to update an incremental value on the updated row.
* Generally, this tracks Insert, Update and Delete changes.

### Change Data Capture (CDC)

* A powerful transaction log driven function built into some database engines that uses commit logs or table-valued functions to enable querying of data that has been changed, added, or removed.
* As with CT, you will not need to maintain an incremental column.
* Tracks Insert, Update and Delete changes.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.verbdata.com/data-sources/ingestion-methods.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.