def METHOD_NAME(self) -> Sequence[SqlOperation]:
    return [
        # local first
        operations.CreateTable(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            table_name="search_issues_local_new",
            columns=columns,
            engine=table_engines.ReplacingMergeTree(
                order_by="(project_id, toStartOfDay(receive_timestamp), primary_hash, cityHash64(occurrence_id))",
                version_column="deleted",
                partition_by="(retention_days, toMonday(receive_timestamp))",
                sample_by="cityHash64(occurrence_id)",
                settings={"index_granularity": "8192"},
                storage_set=StorageSetKey.SEARCH_ISSUES,
                ttl="receive_timestamp + toIntervalDay(retention_days)",
            ),
            target=OperationTarget.LOCAL,
        ),
        operations.AddColumn(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            table_name="search_issues_local_new",
            column=Column(
                "_tags_hash_map",
                Array(UInt(64), Modifiers(materialized=TAGS_HASH_MAP_COLUMN)),
            ),
            after="tags.value",
            target=OperationTarget.LOCAL,
        ),
        operations.DropTable(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            table_name="search_issues_local",
            target=OperationTarget.LOCAL,
        ),
        operations.RenameTable(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            old_table_name="search_issues_local_new",
            new_table_name="search_issues_local",
            target=OperationTarget.LOCAL,
        ),
        # dist second
        operations.CreateTable(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            table_name="search_issues_dist_new",
            columns=columns,
            engine=table_engines.Distributed(
                local_table_name="search_issues_local",
                sharding_key="cityHash64(occurrence_id)",
            ),
            target=OperationTarget.DISTRIBUTED,
        ),
        operations.AddColumn(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            table_name="search_issues_dist_new",
            column=Column(
                "_tags_hash_map",
                Array(UInt(64), Modifiers(materialized=TAGS_HASH_MAP_COLUMN)),
            ),
            after="tags.value",
            target=OperationTarget.DISTRIBUTED,
        ),
        operations.DropTable(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            table_name="search_issues_dist",
            target=OperationTarget.DISTRIBUTED,
        ),
        operations.RenameTable(
            storage_set=StorageSetKey.SEARCH_ISSUES,
            old_table_name="search_issues_dist_new",
            new_table_name="search_issues_dist",
            target=OperationTarget.DISTRIBUTED,
        ),
    ]