Airbyte Schema

        graph LR
    AirbyteConnection -- HAS --> AirbyteStream
    AirbyteConnection -- SYNC_FROM --> AirbyteSource
    AirbyteConnection -- SYNC_TO --> AirbyteDestination
    AirbyteConnection -- TAGGED --> AirbyteTag
    AirbyteOrganization -- RESOURCE --> AirbyteConnection
    AirbyteOrganization -- RESOURCE --> AirbyteDestination
    AirbyteOrganization -- RESOURCE --> AirbyteSource
    AirbyteOrganization -- RESOURCE --> AirbyteStream
    AirbyteOrganization -- RESOURCE --> AirbyteTag
    AirbyteOrganization -- RESOURCE --> AirbyteUser
    AirbyteOrganization -- RESOURCE --> AirbyteWorkspace
    AirbyteUser -- ADMIN_OF --> AirbyteOrganization
    AirbyteUser -- ADMIN_OF --> AirbyteWorkspace
    AirbyteUser -- MEMBER_OF --> AirbyteWorkspace
    AirbyteWorkspace -- CONTAINS --> AirbyteConnection
    AirbyteWorkspace -- CONTAINS --> AirbyteDestination
    AirbyteWorkspace -- CONTAINS --> AirbyteSource
    AirbyteWorkspace -- CONTAINS --> AirbyteTag
    

AirbyteConnection

An Airbyte connection that synchronizes source data to a destination.

Properties

Field	Index	Description
id	Yes	Connection UUID.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
data_residency		Geographic location where connection data resides.
name		Connection name.
namespace_definition		Method used to define the destination namespace.
namespace_format		Format used for destination namespaces.
non_breaking_schema_updates_behavior		Behavior when a non-breaking source schema change is detected.
prefix		Prefix added to destination stream names.
status		Connection status.

Relationships

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteConnection): Links a workspace to a connection it contains.

• (:AirbyteConnection)-[:HAS]->(:AirbyteStream): Links a connection to a stream it synchronizes.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteConnection): Links an organization to a connection it owns.

• (:AirbyteConnection)-[:SYNC_FROM]->(:AirbyteSource): Links a connection to the source it synchronizes from.

• (:AirbyteConnection)-[:SYNC_TO]->(:AirbyteDestination): Links a connection to the destination it synchronizes to.

• (:AirbyteConnection)-[:TAGGED]->(:AirbyteTag): Links a connection to each tag applied to it.

AirbyteDestination

A data destination configured in Airbyte.

Properties

Field	Index	Description
id	Yes	Destination UUID.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
config_account		Configured destination account.
config_endpoint		Configured destination endpoint.
config_host		Configured destination host.
config_name		Configured destination resource name.
config_port		Configured destination port.
config_region		Configured destination region.
name		Destination name.
type		Destination connector type.

Relationships

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteDestination): Links a workspace to a destination it contains.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteDestination): Links an organization to a destination it owns.

• (:AirbyteConnection)-[:SYNC_TO]->(:AirbyteDestination): Links a connection to the destination it synchronizes to.

AirbyteOrganization

An Airbyte organization with the Tenant label.

Ontology Mapping: This node uses the ontology label Tenant.

Properties

Ontology-generated fields are shown in italics.

Field	Index	Description
id	Yes	Organization UUID.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
email		Organization contact email address.
name		Organization name.
_ont_name	Yes	Normalized field sourced from name.
_ont_source		Module that populated this node’s ontology fields.

Relationships

• (:AirbyteUser)-[:ADMIN_OF]->(:AirbyteOrganization): Links a user to an organization they administer.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteConnection): Links an organization to a connection it owns.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteDestination): Links an organization to a destination it owns.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteSource): Links an organization to a source it owns.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteStream): Links an organization to a stream it owns.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteTag): Links an organization to a tag it owns.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteUser): Links an organization to one of its users.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteWorkspace): Links an organization to a workspace it owns.

AirbyteSource

A data source configured in Airbyte.

Properties

Field	Index	Description
id	Yes	Source UUID.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
config_account		Configured source account.
config_endpoint		Configured source endpoint.
config_host		Configured source host.
config_name		Configured source resource name.
config_port		Configured source port.
config_region		Configured source region.
name		Source name.
type		Source connector type.

Relationships

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteSource): Links a workspace to a source it contains.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteSource): Links an organization to a source it owns.

• (:AirbyteConnection)-[:SYNC_FROM]->(:AirbyteSource): Links a connection to the source it synchronizes from.

AirbyteStream

A data stream synchronized by an Airbyte connection.

Properties

Field	Index	Description
id	Yes	Stream identifier.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
cursor_field		Field used as the synchronization cursor.
include_files		Whether blob synchronization includes raw files.
mappers		Custom mappers configured for the stream.
name		Stream name.
primary_key		Primary key fields for the stream.
selected_fields		Fields selected for synchronization.
sync_mode		Synchronization mode for the stream.

Relationships

• (:AirbyteConnection)-[:HAS]->(:AirbyteStream): Links a connection to a stream it synchronizes.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteStream): Links an organization to a stream it owns.

AirbyteTag

A tag used to categorize Airbyte resources.

Properties

Field	Index	Description
id	Yes	Tag UUID.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
color		Tag color in hexadecimal.
name		Tag name.

Relationships

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteTag): Links a workspace to a tag it contains.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteTag): Links an organization to a tag it owns.

• (:AirbyteConnection)-[:TAGGED]->(:AirbyteTag): Links a connection to each tag applied to it.

AirbyteUser

An Airbyte user account with the UserAccount label.

The node is shared across organizations and never cleaned up. Traverse the RESOURCE edge from an organization to find its current users.

Ontology Mapping: This node uses the ontology label UserAccount.

Properties

Ontology-generated fields are shown in italics.

Field	Index	Description
id	Yes	Airbyte user ID.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
email	Yes	User email address.
name		User name.
_ont_email	Yes	Normalized field sourced from email.
_ont_fullname	Yes	Normalized field sourced from name.
_ont_source		Module that populated this node’s ontology fields.

Relationships

• (:AirbyteUser)-[:ADMIN_OF]->(:AirbyteOrganization): Links a user to an organization they administer.

• (:AirbyteUser)-[:ADMIN_OF]->(:AirbyteWorkspace): Links a user to a workspace they administer.

• (:User)-[:HAS_ACCOUNT]->(:AirbyteUser)

• (:AirbyteUser)-[:MEMBER_OF]->(:AirbyteWorkspace): Links a user to a workspace where they are a member.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteUser): Links an organization to one of its users.

AirbyteWorkspace

An Airbyte workspace within an organization.

Properties

Field	Index	Description
id	Yes	Workspace UUID.
firstseen		Timestamp when a sync job first created this node.
lastupdated	Yes	Timestamp of the last sync that observed this node.
data_residency		Geographic location where workspace data resides.
name		Workspace name.

Relationships

• (:AirbyteUser)-[:ADMIN_OF]->(:AirbyteWorkspace): Links a user to a workspace they administer.

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteConnection): Links a workspace to a connection it contains.

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteDestination): Links a workspace to a destination it contains.

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteSource): Links a workspace to a source it contains.

• (:AirbyteWorkspace)-[:CONTAINS]->(:AirbyteTag): Links a workspace to a tag it contains.

• (:AirbyteUser)-[:MEMBER_OF]->(:AirbyteWorkspace): Links a user to a workspace where they are a member.

• (:AirbyteOrganization)-[:RESOURCE]->(:AirbyteWorkspace): Links an organization to a workspace it owns.