{"id":69482,"date":"2024-07-15T22:21:57","date_gmt":"2024-07-15T18:51:57","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/"},"modified":"2024-07-15T22:21:57","modified_gmt":"2024-07-15T18:51:57","slug":"tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/","title":{"rendered":"\u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc: \u067e\u06cc\u0627\u062f\u0647 \u0633\u0627\u0632\u06cc Debezium \u0648 ClickHouse"},"content":{"rendered":"<p>Summarize this content to 400 words in Persian Lang <\/p>\n<p>  \u0645\u0639\u0631\u0641\u06cc<\/p>\n<p>\u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9 \u0645\u062f\u0631\u0646\u060c \u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0647\u0645 \u0645\u0627\u0646\u0646\u062f \u0627\u0646\u0648\u0627\u0639 \u062d\u0633\u0627\u0628\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0631\u0627\u06cc \u0647\u0648\u0634 \u062a\u062c\u0627\u0631\u06cc \u0648 \u0631\u0639\u0627\u06cc\u062a \u0645\u0642\u0631\u0631\u0627\u062a \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a.  \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0633\u0646\u062a\u06cc \u0627\u063a\u0644\u0628 \u0627\u0631\u0632\u0634 \u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc \u0631\u0627 \u0628\u0627\u0632\u0646\u0648\u06cc\u0633\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0631\u0627 \u0628\u0647 \u0686\u0627\u0644\u0634 \u0645\u06cc \u06a9\u0634\u0646\u062f.  Enter Change Data Capture (CDC)\u060c \u062a\u06a9\u0646\u06cc\u06a9\u06cc \u06a9\u0647 \u0647\u0631 \u062a\u063a\u06cc\u06cc\u0631\u06cc \u0631\u0627 \u062f\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u062b\u0628\u062a \u0648 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u06cc\u06a9 \u0645\u0633\u06cc\u0631 \u062d\u0633\u0627\u0628\u0631\u0633\u06cc \u062c\u0627\u0645\u0639 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0631\u0627 \u0645\u0645\u06a9\u0646 \u0645\u06cc\u200c\u0633\u0627\u0632\u062f.<\/p>\n<p>  \u0646\u0645\u0627\u06cc \u06a9\u0644\u06cc \u0633\u0646\u0627\u0631\u06cc\u0648<\/p>\n<p>\u062a\u0635\u0648\u0631 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627 \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u067e\u0644\u062a\u0641\u0631\u0645 \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0627\u0646\u0648\u0627\u0639 \u062d\u0633\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc (\u0628\u0631\u0646\u0632\u060c \u0646\u0642\u0631\u0647 \u0627\u06cc\u060c \u0637\u0644\u0627\u06cc\u06cc) \u0627\u063a\u0644\u0628 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c PostgreSQL \u0641\u0642\u0637 \u0622\u062e\u0631\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f\u060c \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0648\u0636\u0639\u06cc\u062a \u0647\u0627\u06cc \u06af\u0630\u0634\u062a\u0647 \u062d\u0633\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u0631\u0627 \u062f\u0634\u0648\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f.  \u0628\u0631\u0627\u06cc \u0631\u0641\u0639 \u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644\u060c \u0627\u0632 Debezium \u0648 ClickHouse \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u0648 \u0630\u062e\u06cc\u0631\u0647 \u062a\u0645\u0627\u0645 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0646\u0648\u0639 \u062d\u0633\u0627\u0628 \u0628\u0627 \u0645\u064f\u0647\u0631 \u0632\u0645\u0627\u0646\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<p>  \u062a\u0646\u0638\u06cc\u0645 \u0645\u062d\u06cc\u0637<\/p>\n<p>  \u062f\u0631\u06cc\u0627\u0641\u062a \u067e\u0631\u0648\u0698\u0647 \u0627\u0632 Git<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639\u060c \u0645\u062e\u0632\u0646 postgres-cdc-clickhouse GitHub \u0631\u0627 \u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0645\u062d\u06cc\u0637 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Docker Compose \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n<p>git clone https:\/\/github.com\/ranjbaryshahab\/postgres-cdc-clickhouse<br \/>\ncd postgres-cdc-clickhouse<br \/>\ndocker-compose up<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 PostgreSQL<\/p>\n<p>\u0627\u0628\u062a\u062f\u0627 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u062f\u0631 PostgreSQL \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0648 \u067e\u06cc\u06af\u06cc\u0631\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f:<\/p>\n<p>CREATE TABLE users (<br \/>\n    user_id SERIAL PRIMARY KEY,<br \/>\n    username VARCHAR(50) NOT NULL,<br \/>\n    account_type VARCHAR(20) NOT NULL,<br \/>\n    updated_at TIMESTAMP DEFAULT timezone(&#8216;UTC&#8217;, CURRENT_TIMESTAMP),<br \/>\n    created_at TIMESTAMP DEFAULT timezone(&#8216;UTC&#8217;, CURRENT_TIMESTAMP)<br \/>\n);<\/p>\n<p>ALTER TABLE public.users REPLICA IDENTITY FULL;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0633\u067e\u0633 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627:<\/p>\n<p>INSERT INTO users (username, account_type) VALUES<br \/>\n(&#8216;user1&#8217;, &#8216;Bronze&#8217;),<br \/>\n(&#8216;user2&#8217;, &#8216;Silver&#8217;),<br \/>\n(&#8216;user3&#8217;, &#8216;Gold&#8217;);<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0648 \u0646\u062a\u06cc\u062c\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0627\u0633\u062a:<\/p>\n<p>  \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Debezium<\/p>\n<p>\u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Debezium PostgreSQL \u0631\u0627 \u062f\u0631 Kafka Connect \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u062b\u0628\u062a \u06a9\u0646\u062f:<\/p>\n<p>curl &#8211;location &#8211;request POST &#8216;http:\/\/localhost:8083\/connectors&#8217; \\<br \/>\n&#8211;header &#8216;Content-Type: application\/json&#8217; \\<br \/>\n&#8211;data-raw &#8216;{<br \/>\n    &#8220;name&#8221;: &#8220;raw_data.shop-connector&#8221;,<br \/>\n    &#8220;config&#8221;: {<br \/>\n        &#8220;connector.class&#8221;: &#8220;io.debezium.connector.postgresql.PostgresConnector&#8221;,<br \/>\n        &#8220;database.dbname&#8221;: &#8220;postgres&#8221;,<br \/>\n        &#8220;database.history.kafka.bootstrap.servers&#8221;: &#8220;kafka:9092&#8221;,<br \/>\n        &#8220;database.history.kafka.topic&#8221;: &#8220;schema-changes.shop&#8221;,<br \/>\n        &#8220;database.hostname&#8221;: &#8220;postgres&#8221;,<br \/>\n        &#8220;database.password&#8221;: &#8220;postgres&#8221;,<br \/>\n        &#8220;database.port&#8221;: &#8220;5432&#8221;,<br \/>\n        &#8220;database.server.name&#8221;: &#8220;shop&#8221;,<br \/>\n        &#8220;database.user&#8221;: &#8220;postgres&#8221;,<br \/>\n        &#8220;name&#8221;: &#8220;raw_data.shop-connector&#8221;,<br \/>\n        &#8220;plugin.name&#8221;: &#8220;pgoutput&#8221;,<br \/>\n        &#8220;table.include.list&#8221;: &#8220;public.users&#8221;,<br \/>\n        &#8220;tasks.max&#8221;: &#8220;1&#8221;,<br \/>\n        &#8220;topic.creation.default.cleanup.policy&#8221;: &#8220;delete&#8221;,<br \/>\n        &#8220;topic.creation.default.partitions&#8221;: &#8220;1&#8221;,<br \/>\n        &#8220;topic.creation.default.replication.factor&#8221;: &#8220;1&#8221;,<br \/>\n        &#8220;topic.creation.default.retention.ms&#8221;: &#8220;604800000&#8221;,<br \/>\n        &#8220;topic.creation.enable&#8221;: &#8220;true&#8221;,<br \/>\n        &#8220;topic.prefix&#8221;: &#8220;raw_data.shop&#8221;,<br \/>\n        &#8220;database.history.skip.unparseable.ddl&#8221;: &#8220;true&#8221;,<br \/>\n        &#8220;key.converter&#8221;: &#8221; org.apache.kafka.connect.json.JsonConverter&#8221;,<br \/>\n        &#8220;value.converter&#8221;: &#8221; org.apache.kafka.connect.json.JsonConverter&#8221;,<br \/>\n        &#8220;key.converter.schemas.enable&#8221;: &#8220;false&#8221;,<br \/>\n        &#8220;value.converter.schemas.enable&#8221;: &#8220;false&#8221;,<br \/>\n        &#8220;snapshot.mode&#8221;: &#8220;initial&#8221;<br \/>\n    }<br \/>\n}&#8217;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 Redpanda Console \u0628\u0628\u06cc\u0646\u06cc\u062f:\u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Debezium \u0628\u0647 http:\/\/localhost:9080\/topics \u0628\u0631\u0648\u06cc\u062f.<\/p>\n<p>  \u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc<\/p>\n<p>\u0627\u06a9\u0646\u0648\u0646\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0634\u0628\u06cc\u0647\u200c\u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645 \u062a\u0627 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0645\u0646\u0639\u06a9\u0633\u200c\u0634\u062f\u0647 \u062f\u0631 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u06a9\u0627\u0641\u06a9\u0627 \u0648 ClickHouse \u0645\u0627 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u0645:<\/p>\n<p>&#8212; Update user with ID 1 to change the account type to &#8216;Gold&#8217;<br \/>\nUPDATE users<br \/>\nSET account_type = &#8216;Gold&#8217;, updated_at = timezone(&#8216;UTC&#8217;, CURRENT_TIMESTAMP)<br \/>\nWHERE user_id = 1;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0627\u06cc\u0646 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u060c Debezium \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0631\u0627 \u062b\u0628\u062a \u0645\u06cc \u06a9\u0646\u062f \u0648 \u06cc\u06a9 \u0631\u0648\u06cc\u062f\u0627\u062f \u062f\u0631 \u0645\u0648\u0636\u0648\u0639 \u06a9\u0627\u0641\u06a9\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.  \u0627\u06cc\u0646 \u0631\u0648\u06cc\u062f\u0627\u062f \u062d\u0627\u0648\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0642\u0628\u0644\u06cc \u0648 \u062c\u062f\u06cc\u062f \u0641\u06cc\u0644\u062f account_type \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0646\u0648\u0639 \u0639\u0645\u0644\u06cc\u0627\u062a (u \u0628\u0631\u0627\u06cc \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc) \u0627\u0633\u062a.<\/p>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 Redpanda Console \u0628\u0628\u06cc\u0646\u06cc\u062f:<\/p>\n<p>  \u0630\u062e\u06cc\u0631\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 ClickHouse<\/p>\n<p>\u0627\u0632 ClickHouse \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0647\u0645\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0648 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<p>  \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062c\u062f\u0648\u0644 ClickHouse \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/p>\n<p>CREATE DATABASE shop;<\/p>\n<p>CREATE TABLE shop.account_type_switch (<br \/>\n    user_id UInt32,<br \/>\n    username String,<br \/>\n    before_account_type String,<br \/>\n    after_account_type String,<br \/>\n    updated_at DateTime,<br \/>\n    created_at DateTime<br \/>\n) ENGINE = ReplacingMergeTree<br \/>\nORDER BY (user_id, updated_at)<br \/>\nSETTINGS index_granularity = 8192;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  \u062c\u062f\u0648\u0644 \u0645\u0648\u062a\u0648\u0631 \u06a9\u0627\u0641\u06a9\u0627 \u0631\u0627 \u062f\u0631 ClickHouse \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f<\/p>\n<p>CREATE TABLE kafka_shop.kafka__account_type_switch (<br \/>\n    `jsonString` String<br \/>\n) ENGINE = Kafka<br \/>\nSETTINGS kafka_broker_list = &#8216;broker:29092&#8217;,<br \/>\n        kafka_topic_list = &#8216;raw_data.shop.public.users&#8217;,<br \/>\n        kafka_group_name = &#8216;raw_date_clickhouse&#8217;,<br \/>\n        kafka_format = &#8216;JSONAsString&#8217;;<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  \u0646\u0645\u0627\u06cc \u0645\u062a\u0631\u06cc\u0627\u0644 \u0634\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/p>\n<p>CREATE MATERIALIZED VIEW kafka_shop.consumer__account_type_switch TO shop.account_type_switch (<br \/>\n    user_id UInt32,<br \/>\n    username String,<br \/>\n    before_account_type String,<br \/>\n    after_account_type String,<br \/>\n    updated_at DateTime,<br \/>\n    created_at DateTime<br \/>\n) AS<br \/>\nSELECT<br \/>\n    JSONExtract(JSONExtract(jsonString, &#8216;after&#8217;, &#8216;Nullable(String)&#8217;), &#8216;user_id&#8217;, &#8216;Nullable(UInt32)&#8217;) AS user_id,<br \/>\n    JSONExtract(JSONExtract(jsonString, &#8216;after&#8217;, &#8216;Nullable(String)&#8217;), &#8216;username&#8217;, &#8216;Nullable(String)&#8217;) AS username,<br \/>\n    JSONExtract(JSONExtract(jsonString, &#8216;before&#8217;, &#8216;Nullable(String)&#8217;), &#8216;account_type&#8217;, &#8216;Nullable(String)&#8217;) AS before_account_type,<br \/>\n    JSONExtract(JSONExtract(jsonString, &#8216;after&#8217;, &#8216;Nullable(String)&#8217;), &#8216;account_type&#8217;, &#8216;Nullable(String)&#8217;) AS after_account_type,<br \/>\n    toDateTime(JSONExtract(JSONExtract(jsonString, &#8216;after&#8217;, &#8216;Nullable(String)&#8217;), &#8216;updated_at&#8217;, &#8216;Nullable(UInt64)&#8217;) \/ 1000000) AS updated_at,<br \/>\n    toDateTime(JSONExtract(JSONExtract(jsonString, &#8216;after&#8217;, &#8216;Nullable(String)&#8217;), &#8216;created_at&#8217;, &#8216;Nullable(UInt64)&#8217;) \/ 1000000) AS created_at<br \/>\nFROM kafka_shop.kafka__account_type_switch<br \/>\nWHERE (before_account_type != after_account_type) AND (JSONExtract(jsonString, &#8216;op&#8217;, &#8216;Nullable(String)&#8217;) = &#8216;u&#8217;);<\/p>\n<p>    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/p>\n<p>    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/p>\n<p>  \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 ClickHouse \u062a\u0623\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f<\/p>\n<p>  \u0646\u062a\u06cc\u062c\u0647<\/p>\n<p>\u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc CDC \u0628\u0627 Debezium \u0648 ClickHouse \u067e\u0644\u062a\u0641\u0631\u0645 \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9 \u0634\u0645\u0627 \u0631\u0627 \u0642\u0627\u062f\u0631 \u0645\u06cc\u200c\u0633\u0627\u0632\u062f \u062a\u0627 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u06a9\u0627\u0645\u0644 \u062a\u063a\u06cc\u06cc\u0631 \u0646\u0648\u0639 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0631\u0627 \u062d\u0641\u0638 \u06a9\u0646\u062f.  \u0627\u06cc\u0646 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u062d\u0633\u0627\u0628\u0631\u0633\u06cc \u062f\u0642\u06cc\u0642\u060c \u0627\u0646\u0637\u0628\u0627\u0642 \u0628\u0627 \u0645\u0642\u0631\u0631\u0627\u062a\u060c \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0631\u0627 \u0642\u062f\u0631\u062a \u0645\u06cc\u200c\u062f\u0647\u062f \u0648 \u0628\u06cc\u0646\u0634\u200c\u0647\u0627\u06cc \u0627\u0631\u0632\u0634\u0645\u0646\u062f\u06cc \u0631\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f \u0631\u0641\u062a\u0627\u0631 \u06a9\u0627\u0631\u0628\u0631 \u0648 \u0631\u0648\u0646\u062f\u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n<p>\u0628\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0645\u0631\u0627\u062d\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0634\u06cc\u0648\u0647\u200c\u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u062a\u0642\u0648\u06cc\u062a \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0632 \u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0631\u0627\u06cc \u0647\u062f\u0627\u06cc\u062a \u062a\u0635\u0645\u06cc\u0645\u200c\u06af\u06cc\u0631\u06cc \u0622\u06af\u0627\u0647\u0627\u0646\u0647 \u062f\u0631 \u06a9\u0633\u0628\u200c\u0648\u06a9\u0627\u0631 \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<div data-article-id=\"1924578\" id=\"article-body\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u062a\u063a\u06cc\u06cc\u0631 \u0648\u0636\u0639\u06cc\u062a \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D9%85%D8%B9%D8%B1%D9%81%DB%8C\" >\u0645\u0639\u0631\u0641\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D9%86%D9%85%D8%A7%DB%8C_%DA%A9%D9%84%DB%8C_%D8%B3%D9%86%D8%A7%D8%B1%DB%8C%D9%88\" >\u0646\u0645\u0627\u06cc \u06a9\u0644\u06cc \u0633\u0646\u0627\u0631\u06cc\u0648<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%AA%D9%86%D8%B8%DB%8C%D9%85_%D9%85%D8%AD%DB%8C%D8%B7\" >\u062a\u0646\u0638\u06cc\u0645 \u0645\u062d\u06cc\u0637<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%AF%D8%B1%DB%8C%D8%A7%D9%81%D8%AA_%D9%BE%D8%B1%D9%88%DA%98%D9%87_%D8%A7%D8%B2_Git\" >\u062f\u0631\u06cc\u0627\u0641\u062a \u067e\u0631\u0648\u0698\u0647 \u0627\u0632 Git<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D8%AC%D8%AF%D9%88%D9%84_PostgreSQL\" >\u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%DA%A9%D8%A7%D9%86%DA%A9%D8%AA%D9%88%D8%B1_Debezium\" >\u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Debezium<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%B1%D8%AF%DB%8C%D8%A7%D8%A8%DB%8C_%D8%AA%D8%BA%DB%8C%DB%8C%D8%B1%D8%A7%D8%AA_%D8%AF%D8%B1_%D8%B2%D9%85%D8%A7%D9%86_%D9%88%D8%A7%D9%82%D8%B9%DB%8C\" >\u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%B0%D8%AE%DB%8C%D8%B1%D9%87_%D8%AA%D8%BA%DB%8C%DB%8C%D8%B1%D8%A7%D8%AA_%D8%AF%D8%B1_ClickHouse\" >\u0630\u062e\u06cc\u0631\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 ClickHouse<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D9%88_%D8%AC%D8%AF%D9%88%D9%84_ClickHouse_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >\u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062c\u062f\u0648\u0644 ClickHouse \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%AC%D8%AF%D9%88%D9%84_%D9%85%D9%88%D8%AA%D9%88%D8%B1_%DA%A9%D8%A7%D9%81%DA%A9%D8%A7_%D8%B1%D8%A7_%D8%AF%D8%B1_ClickHouse_%D8%AA%D9%86%D8%B8%DB%8C%D9%85_%DA%A9%D9%86%DB%8C%D8%AF\" >\u062c\u062f\u0648\u0644 \u0645\u0648\u062a\u0648\u0631 \u06a9\u0627\u0641\u06a9\u0627 \u0631\u0627 \u062f\u0631 ClickHouse \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D9%86%D9%85%D8%A7%DB%8C_%D9%85%D8%AA%D8%B1%DB%8C%D8%A7%D9%84_%D8%B4%D8%AF%D9%87_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >\u0646\u0645\u0627\u06cc \u0645\u062a\u0631\u06cc\u0627\u0644 \u0634\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%B1%D8%A7_%D8%AF%D8%B1_ClickHouse_%D8%AA%D8%A3%DB%8C%DB%8C%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\" >\u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 ClickHouse \u062a\u0623\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/nabfollower.com\/blog\/tracking-user-account-changes-in-real-time-a-debezium-and-clickhouse-implementation-350\/#%D9%86%D8%AA%DB%8C%D8%AC%D9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%D8%B9%D8%B1%D9%81%DB%8C\"><\/span>\n<p>  \u0645\u0639\u0631\u0641\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9 \u0645\u062f\u0631\u0646\u060c \u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0647\u0645 \u0645\u0627\u0646\u0646\u062f \u0627\u0646\u0648\u0627\u0639 \u062d\u0633\u0627\u0628\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0631\u0627\u06cc \u0647\u0648\u0634 \u062a\u062c\u0627\u0631\u06cc \u0648 \u0631\u0639\u0627\u06cc\u062a \u0645\u0642\u0631\u0631\u0627\u062a \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a.  \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0633\u0646\u062a\u06cc \u0627\u063a\u0644\u0628 \u0627\u0631\u0632\u0634 \u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc \u0631\u0627 \u0628\u0627\u0632\u0646\u0648\u06cc\u0633\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0631\u0627 \u0628\u0647 \u0686\u0627\u0644\u0634 \u0645\u06cc \u06a9\u0634\u0646\u062f.  Enter Change Data Capture (CDC)\u060c \u062a\u06a9\u0646\u06cc\u06a9\u06cc \u06a9\u0647 \u0647\u0631 \u062a\u063a\u06cc\u06cc\u0631\u06cc \u0631\u0627 \u062f\u0631 \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0634\u0645\u0627 \u062b\u0628\u062a \u0648 \u0630\u062e\u06cc\u0631\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f \u0648 \u06cc\u06a9 \u0645\u0633\u06cc\u0631 \u062d\u0633\u0627\u0628\u0631\u0633\u06cc \u062c\u0627\u0645\u0639 \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0628\u0644\u0627\u062f\u0631\u0646\u06af \u0631\u0627 \u0645\u0645\u06a9\u0646 \u0645\u06cc\u200c\u0633\u0627\u0632\u062f.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C_%DA%A9%D9%84%DB%8C_%D8%B3%D9%86%D8%A7%D8%B1%DB%8C%D9%88\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc \u06a9\u0644\u06cc \u0633\u0646\u0627\u0631\u06cc\u0648<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u062a\u0635\u0648\u0631 \u06a9\u0646\u06cc\u062f \u06cc\u06a9 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 PostgreSQL \u0631\u0627 \u0628\u0631\u0627\u06cc \u06cc\u06a9 \u067e\u0644\u062a\u0641\u0631\u0645 \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u0645\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u062f\u0631 \u0622\u0646 \u0627\u0646\u0648\u0627\u0639 \u062d\u0633\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc (\u0628\u0631\u0646\u0632\u060c \u0646\u0642\u0631\u0647 \u0627\u06cc\u060c \u0637\u0644\u0627\u06cc\u06cc) \u0627\u063a\u0644\u0628 \u062a\u063a\u06cc\u06cc\u0631 \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c PostgreSQL \u0641\u0642\u0637 \u0622\u062e\u0631\u06cc\u0646 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u062f\u060c \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u0648\u0636\u0639\u06cc\u062a \u0647\u0627\u06cc \u06af\u0630\u0634\u062a\u0647 \u062d\u0633\u0627\u0628 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u0631\u0627 \u062f\u0634\u0648\u0627\u0631 \u0645\u06cc \u06a9\u0646\u062f.  \u0628\u0631\u0627\u06cc \u0631\u0641\u0639 \u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644\u060c \u0627\u0632 Debezium \u0648 ClickHouse \u0628\u0631\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u0648 \u0630\u062e\u06cc\u0631\u0647 \u062a\u0645\u0627\u0645 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0646\u0648\u0639 \u062d\u0633\u0627\u0628 \u0628\u0627 \u0645\u064f\u0647\u0631 \u0632\u0645\u0627\u0646\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D8%AA%D9%86%D8%B8%DB%8C%D9%85_%D9%85%D8%AD%DB%8C%D8%B7\"><\/span>\n<p>  \u062a\u0646\u0638\u06cc\u0645 \u0645\u062d\u06cc\u0637<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AF%D8%B1%DB%8C%D8%A7%D9%81%D8%AA_%D9%BE%D8%B1%D9%88%DA%98%D9%87_%D8%A7%D8%B2_Git\"><\/span>\n<p>  \u062f\u0631\u06cc\u0627\u0641\u062a \u067e\u0631\u0648\u0698\u0647 \u0627\u0632 Git<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u0631\u0627\u06cc \u0634\u0631\u0648\u0639\u060c \u0645\u062e\u0632\u0646 postgres-cdc-clickhouse GitHub \u0631\u0627 \u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0645\u062d\u06cc\u0637 \u0631\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 Docker Compose \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>git clone https:\/\/github.com\/ranjbaryshahab\/postgres-cdc-clickhouse\n<span class=\"nb\">cd <\/span>postgres-cdc-clickhouse\ndocker-compose up\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%D8%AC%D8%AF%D9%88%D9%84_PostgreSQL\"><\/span>\n<p>  \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 PostgreSQL<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0628\u062a\u062f\u0627 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u062f\u0631 PostgreSQL \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631 \u0648 \u067e\u06cc\u06af\u06cc\u0631\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0646\u06cc\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">users<\/span> <span class=\"p\">(<\/span>\n    <span class=\"n\">user_id<\/span> <span class=\"nb\">SERIAL<\/span> <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">username<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">50<\/span><span class=\"p\">)<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">account_type<\/span> <span class=\"nb\">VARCHAR<\/span><span class=\"p\">(<\/span><span class=\"mi\">20<\/span><span class=\"p\">)<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">updated_at<\/span> <span class=\"nb\">TIMESTAMP<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"n\">timezone<\/span><span class=\"p\">(<\/span><span class=\"s1\">'UTC'<\/span><span class=\"p\">,<\/span> <span class=\"k\">CURRENT_TIMESTAMP<\/span><span class=\"p\">),<\/span>\n    <span class=\"n\">created_at<\/span> <span class=\"nb\">TIMESTAMP<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"n\">timezone<\/span><span class=\"p\">(<\/span><span class=\"s1\">'UTC'<\/span><span class=\"p\">,<\/span> <span class=\"k\">CURRENT_TIMESTAMP<\/span><span class=\"p\">)<\/span>\n<span class=\"p\">);<\/span>\n\n<span class=\"k\">ALTER<\/span> <span class=\"k\">TABLE<\/span> <span class=\"k\">public<\/span><span class=\"p\">.<\/span><span class=\"n\">users<\/span> <span class=\"n\">REPLICA<\/span> <span class=\"k\">IDENTITY<\/span> <span class=\"k\">FULL<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0633\u067e\u0633 \u062f\u0631\u062c \u062f\u0627\u062f\u0647 \u0647\u0627:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">users<\/span> <span class=\"p\">(<\/span><span class=\"n\">username<\/span><span class=\"p\">,<\/span> <span class=\"n\">account_type<\/span><span class=\"p\">)<\/span> <span class=\"k\">VALUES<\/span>\n<span class=\"p\">(<\/span><span class=\"s1\">'user1'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Bronze'<\/span><span class=\"p\">),<\/span>\n<span class=\"p\">(<\/span><span class=\"s1\">'user2'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Silver'<\/span><span class=\"p\">),<\/span>\n<span class=\"p\">(<\/span><span class=\"s1\">'user3'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Gold'<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0648 \u0646\u062a\u06cc\u062c\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0627\u0633\u062a:<\/p>\n<p><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B1%D8%A7%D9%87_%D8%A7%D9%86%D8%AF%D8%A7%D8%B2%DB%8C_%DA%A9%D8%A7%D9%86%DA%A9%D8%AA%D9%88%D8%B1_Debezium\"><\/span>\n<p>  \u0631\u0627\u0647 \u0627\u0646\u062f\u0627\u0632\u06cc \u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Debezium<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Debezium PostgreSQL \u0631\u0627 \u062f\u0631 Kafka Connect \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u06a9\u0646\u06cc\u062f \u062a\u0627 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0631\u0627 \u062b\u0628\u062a \u06a9\u0646\u062f:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight shell\"><code>curl <span class=\"nt\">--location<\/span> <span class=\"nt\">--request<\/span> POST <span class=\"s1\">'http:\/\/localhost:8083\/connectors'<\/span> <span class=\"se\">\\<\/span>\n<span class=\"nt\">--header<\/span> <span class=\"s1\">'Content-Type: application\/json'<\/span> <span class=\"se\">\\<\/span>\n<span class=\"nt\">--data-raw<\/span> <span class=\"s1\">'{\n    \"name\": \"raw_data.shop-connector\",\n    \"config\": {\n        \"connector.class\": \"io.debezium.connector.postgresql.PostgresConnector\",\n        \"database.dbname\": \"postgres\",\n        \"database.history.kafka.bootstrap.servers\": \"kafka:9092\",\n        \"database.history.kafka.topic\": \"schema-changes.shop\",\n        \"database.hostname\": \"postgres\",\n        \"database.password\": \"postgres\",\n        \"database.port\": \"5432\",\n        \"database.server.name\": \"shop\",\n        \"database.user\": \"postgres\",\n        \"name\": \"raw_data.shop-connector\",\n        \"plugin.name\": \"pgoutput\",\n        \"table.include.list\": \"public.users\",\n        \"tasks.max\": \"1\",\n        \"topic.creation.default.cleanup.policy\": \"delete\",\n        \"topic.creation.default.partitions\": \"1\",\n        \"topic.creation.default.replication.factor\": \"1\",\n        \"topic.creation.default.retention.ms\": \"604800000\",\n        \"topic.creation.enable\": \"true\",\n        \"topic.prefix\": \"raw_data.shop\",\n        \"database.history.skip.unparseable.ddl\": \"true\",\n        \"key.converter\": \" org.apache.kafka.connect.json.JsonConverter\",\n        \"value.converter\": \" org.apache.kafka.connect.json.JsonConverter\",\n        \"key.converter.schemas.enable\": \"false\",\n        \"value.converter.schemas.enable\": \"false\",\n        \"snapshot.mode\": \"initial\"\n    }\n}'<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 Redpanda Console \u0628\u0628\u06cc\u0646\u06cc\u062f:<br \/>\u0628\u0631\u0627\u06cc \u0645\u0634\u0627\u0647\u062f\u0647 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u062a\u0648\u0633\u0637 \u06a9\u0627\u0646\u06a9\u062a\u0648\u0631 Debezium \u0628\u0647 http:\/\/localhost:9080\/topics \u0628\u0631\u0648\u06cc\u062f.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media.dev.to\/cdn-cgi\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F6zou053xr2ywlf9rajrf.png\" alt=\"\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u06a9\u0646\u0633\u0648\u0644 Redpanda\" loading=\"lazy\" width=\"800\" height=\"382\" title=\"\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B1%D8%AF%DB%8C%D8%A7%D8%A8%DB%8C_%D8%AA%D8%BA%DB%8C%DB%8C%D8%B1%D8%A7%D8%AA_%D8%AF%D8%B1_%D8%B2%D9%85%D8%A7%D9%86_%D9%88%D8%A7%D9%82%D8%B9%DB%8C\"><\/span>\n<p>  \u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u06a9\u0646\u0648\u0646\u060c \u0628\u06cc\u0627\u06cc\u06cc\u062f \u06cc\u06a9 \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc \u0631\u0627 \u062f\u0631 \u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u0628\u0631\u0627\u0646 \u0634\u0628\u06cc\u0647\u200c\u0633\u0627\u0632\u06cc \u06a9\u0646\u06cc\u0645 \u062a\u0627 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0645\u0646\u0639\u06a9\u0633\u200c\u0634\u062f\u0647 \u062f\u0631 \u0645\u0648\u0636\u0648\u0639\u0627\u062a \u06a9\u0627\u0641\u06a9\u0627 \u0648 ClickHouse \u0645\u0627 \u0631\u0627 \u0628\u0628\u06cc\u0646\u06cc\u0645:<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"c1\">-- Update user with ID 1 to change the account type to 'Gold'<\/span>\n<span class=\"k\">UPDATE<\/span> <span class=\"n\">users<\/span>\n<span class=\"k\">SET<\/span> <span class=\"n\">account_type<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'Gold'<\/span><span class=\"p\">,<\/span> <span class=\"n\">updated_at<\/span> <span class=\"o\">=<\/span> <span class=\"n\">timezone<\/span><span class=\"p\">(<\/span><span class=\"s1\">'UTC'<\/span><span class=\"p\">,<\/span> <span class=\"k\">CURRENT_TIMESTAMP<\/span><span class=\"p\">)<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"n\">user_id<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">1<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0647\u0646\u06af\u0627\u0645\u06cc \u06a9\u0647 \u0627\u06cc\u0646 \u0628\u0647 \u0631\u0648\u0632 \u0631\u0633\u0627\u0646\u06cc \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u060c Debezium \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u0631\u0627 \u062b\u0628\u062a \u0645\u06cc \u06a9\u0646\u062f \u0648 \u06cc\u06a9 \u0631\u0648\u06cc\u062f\u0627\u062f \u062f\u0631 \u0645\u0648\u0636\u0648\u0639 \u06a9\u0627\u0641\u06a9\u0627 \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f.  \u0627\u06cc\u0646 \u0631\u0648\u06cc\u062f\u0627\u062f \u062d\u0627\u0648\u06cc \u0645\u0642\u0627\u062f\u06cc\u0631 \u0642\u0628\u0644\u06cc \u0648 \u062c\u062f\u06cc\u062f \u0641\u06cc\u0644\u062f account_type \u0628\u0647 \u0647\u0645\u0631\u0627\u0647 \u0646\u0648\u0639 \u0639\u0645\u0644\u06cc\u0627\u062a (u \u0628\u0631\u0627\u06cc \u0628\u0647\u200c\u0631\u0648\u0632\u0631\u0633\u0627\u0646\u06cc) \u0627\u0633\u062a.<\/p>\n<p>\u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u062f\u0631 Redpanda Console \u0628\u0628\u06cc\u0646\u06cc\u062f:<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/media.dev.to\/cdn-cgi\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fvjgy6frm9tvfgsrt296v.png\" alt=\"\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0631\u062f\u06cc\u0627\u0628\u06cc \u06a9\u0646\u0633\u0648\u0644 Redpanda\" loading=\"lazy\" width=\"800\" height=\"380\" title=\"\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%B0%D8%AE%DB%8C%D8%B1%D9%87_%D8%AA%D8%BA%DB%8C%DB%8C%D8%B1%D8%A7%D8%AA_%D8%AF%D8%B1_ClickHouse\"><\/span>\n<p>  \u0630\u062e\u06cc\u0631\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 ClickHouse<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0627\u0632 ClickHouse \u0628\u0631\u0627\u06cc \u0630\u062e\u06cc\u0631\u0647 \u0647\u0645\u0647 \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0627\u062e\u062a\u0635\u0627\u0635\u06cc \u0648 \u0646\u0645\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f:<\/p>\n<h4><span class=\"ez-toc-section\" id=\"%D9%BE%D8%A7%DB%8C%DA%AF%D8%A7%D9%87_%D8%AF%D8%A7%D8%AF%D9%87_%D9%88_%D8%AC%D8%AF%D9%88%D9%84_ClickHouse_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062c\u062f\u0648\u0644 ClickHouse \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">DATABASE<\/span> <span class=\"n\">shop<\/span><span class=\"p\">;<\/span>\n\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">shop<\/span><span class=\"p\">.<\/span><span class=\"n\">account_type_switch<\/span> <span class=\"p\">(<\/span>\n    <span class=\"n\">user_id<\/span> <span class=\"n\">UInt32<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">username<\/span> <span class=\"n\">String<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">before_account_type<\/span> <span class=\"n\">String<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">after_account_type<\/span> <span class=\"n\">String<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">updated_at<\/span> <span class=\"nb\">DateTime<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">created_at<\/span> <span class=\"nb\">DateTime<\/span>\n<span class=\"p\">)<\/span> <span class=\"n\">ENGINE<\/span> <span class=\"o\">=<\/span> <span class=\"n\">ReplacingMergeTree<\/span>\n<span class=\"k\">ORDER<\/span> <span class=\"k\">BY<\/span> <span class=\"p\">(<\/span><span class=\"n\">user_id<\/span><span class=\"p\">,<\/span> <span class=\"n\">updated_at<\/span><span class=\"p\">)<\/span>\n<span class=\"n\">SETTINGS<\/span> <span class=\"n\">index_granularity<\/span> <span class=\"o\">=<\/span> <span class=\"mi\">8192<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D8%AC%D8%AF%D9%88%D9%84_%D9%85%D9%88%D8%AA%D9%88%D8%B1_%DA%A9%D8%A7%D9%81%DA%A9%D8%A7_%D8%B1%D8%A7_%D8%AF%D8%B1_ClickHouse_%D8%AA%D9%86%D8%B8%DB%8C%D9%85_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u062c\u062f\u0648\u0644 \u0645\u0648\u062a\u0648\u0631 \u06a9\u0627\u0641\u06a9\u0627 \u0631\u0627 \u062f\u0631 ClickHouse \u062a\u0646\u0638\u06cc\u0645 \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"n\">kafka_shop<\/span><span class=\"p\">.<\/span><span class=\"n\">kafka__account_type_switch<\/span> <span class=\"p\">(<\/span>\n    <span class=\"nv\">`jsonString`<\/span> <span class=\"n\">String<\/span>\n<span class=\"p\">)<\/span> <span class=\"n\">ENGINE<\/span> <span class=\"o\">=<\/span> <span class=\"n\">Kafka<\/span>\n<span class=\"n\">SETTINGS<\/span> <span class=\"n\">kafka_broker_list<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'broker:29092'<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">kafka_topic_list<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'raw_data.shop.public.users'<\/span><span class=\"p\">,<\/span> \n        <span class=\"n\">kafka_group_name<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'raw_date_clickhouse'<\/span><span class=\"p\">,<\/span>\n        <span class=\"n\">kafka_format<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'JSONAsString'<\/span><span class=\"p\">;<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D9%86%D9%85%D8%A7%DB%8C_%D9%85%D8%AA%D8%B1%DB%8C%D8%A7%D9%84_%D8%B4%D8%AF%D9%87_%D8%A7%DB%8C%D8%AC%D8%A7%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u0646\u0645\u0627\u06cc \u0645\u062a\u0631\u06cc\u0627\u0644 \u0634\u062f\u0647 \u0627\u06cc\u062c\u0627\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">CREATE<\/span> <span class=\"n\">MATERIALIZED<\/span> <span class=\"k\">VIEW<\/span> <span class=\"n\">kafka_shop<\/span><span class=\"p\">.<\/span><span class=\"n\">consumer__account_type_switch<\/span> <span class=\"k\">TO<\/span> <span class=\"n\">shop<\/span><span class=\"p\">.<\/span><span class=\"n\">account_type_switch<\/span> <span class=\"p\">(<\/span>\n    <span class=\"n\">user_id<\/span> <span class=\"n\">UInt32<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">username<\/span> <span class=\"n\">String<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">before_account_type<\/span> <span class=\"n\">String<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">after_account_type<\/span> <span class=\"n\">String<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">updated_at<\/span> <span class=\"nb\">DateTime<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">created_at<\/span> <span class=\"nb\">DateTime<\/span>\n<span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> \n<span class=\"k\">SELECT<\/span>\n    <span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">jsonString<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'after'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">),<\/span> <span class=\"s1\">'user_id'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(UInt32)'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">user_id<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">jsonString<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'after'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">),<\/span> <span class=\"s1\">'username'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">username<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">jsonString<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'before'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">),<\/span> <span class=\"s1\">'account_type'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">before_account_type<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">jsonString<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'after'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">),<\/span> <span class=\"s1\">'account_type'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">after_account_type<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">toDateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">jsonString<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'after'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">),<\/span> <span class=\"s1\">'updated_at'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(UInt64)'<\/span><span class=\"p\">)<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">1000000<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">updated_at<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">toDateTime<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">jsonString<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'after'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">),<\/span> <span class=\"s1\">'created_at'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(UInt64)'<\/span><span class=\"p\">)<\/span> <span class=\"o\">\/<\/span> <span class=\"mi\">1000000<\/span><span class=\"p\">)<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">created_at<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">kafka_shop<\/span><span class=\"p\">.<\/span><span class=\"n\">kafka__account_type_switch<\/span>\n<span class=\"k\">WHERE<\/span> <span class=\"p\">(<\/span><span class=\"n\">before_account_type<\/span> <span class=\"o\">!=<\/span> <span class=\"n\">after_account_type<\/span><span class=\"p\">)<\/span> <span class=\"k\">AND<\/span> <span class=\"p\">(<\/span><span class=\"n\">JSONExtract<\/span><span class=\"p\">(<\/span><span class=\"n\">jsonString<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'op'<\/span><span class=\"p\">,<\/span> <span class=\"s1\">'Nullable(String)'<\/span><span class=\"p\">)<\/span> <span class=\"o\">=<\/span> <span class=\"s1\">'u'<\/span><span class=\"p\">);<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"%D8%AF%D8%A7%D8%AF%D9%87_%D9%87%D8%A7_%D8%B1%D8%A7_%D8%AF%D8%B1_ClickHouse_%D8%AA%D8%A3%DB%8C%DB%8C%D8%AF_%DA%A9%D9%86%DB%8C%D8%AF\"><\/span>\n<p>  \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u062f\u0631 ClickHouse \u062a\u0623\u06cc\u06cc\u062f \u06a9\u0646\u06cc\u062f<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><img decoding=\"async\" src=\"https:\/\/media.dev.to\/cdn-cgi\/image\/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto\/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2F9hbg8z5akbn33akne477.png\" alt=\"\u0646\u062a\u06cc\u062c\u0647 \u06a9\u0644\u06cc\u06a9 \u0647\u0627\u0648\u0633\" loading=\"lazy\" width=\"800\" height=\"48\" title=\"\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D8%AA%DB%8C%D8%AC%D9%87\"><\/span>\n<p>  \u0646\u062a\u06cc\u062c\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u067e\u06cc\u0627\u062f\u0647\u200c\u0633\u0627\u0632\u06cc CDC \u0628\u0627 Debezium \u0648 ClickHouse \u067e\u0644\u062a\u0641\u0631\u0645 \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9 \u0634\u0645\u0627 \u0631\u0627 \u0642\u0627\u062f\u0631 \u0645\u06cc\u200c\u0633\u0627\u0632\u062f \u062a\u0627 \u062a\u0627\u0631\u06cc\u062e\u0686\u0647 \u06a9\u0627\u0645\u0644 \u062a\u063a\u06cc\u06cc\u0631 \u0646\u0648\u0639 \u062d\u0633\u0627\u0628 \u06a9\u0627\u0631\u0628\u0631\u06cc \u0631\u0627 \u062d\u0641\u0638 \u06a9\u0646\u062f.  \u0627\u06cc\u0646 \u0631\u0627\u0647\u200c\u0627\u0646\u062f\u0627\u0632\u06cc \u062d\u0633\u0627\u0628\u0631\u0633\u06cc \u062f\u0642\u06cc\u0642\u060c \u0627\u0646\u0637\u0628\u0627\u0642 \u0628\u0627 \u0645\u0642\u0631\u0631\u0627\u062a\u060c \u0648 \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u067e\u06cc\u0634\u0631\u0641\u062a\u0647 \u0631\u0627 \u0642\u062f\u0631\u062a \u0645\u06cc\u200c\u062f\u0647\u062f \u0648 \u0628\u06cc\u0646\u0634\u200c\u0647\u0627\u06cc \u0627\u0631\u0632\u0634\u0645\u0646\u062f\u06cc \u0631\u0627 \u062f\u0631 \u0645\u0648\u0631\u062f \u0631\u0641\u062a\u0627\u0631 \u06a9\u0627\u0631\u0628\u0631 \u0648 \u0631\u0648\u0646\u062f\u0647\u0627\u06cc \u062a\u062c\u0627\u0631\u06cc \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc\u200c\u062f\u0647\u062f.<\/p>\n<p>\u0628\u0627 \u062f\u0646\u0628\u0627\u0644 \u06a9\u0631\u062f\u0646 \u0627\u06cc\u0646 \u0645\u0631\u0627\u062d\u0644\u060c \u0645\u06cc\u200c\u062a\u0648\u0627\u0646\u06cc\u062f \u0634\u06cc\u0648\u0647\u200c\u0647\u0627\u06cc \u0645\u062f\u06cc\u0631\u06cc\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u062e\u0648\u062f \u0631\u0627 \u062a\u0642\u0648\u06cc\u062a \u06a9\u0646\u06cc\u062f \u0648 \u0627\u0632 \u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0631\u0627\u06cc \u0647\u062f\u0627\u06cc\u062a \u062a\u0635\u0645\u06cc\u0645\u200c\u06af\u06cc\u0631\u06cc \u0622\u06af\u0627\u0647\u0627\u0646\u0647 \u062f\u0631 \u06a9\u0633\u0628\u200c\u0648\u06a9\u0627\u0631 \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Summarize this content to 400 words in Persian Lang \u0645\u0639\u0631\u0641\u06cc \u062f\u0631 \u0628\u0631\u0646\u0627\u0645\u0647\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc \u062a\u062c\u0627\u0631\u062a \u0627\u0644\u06a9\u062a\u0631\u0648\u0646\u06cc\u06a9 \u0645\u062f\u0631\u0646\u060c \u0631\u062f\u06cc\u0627\u0628\u06cc \u062a\u063a\u06cc\u06cc\u0631\u0627\u062a \u062f\u0627\u062f\u0647\u200c\u0647\u0627\u06cc \u0645\u0647\u0645 \u0645\u0627\u0646\u0646\u062f \u0627\u0646\u0648\u0627\u0639 \u062d\u0633\u0627\u0628\u200c\u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u06cc \u062f\u0631 \u0632\u0645\u0627\u0646 \u0648\u0627\u0642\u0639\u06cc \u0628\u0631\u0627\u06cc \u0647\u0648\u0634 \u062a\u062c\u0627\u0631\u06cc \u0648 \u0631\u0639\u0627\u06cc\u062a \u0645\u0642\u0631\u0631\u0627\u062a \u0636\u0631\u0648\u0631\u06cc \u0627\u0633\u062a. \u067e\u0627\u06cc\u06af\u0627\u0647 \u0647\u0627\u06cc \u062f\u0627\u062f\u0647 \u0633\u0646\u062a\u06cc \u0627\u063a\u0644\u0628 \u0627\u0631\u0632\u0634 \u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc \u0631\u0627 \u0628\u0627\u0632\u0646\u0648\u06cc\u0633\u06cc \u0645\u06cc \u06a9\u0646\u0646\u062f \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062a\u0627\u0631\u06cc\u062e\u06cc \u0631\u0627 \u0628\u0647 \u0686\u0627\u0644\u0634 \u0645\u06cc \u06a9\u0634\u0646\u062f. &hellip;<\/p>\n","protected":false},"author":2,"featured_media":69483,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-69482","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/69482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=69482"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/69482\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/69483"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=69482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=69482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=69482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}