> For the complete documentation index, see [llms.txt](https://docs.countercyclical.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.countercyclical.io/data-sources/airbyte.md).

# Airbyte

Sync accessible Countercyclical research records to your data warehouse or database through Airbyte.

<figure><img src="https://3856051622-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FuoSbSJEvJXClIRJg7TCt%2Fuploads%2F3QW994wxvgs4Q91ekcLw%2FAirbyte%20Banner.png?alt=media&amp;token=8115f397-1d66-4fa3-b5c0-e3c8585c6523" alt=""><figcaption><p>Airbyte &#x26; Countercyclical</p></figcaption></figure>

Use Airbyte to bring Countercyclical research records into a destination your team already uses, such as Snowflake, BigQuery, or PostgreSQL. In Airbyte, Countercyclical is the source where records are read, and the destination is where Airbyte writes them.

#### Connecting Airbyte

1. In Countercyclical, switch to the workspace you want to sync and open [**Settings › Workspace › Developers › API Keys**](https://dashboard.countercyclical.io/settings/workspace/developers/api). Create a dedicated API key for the connection.
2. In Airbyte, open **Sources › New Source**, select **Countercyclical**, and enter the key in **API Key**. Test and save the source.
3. Create or select your destination in Airbyte. Then create a connection from the Countercyclical source to that destination.
4. Select the streams you want, choose a supported sync mode and schedule, and run an initial sync. Check the connection’s status and confirm that the expected records appear in the destination.

#### Available Data

The source connector lists the following streams. Enable only those your reporting or data team needs.

| Stream      | Records                                                                  |
| ----------- | ------------------------------------------------------------------------ |
| Investments | Investment records available to the connected Countercyclical workspace. |
| Valuations  | Valuation records where those records are available in the workspace.    |
| Memos       | Memo records available to the connected workspace.                       |

{% hint style="info" %}
**Full Refresh Syncs**

The connector supports full refresh for these streams. Airbyte reads the selected stream again on each sync. Review the destination’s write mode to understand how existing records are handled.
{% endhint %}

See [Airbyte’s Countercyclical connector reference](https://docs.airbyte.com/integrations/sources/countercyclical) for the current stream and sync-mode details.

#### Access and Connection Management

The key is tied to the workspace that issued it. Review the access granted to the key and choose a destination with the appropriate access controls for your research. Manage schedules, stream selection, and sync history from the connection in Airbyte.

If a sync fails, check the Airbyte connection log. For authentication failures, verify that the key is active and belongs to the intended Countercyclical workspace. If the sync succeeds but records are missing, check the selected streams and the resources the connection can access.

{% hint style="warning" %}
**Before Rotating a Key**

Update and retest the source in Airbyte when you replace its API key. Pausing or removing an Airbyte connection leaves previously copied records under the destination’s controls.
{% endhint %}

#### Related Pages

{% content-ref url="/pages/2u2lr9WbNZnJhcVldsIl" %}
[Connecting & Managing Data Sources](https://docs.countercyclical.io/data-sources/connecting-and-managing-data-sources.md)
{% endcontent-ref %}

{% content-ref url="/pages/BbBaoNbvidcw8eKKWR5h" %}
[Authentication](https://docs.countercyclical.io/developers/authentication.md)
{% endcontent-ref %}

{% content-ref url="/pages/3rH5ytsIIalJqg2x4BVc" %}
[Integration Endpoints](https://docs.countercyclical.io/developers/integration-endpoints.md)
{% endcontent-ref %}

{% content-ref url="/pages/REVYMYw7ghhF39hxYNq9" %}
[Endpoints Catalog](https://docs.countercyclical.io/developers/endpoints-catalog.md)
{% endcontent-ref %}
