메뉴
Decide between Merge (stack rows / UNION) and Join (match on a key) when a chain has multiple inputs, and set keys and join type correctly. Use when a pipeline combines two or more upstream tables.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
Sequence cleaning steps in a chain — trim/case/replace, null handling, deduplication, and type casting — in the right order. Use when raw ingested data needs cleaning before joins or aggregation.
Place Assert and Schema Validation nodes as gates that halt a chain when data is wrong, so bad data never reaches the output. Use when the pipeline must guarantee correctness before exporting or loading downstream.
Choose the right sink format, compression, and destination for a chain's output, and decide between exporting a file vs creating a table. Use at the end of a pipeline when deciding how to persist results.
Best practices for loading files into a chain — single file, folder globs, type detection, and union of many files. Use when the pipeline starts from CSV/Parquet/JSON/Excel files or a folder of files.
Descompone un objetivo de procesamiento en un flujo de nodos Chains (source → transform → sink). Use when the user wants to build a data pipeline / chain, or describes an end-to-end "load X, clean it, summarize, export" goal.
Framework de razonamiento para convertir resultados de análisis en una narrativa visual clara y convincente
| name | Combinar Fuentes |
| description | Decide between Merge (stack rows / UNION) and Join (match on a key) when a chain has multiple inputs, and set keys and join type correctly. Use when a pipeline combines two or more upstream tables. |
| keywords | merge, join, combinar, unir, union, cruzar, llave, key, fuentes, multiple, append, lookup, enriquecer |
| next | data-quality-gates |
| scope | engineering |
Activa cuando el flujo tiene 2+ entradas que hay que combinar. La primera pregunta: ¿apilar filas o cruzar por llave?
UNION ALL conserva duplicados (más rápido, default); UNION los elimina.Tras combinar, valida el resultado ([[data-quality-gates]]) y sigue con agregación o export.