schema

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.