CueObserve
bigquery_fdw
Our great sponsors
CueObserve | bigquery_fdw | |
---|---|---|
6 | 2 | |
205 | 89 | |
0.0% | - | |
0.0 | 3.9 | |
about 2 years ago | 3 months 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.
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.
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
What are some alternatives?
growthbook - Open Source Feature Flagging and A/B Testing Platform
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
dopg_cli - 🐍🐳🐘 A python command line interface for DigitalOcean postgres clusters (5+ integrations).
pyod - A Comprehensive and Scalable Python Library for Outlier Detection (Anomaly Detection)
firebird_fdw - A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.3.1 (2023-06-22)
dbt-ml-preprocessing - A SQL port of python's scikit-learn preprocessing module, provided as cross-database dbt macros.
Redash - Make Your Company Data Driven. Connect to any data source, easily visualize, dashboard and share your data.
luminol - Anomaly Detection and Correlation library
pgcli - Postgres CLI with autocompletion and syntax highlighting
diepvries - The Picnic Data Vault framework.