Facilitates the development and debugging of custom Fivetran SDK connectors for enterprise data integration.
This skill provides domain-specific guidance for building and maintaining Fivetran custom connectors using the Python SDK. It specializes in the two-file architecture comprising a sync engine and entity configuration, offering standardized patterns for schema definition, incremental sync strategies, and complex pagination. It helps developers handle technical debt in legacy architectures, implement safe null-value casting, prevent schema corruption, and establish robust testing patterns for GEOTAB, WMS, and FOCALTEC integrations.
Key Features
01Standardized afalConfiguration.py entity and table definitions
02Advanced HTTP session management with retry logic and error handling
03Mock-based testing patterns for Fivetran and external SDKs
04Incremental and offset-based synchronization strategy implementation
051 GitHub stars
06Safe null-value casting and schema mutation prevention logic
Use Cases
01Debugging data sync issues like truncated pages, skipped records, or schema corruption
02Adding new entities or tables to existing GEOTAB, WMS, or FOCALTEC connectors
03Refactoring legacy connectors to improve null handling and warehouse data quality
