Pratush12 opened a new issue, #56846:
URL: https://github.com/apache/airflow/issues/56846
### Description
## Proposal: MariaDB Provider for Apache Airflow
### Overview
I would like to contribute a comprehensive MariaDB provider to Apache
Airflow that includes:
- Native MariaDB connector support
- ColumnStore engine integration
- Bulk data loading with cpimport utility
- S3 integration for data transfer
- SSH-based remote execution
### Why a Separate MariaDB Provider?
While MySQL provider exists, MariaDB has unique features that justify a
dedicated provider:
1. **Native MariaDB Connector**: Uses `mariadb` library instead of
generic MySQL connector
2. It is seen that using Native Mariadb as a python connector performs
2-3x better for operations like insert_many, json handling and select queries.
3. **cpimport Utility**: Bulk loading functionality specific to MariaDB
ColumnStore
4. **ColumnStore Engine Support**: Validation and optimization for
ColumnStore tables
5. **S3 Integration**: Direct S3 load/dump operations
6. **SSH Integration**: Remote execution capabilities
### Components Included
- **MariaDBHook**: Main hook with native connector support
- **MariaDBOperator**: SQL execution operator
- **MariaDBCpImportOperator**: Bulk data loading for ColumnStore
- **MariaDBS3LoadOperator**: Load data from S3 to MariaDB
- **MariaDBS3DumpOperator**: Export MariaDB data to S3
- **Comprehensive test suite** with 95%+ coverage
- **Example DAGs** for all features
- **Complete documentation**
### Dependencies
- `mariadb>=1.1.0` (native connector)
- `boto3>=1.26.0` (S3 integration)
- `paramiko>=2.7.0` (SSH support)
### Implementation Status
✅ Complete provider implementation
✅ Comprehensive test suite
✅ Example DAGs
✅ Documentation
✅ Apache License headers
✅ Type hints throughout
### Questions for Community
1. Is there interest in a dedicated MariaDB provider?
2. Are there any specific requirements or concerns?
3. Should I proceed with creating a pull request?
### Use case/motivation
_No response_
### Related issues
_No response_
### Are you willing to submit a PR?
- [x] Yes I am willing to submit a PR!
### Code of Conduct
- [x] I agree to follow this project's [Code of
Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
