sqlmesh
Mage
| sqlmesh | Mage | |
|---|---|---|
| 12 | 77 | |
| 1,296 | 7,085 | |
| 8.7% | 4.0% | |
| 9.9 | 9.9 | |
| 4 days ago | 5 days ago | |
| Python | Python | |
| Apache License 2.0 | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqlmesh
-
Launch HN: Serra (YC S23) – Open-source, Python-based dbt alternative
There is also sqlmesh (https://sqlmesh.com/). Pretty new as well. It introduces some interesting concepts. For smaller dbt projects it could be a drop-in replacement as it allows importing dbt projects.
-
DBT lays off 15% of their staff
I agree with you that they don't have a competitor yet. I think https://sqlmesh.com will be that competitor in the not too distant future though.
- SQL Mesh - Auto DAG generation!!
-
Data transformation tools other than DBT
SQLMesh is a new SQL templating framework that addresses some of dbt's biggest gaps (column lineage, unit testing). It's not an enterprise solution, but it's an interesting project. https://github.com/TobikoData/sqlmesh
-
Semantic Understanding of SQL
It’s a part of the SQLMesh IDE: https://github.com/TobikoData/sqlmesh
- Virtual Data Environments
- Blog Post on how DoorDash used the metrics layer to scale and standardize Metrics for Experimentation
- A dbt killer is born (SQLMesh)
-
SQLMesh: The future of DataOps
If you don't plan on using Airflow, you can just add a custom connection implementation using one of the existing ones as a reference.
Mage
- FLaNK AI-April 22, 2024
-
A mage on the Hero’s Journey: a fantasy epic on how a startup rose from the ashes
In the coming years, Mage will create a cooperative experience so that developers can build data pipelines with their team and level up together. After that journey, Mage will go on an epic quest to create the 1st open world community experience in the data universe.
-
Data sources episode 2: AWS S3 to Postgres Data Sync using Singer
Link to original blog: https://www.mage.ai/blog/data-sources-ep-2-aws-s3-to-postgres-data-sync-using-singer
-
What are some open-source ML pipeline managers that are easy to use?
I would recommend the following: - https://www.mage.ai/ - https://dagster.io/ - https://www.prefect.io/ - https://metaflow.org/ - https://zenml.io/home
-
Mage Battlegrounds: Craft insights from real-time customer behavior analysis
You're invited to participate in the very first Mage Battlegrounds: Craft insights from real-time customer behavior analysis, a 24-hour virtual hackathon hosted by Shashank Mishra! This data engineering competition will take place on Saturday, April 15, 2023 beginning at 11am (PST). This will be a global event open to all participants who register.
-
Looking for an open-source project
Try this feature: https://github.com/mage-ai/mage-ai/issues/1166
-
Daskqueue: Dask-based distributed task queue
Seeing if we can use it in https://github.com/mage-ai/mage-ai
-
Data Pipeline on a Shoestring
That being said there’s a solid family of services just breaking ground that make the local pipeline deployment easier (check out https://www.mage.ai, which does have a clear path to cloud deployment of locally developed pipes, it just isn’t well documented yet, and also https://www.neuronsphere.io - which doesn’t have a public solution YET (they’re internally testing an alpha) but they built a cloud deployable solution for their paying customers and working to release one for freemium use)
-
Trending ML repos of the week 📈
7️⃣ mage-ai/mage-ai
-
Delta without using Spark
Yes, check out how Mage does it: https://github.com/mage-ai/mage-ai/tree/master/mage_integrations/mage_integrations/destinations/delta_lake_s3
What are some alternatives?
dbd - dbd is a database prototyping tool that enables data analysts and engineers to quickly load and transform data in SQL databases.
dagster - An orchestration platform for the development, production, and observation of data assets.
dbt-coves - CLI tool for dbt users to simplify creation of staging models (yml and sql) files
Airflow - Apache Airflow - A platform to programmatically author, schedule, and monitor workflows
sayn - Data processing and modelling framework for automating tasks (incl. Python & SQL transformations).
vscode-dvc - Machine learning experiment tracking and data versioning with DVC extension for VS Code
astro-sdk - Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow.
mito - The mitosheet package, trymito.io, and other public Mito code.
versatile-data-kit - One framework to develop, deploy and operate data workflows with Python and SQL.
Data-Science-Roadmap - Data Science Roadmap from A to Z
astro - Astro SDK allows rapid and clean development of {Extract, Load, Transform} workflows using Python and SQL, powered by Apache Airflow. [Moved to: https://github.com/astronomer/astro-sdk]
Data-science - Collection of useful data science topics along with articles, videos, and code