{"id":110627,"date":"2025-05-26T09:34:18","date_gmt":"2025-05-26T05:04:18","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7%db%8c-%d9%82%d8%af%db%8c%d9%85%db%8c-%d8%ac%d8%a7%d9%85%d8%b9%d9%87-dev\/"},"modified":"2025-05-26T09:34:18","modified_gmt":"2025-05-26T05:04:18","slug":"%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7%db%8c-%d9%82%d8%af%db%8c%d9%85%db%8c-%d8%ac%d8%a7%d9%85%d8%b9%d9%87-dev","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d8%af%d8%a7%d8%af%d9%87-%d9%87%d8%a7%db%8c-%d9%82%d8%af%db%8c%d9%85%db%8c-%d8%ac%d8%a7%d9%85%d8%b9%d9%87-dev\/","title":{"rendered":"\u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u062f\u06cc\u0645\u06cc – \u062c\u0627\u0645\u0639\u0647 dev"},"content":{"rendered":"
\n

\u062f\u0631 \u0632\u06cc\u0631 \u06cc\u06a9 \u0631\u0627\u0647 \u062d\u0644 \u062f\u0648 \u0642\u0633\u0645\u062a \u0648 \u06a9\u0627\u0645\u0644 \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0631\u0633\u06cc\u062f\u0647 \u0627\u0633\u062a \u06a9\u0647 \u0646\u06cc\u0627\u0632\u0647\u0627\u06cc \u0634\u0645\u0627 \u0631\u0627 \u0628\u0631\u0622\u0648\u0631\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06cc\u0646 \u0637\u0631\u062d \u0645\u0648\u0627\u0631\u062f \u0632\u06cc\u0631 \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u062f\u0647\u062f:<\/p>\n

    \n
  1. \n

    \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc \u0627\u0632 \u0642\u0627\u0644\u0628 CSV \u0648 \u062a\u0634\u062e\u06cc\u0635 \u0646\u0648\u0639 \u0648\u0631\u0648\u062f\u06cc<\/strong><\/p>\n

    – \u0641\u0631\u0636 \u0628\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 CSV \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc \u0627\u0632 \u0627\u06cc\u0646 \u0633\u062a\u0648\u0646 \u0647\u0627 \u0627\u0633\u062a:<\/p>\n

    mapping_id \u060c source_name \u060c source_object_type \u060c target_name \u060c target_object_type \u060c \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc_\u0645\u0648\u062f \u060c where_clause \u060c udude_columns<\/p>\n

    – \u0633\u06cc\u0633\u062a\u0645 \u0645\u0642\u062f\u0627\u0631 Source_name \u0648 Target_Name \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u0645\u06cc \u06a9\u0646\u062f. \u0627\u06af\u0631 \u0645\u0642\u062f\u0627\u0631 \u0628\u0627 “\u0627\u0646\u062a\u062e\u0627\u0628” \u0634\u0631\u0648\u0639 \u0634\u0648\u062f \u06cc\u0627 \u0628\u0627 “.sql” \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0628\u0631\u0633\u062f \u060c \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 SQL \u0633\u0641\u0627\u0631\u0634\u06cc (\u06cc\u0627 \u0645\u0633\u06cc\u0631 \u067e\u0631\u0648\u0646\u062f\u0647) \u0631\u0641\u062a\u0627\u0631 \u0645\u06cc \u0634\u0648\u062f. \u062f\u0631 \u063a\u06cc\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0641\u0631\u0636 \u0628\u0631 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u0646\u0627\u0645 \u0634\u06cc\u0621 \u06a9\u0627\u0645\u0644\u0627\u064b \u0648\u0627\u062c\u062f \u0634\u0631\u0627\u06cc\u0637 \u062f\u0631 \u0641\u0631\u0645 “DB.Schema.Object_Name” \u0627\u0633\u062a.<\/p>\n<\/li>\n

  2. \n

    \u062f\u0633\u062a \u0632\u062f\u0646 \u0628\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u067e\u0648\u06cc\u0627<\/strong><\/p>\n

    – \u0627\u06af\u0631 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0633\u0641\u0627\u0631\u0634\u06cc \u0628\u0631\u0627\u06cc \u0647\u0631 \u062f\u0648 \u0637\u0631\u0641 \u0645\u0646\u062a\u0642\u0644 \u0634\u0648\u062f \u060c \u0633\u06cc\u0633\u062a\u0645 \u0627\u0628\u062a\u062f\u0627 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u06cc\u06a9 \u06cc\u0627\u0648\u0631 (_prepare_temp_object) \u06cc\u06a9 \u062c\u062f\u0648\u0644 \u0645\u0648\u0642\u062a (\u06cc\u0627 \u0646\u0645\u0627\u06cc) \u0627\u06cc\u062c\u0627\u062f \u0645\u06cc \u06a9\u0646\u062f \u06a9\u0647 \u06cc\u06a9 \u062f\u0633\u062a\u0648\u0631 “\u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0645\u0648\u0642\u062a … \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 (\u067e\u0631\u0633 \u0648 \u062c\u0648 \u0633\u0641\u0627\u0631\u0634\u06cc)” \u0631\u0627 \u0627\u062c\u0631\u0627 \u0645\u06cc \u06a9\u0646\u062f. (\u062f\u0631 \u062a\u0648\u0644\u06cc\u062f \u062a\u0623\u06cc\u06cc\u062f \u0645\u06cc \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0634\u06cc \u0627\u06cc\u062c\u0627\u062f \u0634\u062f\u0647 \u0627\u0633\u062a \u060c \u062f\u0631 \u0627\u06cc\u0646\u062c\u0627 \u0645\u0627 \u0622\u0646 \u0631\u0627 \u0634\u0628\u06cc\u0647 \u0633\u0627\u0632\u06cc \u0645\u06cc \u06a9\u0646\u06cc\u0645.)<\/p>\n

    – \u0633\u067e\u0633 \u060c \u062a\u0645\u0627\u0645 \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc \u0647\u0627\u06cc \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0648 \u06a9\u0644 \u0627\u0628\u0631\u062f\u0627\u062f\u0647 \u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0646\u0627\u0645 \u0622\u0646 \u0634\u06cc\u0621 \u0645\u0648\u0642\u062a \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 “from_name” \u062f\u0631 \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0627\u0646\u062c\u0627\u0645 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<\/li>\n

  3. \n

    \u062a\u0634\u06a9\u06cc\u0644 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0644 \u0648 \u0639\u0627\u062f\u06cc \u0633\u0627\u0632\u06cc<\/strong><\/p>\n

    – \u0627\u0644\u06af\u0648\u0647\u0627\u06cc \u067e\u06cc\u0634 \u0641\u0631\u0636 SQL (\u062f\u0631 \u067e\u0631\u0648\u0646\u062f\u0647 \u0647\u0627\u06cc \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc YAML) \u0627\u0632 \u06cc\u06a9 \u0645\u06a9\u0627\u0646 \u0646\u06af\u0647\u062f\u0627\u0631\u0646\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f {from_name}<\/code> \u0627\u06cc\u0646 \u06cc\u0627 \u0646\u0627\u0645 \u0634\u06cc\u0621 \u06a9\u0627\u0645\u0644\u0627\u064b \u0648\u0627\u062c\u062f \u0634\u0631\u0627\u06cc\u0637 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u0645\u06cc \u0634\u0648\u062f (\u062f\u0631 \u0635\u0648\u0631\u062a \u0627\u0631\u0627\u0626\u0647 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0633\u0641\u0627\u0631\u0634\u06cc) \u06cc\u0627 \u0646\u0627\u0645 \u0634\u06cc\u0621 \u0645\u0648\u0642\u062a (\u062f\u0631 \u0635\u0648\u0631\u062a \u0627\u0631\u0627\u0626\u0647 SQL \u0633\u0641\u0627\u0631\u0634\u06cc).<\/p>\n

    -\u062a\u0648\u0627\u0628\u0639 \u06cc\u0627\u0648\u0631 _to_dict \u0648 _normalize_aggregate \u0628\u0631\u0627\u06cc \u062a\u0628\u062f\u06cc\u0644 \u0646\u062a\u0627\u06cc\u062c \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0644 \u0628\u0647 \u0641\u0631\u0647\u0646\u06af \u0644\u063a\u062a \u0647\u0627\u06cc \u0645\u062a\u0639\u0627\u0631\u0641 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f \u0628\u0647 \u0637\u0648\u0631\u06cc \u06a9\u0647 \u0645\u0642\u0627\u062f\u06cc\u0631 \u0639\u062f\u062f\u06cc (\u06af\u0631\u062f) \u060c datetime (\u0628\u0631\u0634 \u062e\u0648\u0631\u062f\u0647) \u0648 \u0631\u0634\u062a\u0647 (\u067e\u0627\u06cc\u06cc\u0646 \u060c \u0633\u0644\u0628 \u0634\u062f\u0647) \u0628\u0647 \u062f\u0631\u0633\u062a\u06cc \u0645\u0642\u0627\u06cc\u0633\u0647 \u0645\u06cc \u0634\u0648\u0646\u062f \u060c \u062d\u062a\u06cc \u0627\u06af\u0631 \u06cc\u06a9 \u0637\u0631\u0641 \u06cc\u06a9 \u062a\u0648\u067e \u0631\u0627 \u0628\u0627\u0632\u06af\u0631\u062f\u0627\u0646\u062f \u0648 \u062f\u06cc\u06af\u0631\u06cc \u06cc\u06a9 \u062f\u06cc\u06a9\u062a.<\/p>\n<\/li>\n

  4. \n

    \u062c\u0631\u06cc\u0627\u0646 \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc<\/strong><\/p>\n

    – \u0631\u0648\u0646\u062f \u06a9\u0644\u06cc:<\/p>\n

    \u0627\u0644\u0641 \u0646\u0627\u0645 \u0645\u0646\u0628\u0639 \u0648 \u0647\u062f\u0641 \u0631\u0627 \u062a\u0639\u06cc\u06cc\u0646 \u06a9\u0646\u06cc\u062f (\u0648 \u062f\u0631 \u0635\u0648\u0631\u062a \u0644\u0632\u0648\u0645 “\u0622\u0645\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f”).<\/p>\n

    \u0628. \u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u06a9\u0644 \u061b \u0627\u06af\u0631 \u0645\u062a\u0641\u0627\u0648\u062a \u0647\u0633\u062a\u0646\u062f \u060c \u0627\u0639\u062a\u0628\u0627\u0631 \u0628\u06cc\u0634\u062a\u0631\u06cc \u0631\u0627 \u0645\u062a\u0648\u0642\u0641 \u06a9\u0646\u06cc\u062f.<\/p>\n

    \u062c. \u0628\u0647 \u0635\u0648\u0631\u062a \u0627\u062e\u062a\u06cc\u0627\u0631\u06cc \u0686\u06a9 \u0647\u0627\u06cc \u062a\u06a9\u0631\u0627\u0631\u06cc \u0648 \u0686\u06a9 \u0647\u0627\u06cc \u062a\u0647\u06cc \u0631\u0627 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f.<\/p>\n

    \u062f. \u0627\u0632 \u0647\u0631 \u0637\u0631\u0641 \u0627\u0628\u0631\u062f\u0627\u062f\u0647 \u0631\u0627 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u06a9\u0646\u06cc\u062f \u0648 \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0646\u06cc\u062f (\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u062a\u0639\u062f\u0627\u062f \u0633\u062a\u0648\u0646 \u0647\u0627 \u060c \u0646\u0627\u0645 \u0647\u0627\u06cc \u0645\u0637\u0627\u0628\u0642\u062a \u0648 \u0627\u0646\u0648\u0627\u0639 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0642\u0627\u0628\u0644 \u0642\u0628\u0648\u0644).<\/p>\n

    \u0647. \u0628\u0631\u0627\u06cc \u0647\u0631 \u0633\u062a\u0648\u0646 \u060c \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u06a9\u0644 \u0631\u0627 \u0627\u062c\u0631\u0627 \u06a9\u0646\u06cc\u062f (\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 “from_name” \u0645\u0646\u0627\u0633\u0628 \u0633\u0627\u062e\u062a\u0647 \u0634\u062f\u0647 \u0648 \u0633\u067e\u0633 \u062c\u0645\u0639 \u0622\u0648\u0631\u06cc \u0647\u0627\u06cc \u0646\u0631\u0645\u0627\u0644 \u0634\u062f\u0647 Field -by -Field \u0631\u0627 \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0646\u06cc\u062f.
    – \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645 \u062f\u0642\u06cc\u0642 \u062f\u0631 \u0647\u0631 \u0645\u0631\u062d\u0644\u0647 \u0627\u0635\u0644\u06cc \u0627\u0636\u0627\u0641\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u0628\u0627 \u0627\u0645\u062a\u062d\u0627\u0646\/\u0628\u0647 \u062c\u0632 \u0628\u0644\u0648\u06a9 \u0647\u0627 \u0628\u0631\u0627\u06cc \u06af\u0631\u0641\u062a\u0646 \u062e\u0637\u0627 \u0648 \u0627\u062f\u0627\u0645\u0647 \u0628\u0627 \u0644\u0637\u0641.<\/p>\n<\/li>\n

  5. \n

    \u0637\u0631\u0627\u062d\u06cc \u0645\u062f\u0648\u0644\u0627\u0631 \u0648 \u0627\u0633\u062a\u062d\u06a9\u0627\u0645<\/strong><\/p>\n

    -\u06a9\u062f \u0628\u0647 \u062f\u0646\u0628\u0627\u0644 \u0627\u0635\u0648\u0644 \u062c\u0627\u0645\u062f \u060c \u062e\u0634\u06a9 \u060c \u0628\u0648\u0633\u0647 \u0648 yagni \u0628\u0647 \u0631\u0648\u0634\u0647\u0627\u06cc \u06a9\u0648\u0686\u06a9 \u0648 \u062f\u0627\u0631\u0627\u06cc \u062e\u0648\u062f \u0634\u06a9\u0633\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n

    – \u0647\u0645\u0647 \u0635\u0627\u062d\u0628\u062e\u0627\u0646\u0647 \u0647\u0627 (\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 {from_name}<\/code>) \u0648 \u067e\u0627\u0631\u0627\u0645\u062a\u0631\u0647\u0627\u06cc \u0627\u0636\u0627\u0641\u06cc \u0627\u0632 \u0637\u0631\u06cc\u0642 QueryFormatter \u0645\u0627 \u062a\u0632\u0631\u06cc\u0642 \u0645\u06cc \u0634\u0648\u0646\u062f.
    – \u062f\u0631 \u0635\u0648\u0631\u062a \u0628\u0631\u0648\u0632 \u0647\u0631\u06af\u0648\u0646\u0647 \u062e\u0637\u0627\u06cc\u06cc (\u0628\u0647 \u0639\u0646\u0648\u0627\u0646 \u0645\u062b\u0627\u0644 \u0642\u0627\u0644\u0628 \u0628\u0646\u062f\u06cc \u060c \u0627\u062c\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648 \u060c \u0627\u06cc\u062c\u0627\u062f \u062c\u062f\u0648\u0644 \u0645\u0648\u0642\u062a) \u060c \u0627\u0632 \u0622\u0646 \u06af\u0631\u0641\u062a\u0647 \u0645\u06cc \u0634\u0648\u062f \u060c \u0648\u0627\u0631\u062f \u0645\u06cc \u0634\u0648\u062f \u0648 \u0627\u0632 \u0645\u0642\u062f\u0627\u0631 \u0628\u0631\u06af\u0634\u062a\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n<\/li>\n<\/ol>\n

    \u062f\u0631 \u0632\u06cc\u0631 \u06a9\u062f \u06a9\u0627\u0645\u0644 \u0627\u0633\u062a. (\u0645\u0646 \u0622\u0646 \u0631\u0627 \u062f\u0631 \u062f\u0648 \u0628\u062e\u0634 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u0645.) <\/p>\n

    \u00b0<\/p>\n

    \u0642\u0633\u0645\u062a 1: \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u060c \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc \u0648 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc (\u0627\u0632 \u062c\u0645\u0644\u0647 query_formatter \u0648 metadata_fetcher)<\/strong><\/p>\n\n

    \u067e\u0631\u0648\u0646\u062f\u0647: \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc\/bigQuery_config.yaml<\/strong><\/p>\n

    \n
    use_database<\/span>:<\/span> \"<\/span>SELECT<\/span> <\/span>'{database}'<\/span> <\/span>AS<\/span> <\/span>active_database;\"<\/span>\ntotal_rows<\/span>:<\/span> ><\/span>\n  SELECT COUNT(*) AS total_rows <\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NOT NULL;<\/span>\nnumeric<\/span>:<\/span> ><\/span>\n  SELECT MIN({column}) AS min_value,<\/span>\n         MAX({column}) AS max_value,<\/span>\n         AVG({column}) AS avg_value,<\/span>\n         SUM({column}) AS sum_value,<\/span>\n         COUNT(DISTINCT {column}) AS distinct_count<\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NOT NULL;<\/span>\nstring<\/span>:<\/span> ><\/span>\n  SELECT TO_HEX(MD5(CAST({column} AS STRING))) AS hash_value<\/span>\n  FROM {from_name} {where_clause};<\/span>\nstring_all<\/span>:<\/span> ><\/span>\n  SELECT TO_HEX(MD5(STRING_AGG(CAST({column} AS STRING), '' ORDER BY {column}))) AS hash_value<\/span>\n  FROM {from_name} {where_clause};<\/span>\ndatetime<\/span>:<\/span> ><\/span>\n  SELECT MIN({column}) AS min_datetime,<\/span>\n         MAX({column}) AS max_datetime,<\/span>\n         COUNT(DISTINCT DATE({column})) AS distinct_dates <\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NOT NULL;<\/span>\nnull_check<\/span>:<\/span> ><\/span>\n  SELECT COUNT(*) AS missing_values <\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NULL;<\/span>\nduplicate_check<\/span>:<\/span> ><\/span>\n  SELECT {column}, COUNT(*) AS duplicate_count<\/span>\n  FROM {from_name} {where_clause}<\/span>\n  GROUP BY {column}<\/span>\n  HAVING COUNT(*) > 1;<\/span>\n<\/code><\/pre>\n
    \n
    \n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
        \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n
    \u067e\u0631\u0648\u0646\u062f\u0647: \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc\/snowflake_config.yaml<\/strong><\/p>\n
    \n
    use_database<\/span>:<\/span> \"<\/span>USE<\/span> <\/span>DATABASE<\/span> <\/span>{database};\"<\/span>\ntotal_rows<\/span>:<\/span> \"<\/span>SELECT<\/span> <\/span>COUNT(*)<\/span> <\/span>AS<\/span> <\/span>total_rows<\/span> <\/span>FROM<\/span> <\/span>{from_name}<\/span> <\/span>{where_clause};\"<\/span>\nnumeric<\/span>:<\/span> ><\/span>\n  SELECT MIN({column}) AS min_value,<\/span>\n         MAX({column}) AS max_value,<\/span>\n         AVG({column}) AS avg_value,<\/span>\n         SUM({column}) AS sum_value,<\/span>\n         COUNT(DISTINCT {column}) AS distinct_count<\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NOT NULL;<\/span>\nstring<\/span>:<\/span> ><\/span>\n  SELECT MD5(CAST({column} AS STRING)) AS hash_value<\/span>\n  FROM {from_name} {where_clause};<\/span>\nstring_all<\/span>:<\/span> ><\/span>\n  SELECT MD5(LISTAGG(CAST({column} AS STRING), '' ORDER BY {column})) AS hash_value<\/span>\n  FROM {from_name} {where_clause};<\/span>\ndatetime<\/span>:<\/span> ><\/span>\n  SELECT MIN({column}) AS min_datetime,<\/span>\n         MAX({column}) AS max_datetime,<\/span>\n         COUNT(DISTINCT TO_DATE({column})) AS distinct_dates<\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NOT NULL;<\/span>\nnull_check<\/span>:<\/span> \"<\/span>SELECT<\/span> <\/span>COUNT(*)<\/span> <\/span>AS<\/span> <\/span>missing_values<\/span> <\/span>FROM<\/span> <\/span>{from_name}<\/span> <\/span>WHERE<\/span> <\/span>{column}<\/span> <\/span>IS<\/span> <\/span>NULL<\/span> <\/span>{where_clause};\"<\/span>\nduplicate_check<\/span>:<\/span> ><\/span>\n  SELECT {column}, COUNT(*) AS duplicate_count<\/span>\n  FROM {from_name} {where_clause}<\/span>\n  GROUP BY {column}<\/span>\n  HAVING COUNT(*) > 1;<\/span>\n<\/code><\/pre>\n
    \n
    \n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
        \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n
    \u067e\u0631\u0648\u0646\u062f\u0647: \u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc\/sqlserver_config.yaml<\/strong><\/p>\n
    \n
    use_database<\/span>:<\/span> \"<\/span>USE<\/span> <\/span>{database};\"<\/span>\ntotal_rows<\/span>:<\/span> \"<\/span>SELECT<\/span> <\/span>COUNT(*)<\/span> <\/span>AS<\/span> <\/span>total_rows<\/span> <\/span>FROM<\/span> <\/span>{from_name}<\/span> <\/span>{where_clause};\"<\/span>\nnumeric<\/span>:<\/span> ><\/span>\n  SELECT MIN({column}) AS min_value,<\/span>\n         MAX({column}) AS max_value,<\/span>\n         AVG({column}) AS avg_value,<\/span>\n         SUM({column}) AS sum_value,<\/span>\n         COUNT(DISTINCT {column}) AS distinct_count<\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NOT NULL;<\/span>\nstring<\/span>:<\/span> ><\/span>\n  SELECT CONVERT(VARCHAR(64), HASHBYTES('MD5', CAST({column} AS VARCHAR)), 2) AS hash_value<\/span>\n  FROM {from_name} {where_clause};<\/span>\nstring_all<\/span>:<\/span> ><\/span>\n  SELECT CONVERT(VARCHAR(64), HASHBYTES('MD5', (<\/span>\n      SELECT STRING_AGG(CAST({column} AS VARCHAR), '' ORDER BY {column})<\/span>\n      FROM {from_name} {where_clause}<\/span>\n  )), 2) AS hash_value;<\/span>\ndatetime<\/span>:<\/span> ><\/span>\n  SELECT MIN({column}) AS min_datetime,<\/span>\n         MAX({column}) AS max_datetime,<\/span>\n         COUNT(DISTINCT CONVERT(date, {column})) AS distinct_dates <\/span>\n  FROM {from_name} {where_clause}<\/span>\n  WHERE {column} IS NOT NULL;<\/span>\nnull_check<\/span>:<\/span> \"<\/span>SELECT<\/span> <\/span>COUNT(*)<\/span> <\/span>AS<\/span> <\/span>missing_values<\/span> <\/span>FROM<\/span> <\/span>{from_name}<\/span> <\/span>WHERE<\/span> <\/span>{column}<\/span> <\/span>IS<\/span> <\/span>NULL<\/span> <\/span>{where_clause};\"<\/span>\nduplicate_check<\/span>:<\/span> ><\/span>\n  SELECT {column}, COUNT(*) AS duplicate_count<\/span>\n  FROM {from_name} {where_clause}<\/span>\n  GROUP BY {column}<\/span>\n  HAVING COUNT(*) > 1;<\/span>\n<\/code><\/pre>\n
    \n
    \n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
        \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n
    \u067e\u0631\u0648\u0646\u062f\u0647: \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc\/\u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc_\u062f\u0627\u062a\u0627. csv<\/strong><\/p>\n
    \n
    mapping_id,source_name,source_object_type,target_name,target_object_type,validation_mode,where_clause,exclude_columns\n1,db.schema.object_name,table,db.schema.target_object_name,table,column,,,\n<\/code><\/pre>\n
    \n
    \n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
        \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
    (\u062a\u0648\u062c\u0647: \u0628\u0631\u0627\u06cc \u067e\u0631\u0633 \u0648 \u062c\u0648\u0647\u0627\u06cc \u0633\u0641\u0627\u0631\u0634\u06cc \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648 \u0628\u0627 \u0634\u0631\u0648\u0639 “\u0627\u0646\u062a\u062e\u0627\u0628” \u06cc\u0627 \u0645\u0633\u06cc\u0631 \u067e\u0631\u0648\u0646\u062f\u0647 .sql \u062f\u0631 Source_Name\/Target_Name \u0642\u0631\u0627\u0631 \u062f\u0647\u06cc\u062f.)<\/em><\/p>\n\n
    \u067e\u0631\u0648\u0646\u062f\u0647: UTILS\/Config_Loader.py<\/strong><\/p>\n
    \n
    import<\/span> os<\/span>\nimport<\/span> yaml<\/span>\nimport<\/span> logging<\/span>\n\nclass<\/span> ConfigLoader<\/span>:<\/span>\n    def<\/span> get_db_config<\/span>(<\/span>self<\/span>,<\/span> db_type<\/span>:<\/span> str<\/span>)<\/span> -><\/span> dict<\/span>:<\/span>\n        if<\/span> not<\/span> db_type<\/span>:<\/span>\n            raise<\/span> ValueError<\/span>(<\/span>\"<\/span>Database type must be provided.<\/span>\"<\/span>)<\/span>\n        normalized<\/span> =<\/span> db_type<\/span>.<\/span>strip<\/span>().<\/span>replace<\/span>(<\/span>\"<\/span> <\/span>\"<\/span>,<\/span> \"<\/span>_<\/span>\"<\/span>).<\/span>lower<\/span>()<\/span>\n        config_path<\/span> =<\/span> os<\/span>.<\/span>path<\/span>.<\/span>join<\/span>(<\/span>\"<\/span>config<\/span>\"<\/span>,<\/span> f<\/span>\"<\/span>{<\/span>normalized<\/span>}<\/span>_config.yaml<\/span>\"<\/span>)<\/span>\n        if<\/span> os<\/span>.<\/span>path<\/span>.<\/span>exists<\/span>(<\/span>config_path<\/span>):<\/span>\n            try<\/span>:<\/span>\n                with<\/span> open<\/span>(<\/span>config_path<\/span>,<\/span> \"<\/span>r<\/span>\"<\/span>)<\/span> as<\/span> f<\/span>:<\/span>\n                    logging<\/span>.<\/span>info<\/span>(<\/span>f<\/span>\"<\/span>Loading configuration from: <\/span>{<\/span>config_path<\/span>}<\/span>\"<\/span>)<\/span>\n                    return<\/span> yaml<\/span>.<\/span>safe_load<\/span>(<\/span>f<\/span>)<\/span> or<\/span> {}<\/span>\n            except<\/span> Exception<\/span> as<\/span> exc<\/span>:<\/span>\n                logging<\/span>.<\/span>error<\/span>(<\/span>f<\/span>\"<\/span>Error loading config file <\/span>{<\/span>config_path<\/span>}<\/span>: <\/span>{<\/span>exc<\/span>}<\/span>\"<\/span>)<\/span>\n                raise<\/span>\n        logging<\/span>.<\/span>warning<\/span>(<\/span>f<\/span>\"<\/span>No config file found for database type: <\/span>{<\/span>normalized<\/span>}<\/span>\"<\/span>)<\/span>\n        return<\/span> {}<\/span>\n<\/code><\/pre>\n
    \n
    \n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
        \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n\n
    \u067e\u0631\u0648\u0646\u062f\u0647: \u0627\u0633\u062a\u0641\u0627\u062f\u0647\/\u06cc\u0627\u0631\u0627\u0646 .py<\/strong><\/p>\n
    \n
    import<\/span> datetime<\/span>\n\ndef<\/span> get_field_value<\/span>(<\/span>row<\/span>,<\/span> field_name<\/span>):<\/span>\n    try<\/span>:<\/span>\n        if<\/span> hasattr<\/span>(<\/span>row<\/span>,<\/span> \"<\/span>keys<\/span>\"<\/span>):<\/span>\n            return<\/span> row<\/span>[<\/span>field_name<\/span>]<\/span>\n        elif<\/span> isinstance<\/span>(<\/span>row<\/span>,<\/span> dict<\/span>):<\/span>\n            return<\/span> row<\/span>.<\/span>get<\/span>(<\/span>field_name<\/span>)<\/span>\n        else<\/span>:<\/span>\n            return<\/span> row<\/span>[<\/span>0<\/span>]<\/span>\n    except<\/span> Exception<\/span> as<\/span> e<\/span>:<\/span>\n        print<\/span>(<\/span>f<\/span>\"<\/span>[ERROR] Failed to get field <\/span>'<\/span>{<\/span>field_name<\/span>}<\/span>'<\/span>: <\/span>{<\/span>e<\/span>}<\/span>\"<\/span>)<\/span>\n        return<\/span> None<\/span>\n\ndef<\/span> normalize_value<\/span>(<\/span>value<\/span>,<\/span> data_category<\/span>:<\/span> str<\/span>):<\/span>\n    if<\/span> data_category<\/span> ==<\/span> \"<\/span>numeric<\/span>\"<\/span>:<\/span>\n        try<\/span>:<\/span>\n            return<\/span> round<\/span>(<\/span>float<\/span>(<\/span>value<\/span>),<\/span> 2<\/span>)<\/span>\n        except<\/span> Exception<\/span>:<\/span>\n            return<\/span> value<\/span>\n    elif<\/span> data_category<\/span> ==<\/span> \"<\/span>datetime<\/span>\"<\/span>:<\/span>\n        if<\/span> isinstance<\/span>(<\/span>value<\/span>,<\/span> (<\/span>datetime<\/span>.<\/span>date<\/span>,<\/span> datetime<\/span>.<\/span>datetime<\/span>)):<\/span>\n            return<\/span> value<\/span>.<\/span>strftime<\/span>(<\/span>\"<\/span>%Y-%m-%d<\/span>\"<\/span>)<\/span>\n        return<\/span> str<\/span>(<\/span>value<\/span>).<\/span>strip<\/span>()<\/span>\n    elif<\/span> data_category<\/span> ==<\/span> \"<\/span>string<\/span>\"<\/span>:<\/span>\n        return<\/span> str<\/span>(<\/span>value<\/span>).<\/span>strip<\/span>().<\/span>lower<\/span>()<\/span>\n    else<\/span>:<\/span>\n        return<\/span> value<\/span>\n\ndef<\/span> normalize_rows<\/span>(<\/span>rows<\/span>,<\/span> data_category<\/span>:<\/span> str<\/span>):<\/span>\n    if<\/span> not<\/span> rows<\/span>:<\/span>\n        return<\/span> rows<\/span>\n    normalized<\/span> =<\/span> []<\/span>\n    for<\/span> row<\/span> in<\/span> rows<\/span>:<\/span>\n        try<\/span>:<\/span>\n            if<\/span> hasattr<\/span>(<\/span>row<\/span>,<\/span> \"<\/span>keys<\/span>\"<\/span>):<\/span>\n                norm<\/span> =<\/span> {<\/span>key<\/span>:<\/span> normalize_value<\/span>(<\/span>row<\/span>[<\/span>key<\/span>],<\/span> data_category<\/span>)<\/span> for<\/span> key<\/span> in<\/span> row<\/span>.<\/span>keys<\/span>()}<\/span>\n            else<\/span>:<\/span>\n                norm<\/span> =<\/span> tuple<\/span>(<\/span>normalize_value<\/span>(<\/span>val<\/span>,<\/span> data_category<\/span>)<\/span> for<\/span> val<\/span> in<\/span> row<\/span>)<\/span>\n        except<\/span> Exception<\/span>:<\/span>\n            norm<\/span> =<\/span> row<\/span>\n        normalized<\/span>.<\/span>append<\/span>(<\/span>norm<\/span>)<\/span>\n    return<\/span> normalized<\/span>\n\ndef<\/span> classify_dtype<\/span>(<\/span>dtype_str<\/span>:<\/span> str<\/span>)<\/span> -><\/span> str<\/span>:<\/span>\n    dtype_str<\/span> =<\/span> dtype_str<\/span>.<\/span>lower<\/span>()<\/span>\n    if<\/span> any<\/span>(<\/span>token<\/span> in<\/span> dtype_str<\/span> for<\/span> token<\/span> in<\/span> [<\/span>\"<\/span>int<\/span>\"<\/span>,<\/span> \"<\/span>bigint<\/span>\"<\/span>,<\/span> \"<\/span>smallint<\/span>\"<\/span>,<\/span> \"<\/span>tinyint<\/span>\"<\/span>,<\/span> \"<\/span>decimal<\/span>\"<\/span>,<\/span> \"<\/span>numeric<\/span>\"<\/span>,<\/span> \"<\/span>float<\/span>\"<\/span>,<\/span> \"<\/span>real<\/span>\"<\/span>,<\/span> \"<\/span>number<\/span>\"<\/span>,<\/span> \"<\/span>double<\/span>\"<\/span>]):<\/span>\n        return<\/span> \"<\/span>numeric<\/span>\"<\/span>\n    if<\/span> any<\/span>(<\/span>token<\/span> in<\/span> dtype_str<\/span> for<\/span> token<\/span> in<\/span> [<\/span>\"<\/span>varchar<\/span>\"<\/span>,<\/span> \"<\/span>nvarchar<\/span>\"<\/span>,<\/span> \"<\/span>char<\/span>\"<\/span>,<\/span> \"<\/span>text<\/span>\"<\/span>,<\/span> \"<\/span>string<\/span>\"<\/span>]):<\/span>\n        return<\/span> \"<\/span>string<\/span>\"<\/span>\n    if<\/span> any<\/span>(<\/span>token<\/span> in<\/span> dtype_str<\/span> for<\/span> token<\/span> in<\/span> [<\/span>\"<\/span>date<\/span>\"<\/span>,<\/span> \"<\/span>datetime<\/span>\"<\/span>,<\/span> \"<\/span>datetime2<\/span>\"<\/span>,<\/span> \"<\/span>timestamp<\/span>\"<\/span>,<\/span> \"<\/span>time<\/span>\"<\/span>]):<\/span>\n        return<\/span> \"<\/span>datetime<\/span>\"<\/span>\n    return<\/span> \"<\/span>string<\/span>\"<\/span>\n\ndef<\/span> load_query_from_file<\/span>(<\/span>file_path<\/span>:<\/span> str<\/span>,<\/span> params<\/span>:<\/span> dict<\/span>)<\/span> -><\/span> str<\/span>:<\/span>\n    try<\/span>:<\/span>\n        with<\/span> open<\/span>(<\/span>file_path<\/span>,<\/span> \"<\/span>r<\/span>\"<\/span>)<\/span> as<\/span> f<\/span>:<\/span>\n            template<\/span> =<\/span> f<\/span>.<\/span>read<\/span>()<\/span>\n        return<\/span> template<\/span>.<\/span>format<\/span>(<\/span>**<\/span>params<\/span>)<\/span>\n    except<\/span> Exception<\/span> as<\/span> e<\/span>:<\/span>\n        print<\/span>(<\/span>f<\/span>\"<\/span>[ERROR] Failed to load query from <\/span>'<\/span>{<\/span>file_path<\/span>}<\/span>'<\/span>: <\/span>{<\/span>e<\/span>}<\/span>\"<\/span>)<\/span>\n        return<\/span> \"\"<\/span>\n<\/code><\/pre>\n
    \n
    \n    \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0631\u0627 \u0648\u0627\u0631\u062f \u06a9\u0646\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
        \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
    \u00b0<\/p>\n
    \u06a9\u0647 \u0642\u0633\u0645\u062a 1 \u0628\u0647 \u067e\u0627\u06cc\u0627\u0646 \u0645\u06cc \u0631\u0633\u062f.<\/strong> <\/p>\n
    \u062f\u0631 \u0642\u0633\u0645\u062a 2 \u060c \u0645\u0627 Datavalidator Core (\u06a9\u0647 \u0646\u0645\u0627\u06cc\u0634 \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0633\u0641\u0627\u0631\u0634\u06cc \u060c \u0627\u06cc\u062c\u0627\u062f \u0634\u06cc\u0621 \u062f\u0645\u0627 \u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0628\u0631\u062f\u0627\u062f\u0647 \u060c \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc \u06a9\u0644 \u0648 \u0648\u0631\u0648\u062f \u0628\u0647 \u0633\u06cc\u0633\u062a\u0645) \u0648 \u067e\u0631\u0648\u0646\u062f\u0647 \u0627\u0635\u0644\u06cc \u0631\u0627 \u0634\u0627\u0645\u0644 \u0645\u06cc \u0634\u0648\u062f. <\/p>\n
    \u0644\u0637\u0641\u0627\u064b \u0642\u0633\u0645\u062a 2 \u0631\u0627 \u062f\u0631 \u067e\u0627\u0633\u062e \u0628\u0639\u062f\u06cc \u0628\u0628\u06cc\u0646\u06cc\u062f.<\/p>\n
    \u062f\u0631 \u0632\u06cc\u0631 \u06a9\u062f \u0642\u0633\u0645\u062a \u062f\u0648\u0645 – \u06cc\u0639\u0646\u06cc \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c \u0627\u0635\u0644\u06cc (\u0628\u0627 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0627\u0632 \u0647\u062f\u0641 \u0645\u0648\u0642\u062a \u060c \u062a\u0639\u0648\u06cc\u0636 \u0645\u0646\u0627\u0633\u0628 \u062f\u0631 \u0645\u062d\u0644 \u060c \u0627\u0633\u062a\u062e\u0631\u0627\u062c \u0627\u0628\u0631\u062f\u0627\u062f\u0647 \u060c \u0639\u0627\u062f\u06cc \u0633\u0627\u0632\u06cc \u06a9\u0644 \u0648 \u0627\u0639\u062a\u0628\u0627\u0631 \u0633\u0646\u062c\u06cc) \u0628\u0647 \u0639\u0644\u0627\u0648\u0647 \u067e\u0631\u0648\u0646\u062f\u0647 \u0627\u0635\u0644\u06cc \u0627\u0631\u06a9\u0633\u062a\u0631\u0627\u0633\u06cc\u0648\u0646 \u0627\u0633\u062a. \u0634\u0645\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0627\u0632 \u0627\u06cc\u0646 \u0628\u0647 \u0639\u0646\u0648\u0627\u0646 “\u0642\u0633\u0645\u062a 2” \u062f\u0631 \u0631\u0627\u0647 \u062d\u0644 \u062e\u0648\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u06a9\u0646\u06cc\u062f. \u0627\u0637\u0645\u06cc\u0646\u0627\u0646 \u062d\u0627\u0635\u0644 \u06a9\u0646\u06cc\u062f \u06a9\u0647 \u0642\u0628\u0644\u0627\u064b \u067e\u0631\u0648\u0646\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0627\u0632 \u0642\u0633\u0645\u062a 1 (\u067e\u06cc\u06a9\u0631\u0628\u0646\u062f\u06cc \u060c \u0646\u0642\u0634\u0647 \u0628\u0631\u062f\u0627\u0631\u06cc CSV \u0648 \u0628\u0631\u0646\u0627\u0645\u0647 \u0647\u0627\u06cc \u06a9\u0627\u0631\u0628\u0631\u062f\u06cc) \u062a\u0639\u0631\u06cc\u0641 \u06a9\u0631\u062f\u0647 \u0627\u06cc\u062f. <\/p>\n\n
    \n
    \n
    \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\nToggle<\/span><\/path><\/svg><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n