bigquery_fdw
CueObserve
| bigquery_fdw | CueObserve | |
|---|---|---|
| 2 | 6 | |
| 89 | 205 | |
| - | 0.0% | |
| 3.9 | 0.0 | |
| 3 months ago | about 2 years ago | |
| Python | Python | |
| MIT License | 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.
bigquery_fdw
-
Is using pandas considered terrible practice in ELT?
You can also take a look at this repo: https://github.com/gabfl/bigquery_fdw/blob/main/src/bqclient.py if not for the FDW, then at least to the python bit that reads data, though I'm not sure how well it goes through large datasets.
-
Good way to pull data from BQ to PostgreSQL?
Give this a try and report back, https://github.com/gabfl/bigquery_fdw
CueObserve
-
[Project] Open-source Anomaly detection on SQL data
We are building CueObserve, an open source repo to run anomaly detection on data in your SQL data warehouses and databases. It currently supports BigQuery, RedShift, Snowflake, Postgres, MySQL and Druid. It is available at github.com/cuebook/cueobserve.
- CueObserve - Anomaly detection on SQL data warehouses and databases
-
Show HN: CueObserve – Open-source Anomaly detection on SQL data
Hi HN, Sachin here with Ankit, Praveen, Vineet and Vikrant.
With CueObserve, you can run anomaly detection on business metric data in your SQL data warehouses and databases. CueObserve currently supports 6 data sources - BigQuery, RedShift, Snowflake, Postgres, MySQL and Druid.
CueObserve is open-source (https://github.com/cuebook/CueObserve). Docs are at https://cueobserve.cuebook.ai
Do give it a try and let us know. We’d love to hear your thoughts, feedback, and questions.
What are some alternatives?
ethereum-etl - Python scripts for ETL (extract, transform and load) jobs for Ethereum blocks, transactions, ERC20 / ERC721 tokens, transfers, receipts, logs, contracts, internal transactions. Data is available in Google BigQuery https://goo.gl/oY5BCQ
growthbook - Open Source Feature Flagging and A/B Testing Platform
dopg_cli - 🐍🐳🐘 A python command line interface for DigitalOcean postgres clusters (5+ integrations).
firebird_fdw - A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2023-06-22)
pyod - A Comprehensive and Scalable Python Library for Outlier Detection (Anomaly Detection)
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
dbt-ml-preprocessing - A SQL port of python's scikit-learn preprocessing module, provided as cross-database dbt macros.
pgcli - Postgres CLI with autocompletion and syntax highlighting
luminol - Anomaly Detection and Correlation library
diepvries - The Picnic Data Vault framework.