Datero is an open-source data platform which allows users to query heterogeneous datasources via plain SQL. It can join data from different sources such as CSV files, SQL and NoSQL databases via a single SELECT statement. Instead of creating services or ETLs to different datasources directly, you just need a single connection to Datero.

Datero is shipped as a single container and can be run on any infrastructure which supports containers. This includes EC2, ECS, EKS. It can also be run on-premises or on your laptop.

It has a web based UI which allows managing connections and features a built-in SQL query editor. Within minutes you can connect to your data sources and start querying them via SQL.

Built on top of the official Postgres database container. Fully functional RDBMS at your disposal. You can connect to it using any GUI SQL client such as DBeaver, Tableau, PowerBI, etc. You could also use any programming language which has a Postgres driver such as Python, Java, Node.js, etc.

Thanks to its containerized nature, Datero can be used as an intermediate ETL or data virtualization layer. You could dynamically spin-up the container by providing it with connections configuration file and then shut it down when it's not needed. Subject to connector availability, Datero can write data back to sources, thus providing Reverse ETL capabilities.

AWS Guide: https://datero.tech/docs/clouds/aws/
Overview: https://datero.tech/docs/overview/
Tutorial: https://datero.tech/docs/tutorial/
Installation: https://datero.tech/docs/installation/