Loading...
Loading...
Search for a command to run...
Design ETL pipelines for data integration
Design an ETL pipeline for this data integration:
**Source Systems:**
{{SOURCE_SYSTEMS}}
**Target Database:**
{{TARGET_DATABASE}}
**Data Transformations:**
{{TRANSFORMATIONS}}
**Schedule Requirements:** {{SCHEDULE}}
**Data Volume:** {{DATA_VOLUME}}
**Quality Requirements:** {{QUALITY_REQUIREMENTS}}
Please provide:
1. ETL architecture diagram description
2. Extract phase design:
- Connection strategies
- Incremental extraction logic
- Change data capture approach
3. Transform phase design:
- Data cleansing rules
- Transformation logic
- Data validation
4. Load phase design:
- Loading strategy (full, incremental)
- Error handling
5. Orchestration and scheduling
6. Monitoring and logging
7. Error recovery procedures
8. Performance optimization
9. Testing strategyOr press ⌘C to copy
Replace these placeholders with your own content before using the prompt.
{{SOURCE_SYSTEMS}{{TARGET_DATABASE}{{TRANSFORMATIONS}{{SCHEDULE}{{DATA_VOLUME}{{QUALITY_REQUIREMENTS}Copy this prompt and paste it into your favorite AI tool