Skip to content

Handle is_deleted attribute when querying for identities in ClickHouse #7593

@matthewelwell

Description

@matthewelwell

Scope

  1. Modify clickhouse schema to add is_deleted boolean attribute to the identities table
  2. Modify business logic reading from clickhouse either by an additional clause, a row policy or a materialised view

Acceptance Criteria

  • Rows can be written to the identities table with is_deleted attribute
  • Rows with is_deleted: true do not appear in segment membership views

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions