Back
ETL on mariaDB
Hello, I'm attempting to develop ETL processes directly within MariaDB by querying Appwrite tables. One challenge we're facing is that each environment has distinct collection names in the database. Is there a way I can influence the collection names to ensure stability in my SQL scripts?
TL;DR
Developers are seeking a way to standardize collection names for ETL processes in MariaDB querying Appwrite tables to ensure script stability across environments.
Solution: Consider using database views to unify collection names and streamline SQL scripts. 