Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Regarding stream state... on startup, will we get the all state transitions for a given stream, or just the last state?

On startup, you will receive the last state for a given stream. The `state` table in the Config Database represents the current (last) state for a connection. Depending on the type of state (Stream, Global, or Legacy), the schema of the state JSON blob will be different. The state object is passed to the Source on startup, allowing the Source to decide how to track the state of each stream.  For more information, refer to the [Config Database documentation](<https://docs.airbyte.com/understanding-airbyte/database-data-catalog#config-database>).