dbt-athena
meltano
| dbt-athena | meltano | |
|---|---|---|
| 1 | 9 | |
| 142 | 1,764 | |
| - | 2.4% | |
| 0.0 | 9.7 | |
| over 1 year ago | 6 days ago | |
| Python | Python | |
| Apache License 2.0 | MIT License |
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.
dbt-athena
-
Personal Project Guidance
I would use something like meltano or airbyte, but if you really want to use Lambda for extraction I'd say there is no point spinning up a Redshift cluster just for that, Athena would be the way to go and you can use dbt pretty nicely with it and it would keep costs down.
meltano
-
meltano VS cloudquery - a user suggested alternative
2 projects | 2 Jun 2023
-
Show HN: Meltano Cloud (Gitlab spinout) – Managed infra for open source ELT
- https://github.com/meltano/meltano
We'd love to hear what you think of Meltano (Cloud). If you join the Beta, you get 100 free credits (200 hourly or 100 daily runs) and a 20% discount on the pricing at GA (June 27). The first 100 to sign up get 1,000 credits -- that's 83 days of hourly runs or 3 years of dailies!
The team and I will be checking in here throughout the day, so don't hesitate to ask questions! If we don't get to you, feel free to join 3,500+ Meltano fans on https://meltano.com/slack and we'll chat there!
-
Show HN: Sync’ing data to your customer’s Google Sheets
Meltano[0] might be of interest to you. Easy way to move data that should be very familiar for software engineers. If a connector doesn't exist our SDK makes it easy to build it.
[0] https://github.com/meltano/meltano
(disclaimer - I work at Meltano)
-
Meltano can now run any Airbyte source connector thanks to a community contribution
We currently don't do any process optimization on a per-stream basis when doing an extract. We have seen folks in the community running each tap separately for each stream which can speed it up. We've got an issue around this (Melturbo).
-
What is data integration?
Meltano
-
PostgreSQL to DuckDB - There and Quack Again
I built my data pipeline to Extract some data from websites and CSV files, Load it into my database, and Transform it into a reporting-ready schema. I used Python and Pandas to extract and load some of the data and Meltano to load some additional supporting data. All of that data went into a PostgreSQL database hosted in the cloud on Azure where I then used dbt to create data models in the database optimized for reporting. Finally, I use Metabase to visualize the data. (whew! that's a lot of moving parts!)
-
What should be the main point of a personal project?
I'm learning https://meltano.com/ right now, so am building custom Taps, mostly for fun. I'm enjoying it. I'm pulling in a variety of data from https://www.geonames.org/ and Canadian weather/climate data into BigQuery
-
What ETL tool you use with Postgres ?
https://meltano.com/ is ELT but I like it
- Airbyte vs Meltano community support
What are some alternatives?
airbyte - The leading data integration platform for ETL / ELT data pipelines from APIs, databases & files to data warehouses, data lakes & data lakehouses. Both self-hosted and Cloud-hosted.
Prefect - The easiest way to build, run, and monitor data pipelines at scale.
nifi - Apache NiFi
pipelinewise - Data Pipeline Framework using the singer.io spec
pipelinewise-tap-mssql - Pipelinewise tap for Microsoft SQL Server
spark-rapids - Spark RAPIDS plugin - accelerate Apache Spark with GPUs
dagster - An orchestration platform for the development, production, and observation of data assets.
Mage - 🧙 The modern replacement for Airflow. Mage is an open-source data pipeline tool for transforming and integrating data. https://github.com/mage-ai/mage-ai
singer-sdk
grouparoo - 🦘 The Grouparoo Monorepo - open source customer data sync framework
supabase - The open source Firebase alternative. Supabase gives you a dedicated Postgres database to build your web, mobile, and AI applications.