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

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

  • (: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.

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

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

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

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

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

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

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

  • (: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.

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

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

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

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

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

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

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

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

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

AirbyteUser

An Airbyte user account with the UserAccount label.

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

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

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

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

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

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

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

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

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

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

  • (: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.

On this page
Airbyte SchemaAirbyteConnectionAirbyteDestinationAirbyteOrganizationAirbyteSourceAirbyteStreamAirbyteTagAirbyteUserAirbyteWorkspace