# Analytics Pipeline

Published articles for Analytics Pipeline.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How Procore is powering construction analytics with OpenSharing

DevFeed: [How Procore is powering construction analytics with OpenSharing](<https://devfeed.tech/articles/how-procore-is-powering-construction-analytics-with-opensharing-112964.md>)

Original publisher: [Read original article](<https://www.databricks.com/blog/how-procore-powering-construction-analytics-opensharing>)

Author: Krishan Kumar

Published: 2026-10-29T00:29:00Z

Content type: article

Language: en

Sources: [Databricks](<https://devfeed.tech/sources/databricks.md>)

Topics: [databricks](<https://devfeed.tech/topics/databricks.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Data Quality](<https://devfeed.tech/topics/data-quality.md>), [semantic-layer](<https://devfeed.tech/topics/semantic-layer.md>), [schema-evolution](<https://devfeed.tech/topics/schema-evolution.md>), [protocols](<https://devfeed.tech/topics/protocols.md>), [DataOps](<https://devfeed.tech/topics/dataops.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [ai](<https://devfeed.tech/tags/ai.md>), [ai-use](<https://devfeed.tech/tags/ai-use.md>), [all](<https://devfeed.tech/tags/all.md>), [also](<https://devfeed.tech/tags/also.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [api](<https://devfeed.tech/tags/api.md>), [apis](<https://devfeed.tech/tags/apis.md>), [app](<https://devfeed.tech/tags/app.md>), [application](<https://devfeed.tech/tags/application.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [area](<https://devfeed.tech/tags/area.md>), [asia](<https://devfeed.tech/tags/asia.md>), [australia](<https://devfeed.tech/tags/australia.md>), [company](<https://devfeed.tech/tags/company.md>), [construction](<https://devfeed.tech/tags/construction.md>), [customers](<https://devfeed.tech/tags/customers.md>), [data](<https://devfeed.tech/tags/data.md>), [one](<https://devfeed.tech/tags/one.md>), [with](<https://devfeed.tech/tags/with.md>)

### AI overview

Procore Analytics 2.0 replaces a SQL Server pipeline fed by public API extractions--which allowed at most three refreshes per day--with Databricks OpenSharing. Procore cleans, validates, and models data in a multi-region medallion pipeline, then shares gold tables to customer environments. Customers without Databricks connect with an OpenSharing token and client libraries; Databricks customers can receive shares natively. Unity Catalog permissions are reconciled automatically per user and project, and Change Data Feed lets recipients sync only updates or the full dataset. Procore reports expanding its extract catalog to hundreds of tables in less than half the time taken to build the first version, while customers can schedule refreshes to suit their tools. It also sets release notice periods: six weeks for four annual breaking changes and three weeks for twelve non-breaking releases. The source describes the architecture and reported benefits but provides no measured refresh latency or quantified cost comparison.

### Source excerpt

Connecting an industry built on disconnected dataConstruction runs on data that rarely sits in one place...

## Build a Reliable Analytics Pipeline Before Migrating to a Data Warehouse

DevFeed: [Build a Reliable Analytics Pipeline Before Migrating to a Data Warehouse](<https://devfeed.tech/articles/build-a-reliable-analytics-pipeline-before-migrating-to-a-data-warehouse-105467.md>)

Original publisher: [Read original article](<https://www.sitepoint.com/build-a-reliable-analytics-pipeline-before-migrating-to-a-data-warehouse/>)

Author: tbutt4438

Published: 2026-10-28T04:28:05Z

Content type: tutorial

Language: en

Sources: [SitePoint](<https://devfeed.tech/sources/sitepoint.md>)

Topics: [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [etl](<https://devfeed.tech/topics/etl.md>), [metric-standardization](<https://devfeed.tech/topics/metric-standardization.md>), [DataOps](<https://devfeed.tech/topics/dataops.md>)

Tags: [access-controls](<https://devfeed.tech/tags/access-controls.md>), [agile-development](<https://devfeed.tech/tags/agile-development.md>), [ai](<https://devfeed.tech/tags/ai.md>), [airflow](<https://devfeed.tech/tags/airflow.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [apache-airflow](<https://devfeed.tech/tags/apache-airflow.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [batch](<https://devfeed.tech/tags/batch.md>), [concurrency](<https://devfeed.tech/tags/concurrency.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [data](<https://devfeed.tech/tags/data.md>), [data-quality](<https://devfeed.tech/tags/data-quality.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [database](<https://devfeed.tech/tags/database.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [warehouse](<https://devfeed.tech/tags/warehouse.md>)

### AI overview

Build and test a small analytics pipeline before choosing a warehouse: define each metric's date, currency, status and reporting grain, then preserve raw deliveries, resolve versions in staging, and aggregate in reporting models. In the PostgreSQL-compatible example, rank all versions before filtering status so a later refund supersedes an earlier paid state; deduplicate retries and flag conflicting payloads for the same source version. Add failing-row checks for data assumptions, and test late older updates and repeated deliveries. Incremental runs should recompute changed IDs and affected old and new reporting groups, handle deletions by an explicit policy, and advance checkpoints only after outputs commit. Track ingestion, transformation and validation freshness separately; a last validated result with a warning may be safer than serving an unverified total. Measure performance, concurrency, freshness needs and application impact before migration. The excerpt notes that dbt can organize tests and Airflow guidance addresses retryable tasks; neither tool alone ensures source completeness or correct metric definitions.

### Source excerpt

null Continue reading Build a Reliable Analytics Pipeline Before Migrating to a Data Warehouse on SitePoint.

## Build a Reliable Analytics Pipeline Before Moving to a Data Warehouse

DevFeed: [Build a Reliable Analytics Pipeline Before Moving to a Data Warehouse](<https://devfeed.tech/articles/build-a-reliable-analytics-pipeline-before-moving-to-a-data-warehouse-92895.md>)

Original publisher: [Read original article](<https://www.sitepoint.com/build-a-reliable-analytics-pipeline-before-moving-to-a-data-warehouse/>)

Author: tbutt4438

Published: 2026-10-21T13:16:13Z

Content type: tutorial

Language: en

Sources: [SitePoint](<https://devfeed.tech/sources/sitepoint.md>)

Topics: [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [etl](<https://devfeed.tech/topics/etl.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [metric-standardization](<https://devfeed.tech/topics/metric-standardization.md>), [DataOps](<https://devfeed.tech/topics/dataops.md>), [Apache Spark](<https://devfeed.tech/topics/spark.md>)

Tags: [agile-development](<https://devfeed.tech/tags/agile-development.md>), [ai](<https://devfeed.tech/tags/ai.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [data-quality](<https://devfeed.tech/tags/data-quality.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>)

### AI overview

Define a metric contract and reporting grain before choosing a warehouse. In the example, raw order deliveries are preserved, duplicates and versions are resolved in staging, and reporting includes only each order's latest state. Ranking versions before filtering status prevents a refunded order's older paid version from inflating sales: the example's correct total is 12,500 cents, not 27,500. Add failing-row and behavior tests for conflicting versions, late arrivals, and retries. Incremental pipelines must recompute changed orders and affected old and new reporting groups; deletions need explicit handling. PostgreSQL can prototype the pipeline, dbt can organize maintained SQL models and tests, and Airflow can coordinate dependent jobs and retries. These tools address different responsibilities and do not ensure source completeness. Measure performance, concurrency, freshness, and application impact before migrating, and expose freshness and validation status with dashboard results.

### Source excerpt

null Continue reading Build a Reliable Analytics Pipeline Before Moving to a Data Warehouse on SitePoint.

## How to Build a PostgreSQL-to-LLM Analytics Pipeline with Node.js

DevFeed: [How to Build a PostgreSQL-to-LLM Analytics Pipeline with Node.js](<https://devfeed.tech/articles/how-to-build-a-postgresql-to-llm-analytics-pipeline-with-node-js-59911.md>)

Original publisher: [Read original article](<https://www.sitepoint.com/how-to-build-a-postgresql-to-llm-analytics-pipeline-with-node-js/>)

Author: Jhon-Harry

Published: 2026-09-24T13:44:09Z

Content type: tutorial

Language: en

Sources: [SitePoint](<https://devfeed.tech/sources/sitepoint.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Large Language Model](<https://devfeed.tech/topics/llm.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [etl](<https://devfeed.tech/topics/etl.md>), [Node.js](<https://devfeed.tech/topics/node-js.md>), [Database](<https://devfeed.tech/topics/database.md>), [Security](<https://devfeed.tech/topics/security.md>)

Tags: [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [etl](<https://devfeed.tech/tags/etl.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [llm](<https://devfeed.tech/tags/llm.md>), [node-js](<https://devfeed.tech/tags/node-js.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [statistics-and-analysis](<https://devfeed.tech/tags/statistics-and-analysis.md>)

### AI overview

This tutorial shows how to build a Node.js pipeline that extracts a bounded, curated dataset from PostgreSQL, transforms it through an ETL layer, and sends it to a large language model for analytics. It emphasizes removing sensitive fields, controlling prompt size, using parameterized queries, and validating model output.

### Source excerpt

null Continue reading How to Build a PostgreSQL-to-LLM Analytics Pipeline with Node.js on SitePoint.

## Gain visibility into client-side network failures with NEL

DevFeed: [Gain visibility into client-side network failures with NEL](<https://devfeed.tech/articles/gain-visibility-into-client-side-network-failures-with-nel-49874.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/networking-and-content-delivery/gain-visibility-into-client-side-network-failures-with-nel/>)

Author: Achraf Souk

Published: 2026-08-21T19:06:03Z

Content type: tutorial

Language: en

Sources: [Networking & Content Delivery](<https://devfeed.tech/sources/networking-content-delivery.md>)

Topics: [observability](<https://devfeed.tech/topics/observability.md>), [Security Information and Event Management (SIEM)](<https://devfeed.tech/topics/siem-security.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>), [Amazon API Gateway](<https://devfeed.tech/topics/amazon-api-gateway.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [AWS Lambda](<https://devfeed.tech/topics/aws-lambda.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [Serverless](<https://devfeed.tech/topics/serverless.md>), [cloud-infrastructure](<https://devfeed.tech/topics/cloud-infrastructure.md>), [HTTP](<https://devfeed.tech/topics/http.md>), [JSON](<https://devfeed.tech/topics/json.md>), [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>), [W3C](<https://devfeed.tech/topics/w3c.md>)

Tags: [amazon-simple-storage-service-s3](<https://devfeed.tech/tags/amazon-simple-storage-service-s3.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [api](<https://devfeed.tech/tags/api.md>), [aws-lambda](<https://devfeed.tech/tags/aws-lambda.md>), [connectivity](<https://devfeed.tech/tags/connectivity.md>), [deploy](<https://devfeed.tech/tags/deploy.md>), [development](<https://devfeed.tech/tags/development.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [logs](<https://devfeed.tech/tags/logs.md>), [network](<https://devfeed.tech/tags/network.md>), [networking-content-delivery](<https://devfeed.tech/tags/networking-content-delivery.md>), [observability](<https://devfeed.tech/tags/observability.md>), [technical-how-to](<https://devfeed.tech/tags/technical-how-to.md>), [trace](<https://devfeed.tech/tags/trace.md>)

### AI overview

This tutorial explains how Network Error Logging (NEL) exposes client-side network failures that may not appear in server logs. It describes NEL and presents a serverless AWS pipeline using API Gateway, Data Firehose, Lambda, S3, Athena, and AWS CDK to collect, analyze, and observe NEL reports.

### Source excerpt

When your user experiences a connectivity issue visiting your website, it's unlikely that you'll see a trace of it in your server logs. DNS resolution failures happen before your user ever connects to your server. TCP timeouts, on shared infrastructure such as Content Delivery Networks (CDNs), are difficult to attribute to a specific origin. Even [...]

## From search to checkout in 20 lines of code: building a 4-stage conversion funnel with OpenTelemetry

DevFeed: [From search to checkout in 20 lines of code: building a 4-stage conversion funnel with OpenTelemetry](<https://devfeed.tech/articles/from-search-to-checkout-in-20-lines-of-code-building-a-4-stage-conversion-funnel-with-opentelemetry-78888.md>)

Original publisher: [Read original article](<https://www.elastic.co/search-labs/blog/search-conversion-tracking-opentelemetry>)

Author: Matthew Adams

Published: 2026-08-06T00:00:00Z

Content type: tutorial

Language: en

Sources: [Elasticsearch Labs](<https://devfeed.tech/sources/elasticsearch-labs.md>)

Topics: [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [elasticsearch](<https://devfeed.tech/topics/elasticsearch.md>), [product analytics](<https://devfeed.tech/topics/product-analytics.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [es-ql](<https://devfeed.tech/tags/es-ql.md>), [opentelemetry](<https://devfeed.tech/tags/opentelemetry.md>), [product](<https://devfeed.tech/tags/product.md>), [relevance](<https://devfeed.tech/tags/relevance.md>), [search-analytics](<https://devfeed.tech/tags/search-analytics.md>)

### AI overview

This tutorial shows how to add OpenTelemetry spans for add-to-cart and purchase events, linking them to search queries with query IDs. It uses Elasticsearch Query Language (ES|QL) to analyze a four-stage funnel and attribute revenue to searches, while explaining attribution limits and how teams can use the results to prioritize search relevance work.

### Source excerpt

Add cart and purchase tracking to your search analytics pipeline and use ES|QL to answer the question every product manager asks: which search queries drive the most revenue?

## Game integrity and cheat detection using AWS Game Analytics Pipeline, Amazon Quick, and Kiro agentic IDE

DevFeed: [Game integrity and cheat detection using AWS Game Analytics Pipeline, Amazon Quick, and Kiro agentic IDE](<https://devfeed.tech/articles/game-integrity-and-cheat-detection-using-aws-game-analytics-pipeline-amazon-quick-and-kiro-agentic-ide-50130.md>)

Original publisher: [Read original article](<https://aws.amazon.com/blogs/gametech/game-integrity-and-cheat-detection-using-aws-game-analytics-pipeline-amazon-quick-and-kiro-agentic-ide/>)

Author: Gage McGilvra

Published: 2026-07-23T14:17:50Z

Content type: tutorial

Language: en

Sources: [AWS for Games Blog](<https://devfeed.tech/sources/aws-for-games-blog.md>)

Topics: [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [Kiro](<https://devfeed.tech/topics/kiro.md>), [dashboards](<https://devfeed.tech/topics/dashboards.md>), [data-processing](<https://devfeed.tech/topics/data-processing.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Python](<https://devfeed.tech/topics/python.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [amazon-athena](<https://devfeed.tech/tags/amazon-athena.md>), [amazon-kinesis](<https://devfeed.tech/tags/amazon-kinesis.md>), [amazon-quick-sight](<https://devfeed.tech/tags/amazon-quick-sight.md>), [amazon-s3](<https://devfeed.tech/tags/amazon-s3.md>), [amazon-simple-storage-service-s3](<https://devfeed.tech/tags/amazon-simple-storage-service-s3.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [aws-management-console](<https://devfeed.tech/tags/aws-management-console.md>), [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [games](<https://devfeed.tech/tags/games.md>), [github](<https://devfeed.tech/tags/github.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [industries](<https://devfeed.tech/tags/industries.md>), [kiro](<https://devfeed.tech/tags/kiro.md>)

### AI overview

This tutorial shows how to extend AWS Game Analytics Pipeline with cheat-detection capabilities. It covers collecting integrity metrics, transforming game-event data with Athena SQL views, importing datasets into Amazon Quick Sight, and building ML-powered dashboards to identify anomalous player behavior.

### Source excerpt

Cheating in online games erodes player trust, damages competitive integrity, and can drive players away. Game studios need a scalable analytics pipeline to detect anomalous player behavior. In this post, we show how to build a game integrity proof of concept (POC) using the Guidance for Game Analytics Pipeline on AWS, Amazon Athena, and Amazon [...]

## Good Data For Bad Golf

DevFeed: [Good Data For Bad Golf](<https://devfeed.tech/articles/good-data-for-bad-golf-27477.md>)

Original publisher: [Read original article](<https://jerrygamblin.com/2026/05/13/good-data-for-bad-golf/>)

Author: jgamblin

Published: 2026-05-13T14:05:06Z

Content type: article

Language: en

Sources: [Jerry Gamblin](<https://devfeed.tech/sources/jerry-gamblin.md>)

Topics: [Python](<https://devfeed.tech/topics/python.md>), [CSV](<https://devfeed.tech/topics/csv.md>), [GitHub Pages](<https://devfeed.tech/topics/github-pages.md>), [GitHub Actions](<https://devfeed.tech/topics/github-actions.md>), [Self-hosted](<https://devfeed.tech/topics/self-hosted.md>)

Tags: [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [csv](<https://devfeed.tech/tags/csv.md>), [github-actions](<https://devfeed.tech/tags/github-actions.md>), [github-pages](<https://devfeed.tech/tags/github-pages.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [python](<https://devfeed.tech/tags/python.md>), [self-hosted](<https://devfeed.tech/tags/self-hosted.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>)

### AI overview

The article presents jgamblin/golf, a self-hosted Python analytics pipeline that converts Garmin Golf app CSV exports into a multi-page GitHub Pages dashboard. It describes features including session analysis, club-level consistency, session replay, gapping, coaching recommendations, and data-quality tracking, with deployment automated through GitHub Actions.

### Source excerpt

I play golf. I am not good at golf. But I have a Garmin Approach R10 launch monitor, a Python interpreter, and too much free time, so naturally I spent way more time building a dashboard to analyze my swing data than I did actually swinging a club. The result is jgamblin/golf, a self-hosted analytics ... Read more

## Revamping Myntra App Analytics persistence with KMP and SQLite

DevFeed: [Revamping Myntra App Analytics persistence with KMP and SQLite](<https://devfeed.tech/articles/revamping-myntra-app-analytics-persistence-with-kmp-and-sqlite-20139.md>)

Original publisher: [Read original article](<https://medium.com/myntra-engineering/revamping-myntra-app-analytics-persistence-with-kmp-and-sqlite-516751e24d63?source=rss----7484818e9f88---4>)

Author: Kartik Sharma

Published: 2026-03-31T13:01:09Z

Content type: article

Language: en

Sources: [Myntra](<https://devfeed.tech/sources/myntra.md>)

Topics: [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Persistence](<https://devfeed.tech/topics/persistence.md>), [Android](<https://devfeed.tech/topics/android.md>), [mobile-app-performance](<https://devfeed.tech/topics/mobile-app-performance.md>), [Database](<https://devfeed.tech/topics/database.md>), [legacy systems](<https://devfeed.tech/topics/legacy-systems.md>), [product analytics](<https://devfeed.tech/topics/product-analytics.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [android](<https://devfeed.tech/tags/android.md>), [app](<https://devfeed.tech/tags/app.md>), [app-performance](<https://devfeed.tech/tags/app-performance.md>), [app-stability](<https://devfeed.tech/tags/app-stability.md>), [background](<https://devfeed.tech/tags/background.md>), [batch](<https://devfeed.tech/tags/batch.md>), [bottlenecks](<https://devfeed.tech/tags/bottlenecks.md>), [data](<https://devfeed.tech/tags/data.md>), [data-integrity](<https://devfeed.tech/tags/data-integrity.md>), [databases](<https://devfeed.tech/tags/databases.md>), [e-commerce](<https://devfeed.tech/tags/e-commerce.md>), [engine](<https://devfeed.tech/tags/engine.md>), [error-handling](<https://devfeed.tech/tags/error-handling.md>), [event](<https://devfeed.tech/tags/event.md>), [events](<https://devfeed.tech/tags/events.md>), [ios](<https://devfeed.tech/tags/ios.md>), [kmp](<https://devfeed.tech/tags/kmp.md>), [kotlin-multiplatform](<https://devfeed.tech/tags/kotlin-multiplatform.md>), [mobile-app-development](<https://devfeed.tech/tags/mobile-app-development.md>), [persistence](<https://devfeed.tech/tags/persistence.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>)

### AI overview

Myntra replaced its analytics SDK's fragile persistence with a Kotlin Multiplatform pipeline backed by SQLite, improving event durability and Android app stability. The legacy Android queue rewrote a growing SharedPreferences file for each update, contributing to data loss, OOM errors, and ANRs; iOS LevelDB lacked transactional batch handling and robust background syncing. The new pipeline stores each event as a SQLite row, batches by priority, and uses coroutine serialization and mutexes. Android WorkManager and iOS BGProcessingTask schedule background flushes; shared logic sends fresh batches first, retries older events individually, and eventually purges repeatedly failing events. A configurable row cap prunes old unsynced events, while critically low storage triggers direct HTTP upload. Android rollout advanced from a canary through 1%, 5%, 10%, 50%, and 100%, with a discrepancy caught at 5%. Myntra reports more high-traffic events recovered and about 1.1 million fewer monthly ANR instances and 250,000 fewer monthly crashes attributed to the old pipeline. iOS remains in early A/B rollout.

### Source excerpt

Introduction In the dynamic landscape of e-commerce, data is the bedrock of decision-making, and app stability is the foundation of user experience. At Myntra, where millions of users engage with our platform daily, ensuring the reliability of both is paramount. This necessity drove us to re-architect a critical piece of our infrastructure: the persistence layer of the Myntra app's analytics SDK. This post details our journey of augmenting our legacy analytics SDK with a robust new persistence engine backed by SQLite[1], achieving significant gains in app stability and data integrity. Background: The Limits of the Legacy Pipeline For years, our legacy in-house analytics SDK was the workhorse for collecting user interaction data. However, as our app's event volume grew, the SDK's aging persistence and processing logic created significant bottlenecks that led to degraded app performance and compromised the reliability of analytics data our product teams depended on. On Android: The Legacy Pipeline and its Limits On Android, the legacy analytics pipeline followed a straightforward event processing model: Capture, Persist & Batch: Events generated by used actions were held in an in-memory queue and then serialized into a persistent queue backed by SharedPreferences[2]. Once a batch threshold was met (typically 10 events), the batch was dispatched to the server. Background Flushing: Periodic background jobs flushed unsent events and retried failed batches. Error Handling: Failed batches were pushed to a separate retry queue, with older events silently purged if the queue hit its cap. High level overview of legacy android pipeline At the time of the initial implementation, SharedPreferences was a pragmatic choice to prioritize velocity. The ecosystem for local databases on Android was still maturing, and raw SQLite often required significant boilerplate compared to the simplicity of a key-value store. However, SharedPreferences is architecturally limited for high-throughp

## Finding the UFC GOAT: A Full Stack Pipeline with dlt, dbt and Metabase

DevFeed: [Finding the UFC GOAT: A Full Stack Pipeline with dlt, dbt and Metabase](<https://devfeed.tech/articles/finding-the-ufc-goat-a-full-stack-pipeline-with-dlt-dbt-and-metabase-80426.md>)

Original publisher: [Read original article](<https://dlthub.com/blog/ufc-analyser-dlt-dbt-metabase>)

Author: Reshef Sharvit

Published: 2026-02-04T00:00:00Z

Content type: tutorial

Language: en

Sources: [DLT Hub](<https://devfeed.tech/sources/dlt-hub.md>)

Topics: [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [Test-driven development](<https://devfeed.tech/topics/tdd.md>), [Data visualization](<https://devfeed.tech/topics/data-visualization.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [charts](<https://devfeed.tech/tags/charts.md>), [community](<https://devfeed.tech/tags/community.md>), [database](<https://devfeed.tech/tags/database.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

A software engineer describes building a UFC analytics project with dlt for data ingestion, PostgreSQL for storage, dbt for SQL transformations and tests, and Metabase for exploring visualizations. The pipeline brings fight statistics and context into queryable, analysis-ready tables; the author uses it to compare fighters across multiple metrics while noting that statistics do not capture every aspect of performance.

### Source excerpt

Who's the UFC GOAT? Reshef Sharvit built an analytics pipeline using dlt, dbt & Metabase to find out. Automated ingestion meets deep SQL analysis. See the results here.

## How Dub Uses Webhooks to Power Features

DevFeed: [How Dub Uses Webhooks to Power Features](<https://devfeed.tech/articles/how-dub-uses-webhooks-to-power-features-82694.md>)

Original publisher: [Read original article](<https://resend.com/blog/how-dub-uses-webhooks-to-power-features>)

Author: Jp Valery

Published: 2025-11-19T00:00:00Z

Content type: article

Language: en

Sources: [Resend](<https://devfeed.tech/sources/resend.md>)

Topics: [Publish-subscribe pattern](<https://devfeed.tech/topics/pubsub.md>), [Iterable](<https://devfeed.tech/topics/iterable.md>)

Tags: [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [api](<https://devfeed.tech/tags/api.md>), [backend](<https://devfeed.tech/tags/backend.md>), [database](<https://devfeed.tech/tags/database.md>), [developer](<https://devfeed.tech/tags/developer.md>), [growth](<https://devfeed.tech/tags/growth.md>), [guides](<https://devfeed.tech/tags/guides.md>), [in-app-messaging](<https://devfeed.tech/tags/in-app-messaging.md>), [webhooks](<https://devfeed.tech/tags/webhooks.md>)

### AI overview

Dub uses Resend webhooks, batch sending, and message tags to add real-time read-status updates to its in-app messaging between brands and affiliates. The article describes how the email platform supports Dub's product features and handles email infrastructure as the service scales.

### Source excerpt

Dub transforms Webhooks from simple notifications into powerful product features that drive in-app messaging and growth, sending 5 million emails each month.

## Why Flock Safety turned to ClickHouse for real-time vehicle traffic analytics

DevFeed: [Why Flock Safety turned to ClickHouse for real-time vehicle traffic analytics](<https://devfeed.tech/articles/why-flock-safety-turned-to-clickhouse-for-real-time-vehicle-traffic-analytics-5660.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/why-flock-safety-turned-to-clickhouse>)

Author: ClickHouse

Published: 2025-04-29T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [clickhouse](<https://devfeed.tech/topics/clickhouse.md>), [real-time](<https://devfeed.tech/topics/real-time.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [software-architecture](<https://devfeed.tech/topics/software-architecture.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [dashboards](<https://devfeed.tech/tags/dashboards.md>), [data-architecture](<https://devfeed.tech/tags/data-architecture.md>), [data-engineering](<https://devfeed.tech/tags/data-engineering.md>), [real-time](<https://devfeed.tech/tags/real-time.md>)

### AI overview

This developer case study explains why Flock Safety moved its vehicle traffic analytics platform from an Amazon Redshift, DBT, Prefect, and QuickSight SPICE pipeline to ClickHouse Cloud. The former architecture refreshed data daily, required up to four hours to process some datasets, and made data unavailable during refreshes. ClickHouse enabled real-time analytics for camera traffic without the previous size constraints or row-level security limitations.

### Source excerpt

"With ClickHouse, our customers now have real-time analytics for their camera traffic, and there are no more constraints on size or row-level security." ~ Leon Kozlowski, Data Engineering Manager

## Real-time payment analytics: Building a data pipeline from Stripe to AWS

DevFeed: [Real-time payment analytics: Building a data pipeline from Stripe to AWS](<https://devfeed.tech/articles/real-time-payment-analytics-building-a-data-pipeline-from-stripe-to-aws-81815.md>)

Original publisher: [Read original article](<https://stripe.dev/blog/real-time-payment-analytics-stripe-to-aws-data-pipeline>)

Author: James Beswick

Published: 2025-03-14T00:00:00Z

Content type: tutorial

Language: en

Sources: [Stripe Dot Dev Blog](<https://devfeed.tech/sources/stripe-dot-dev-blog.md>)

Topics: [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [Event-Streaming](<https://devfeed.tech/topics/event-streaming.md>), [stream financial data to Snowflake](<https://devfeed.tech/topics/stream-financial-data-to-snowflake.md>), [streaming data to S3 with Parquet](<https://devfeed.tech/topics/streaming-data-to-s3-with-parquet.md>), [stripe](<https://devfeed.tech/topics/stripe.md>), [Payment Fraud](<https://devfeed.tech/topics/payment-fraud.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [aws](<https://devfeed.tech/tags/aws.md>), [data](<https://devfeed.tech/tags/data.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [payment](<https://devfeed.tech/tags/payment.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [stripe](<https://devfeed.tech/tags/stripe.md>), [transactions](<https://devfeed.tech/tags/transactions.md>)

### AI overview

A guide to building a scalable real-time payment analytics pipeline from Stripe to AWS, covering architectural components and implementation details for monitoring transactions, improving security, and analyzing customer behavior.

### Source excerpt

Discover how to build a scalable real-time payment analytics pipeline from Stripe to AWS. This guide explores the challenges, architectural components, and implementation details to help businesses monitor transactions, enhance security, and gain insights into customer behavior.

## Real-time Personalized Shopping Experience With Estuary and Tinybird

DevFeed: [Real-time Personalized Shopping Experience With Estuary and Tinybird](<https://devfeed.tech/articles/real-time-personalized-shopping-experience-with-estuary-and-tinybird-82332.md>)

Original publisher: [Read original article](<https://estuary.dev/blog/real-time-data-ecommerce-integration>)

Author: Shruti Mantri

Published: 2025-01-31T16:40:59Z

Content type: tutorial

Language: en

Sources: [Estuary](<https://devfeed.tech/sources/estuary.md>)

Topics: [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Event-Streaming](<https://devfeed.tech/topics/event-streaming.md>), [Redpanda](<https://devfeed.tech/topics/redpanda-data-streaming.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [api](<https://devfeed.tech/tags/api.md>), [backend](<https://devfeed.tech/tags/backend.md>), [cli](<https://devfeed.tech/tags/cli.md>), [data](<https://devfeed.tech/tags/data.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [e-commerce](<https://devfeed.tech/tags/e-commerce.md>), [estuary](<https://devfeed.tech/tags/estuary.md>), [inventory-management](<https://devfeed.tech/tags/inventory-management.md>), [mongodb](<https://devfeed.tech/tags/mongodb.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [tinybird](<https://devfeed.tech/tags/tinybird.md>)

### AI overview

This tutorial explains how to build a real-time e-commerce clickstream pipeline with Estuary and Tinybird. It walks through capturing MongoDB change events, streaming them into Tinybird, and using SQL queries to support pricing, recommendations, inventory monitoring, and cart recovery.

### Source excerpt

Boost e-commerce sales with real-time data integration. Optimize pricing, personalize shopping, and improve inventory management using Estuary and Tinybird.

## Logging millions of requests reliably with our new data ingestion pipeline

DevFeed: [Logging millions of requests reliably with our new data ingestion pipeline](<https://devfeed.tech/articles/logging-millions-of-requests-reliably-with-our-new-data-ingestion-pipeline-20018.md>)

Original publisher: [Read original article](<http://engineering.hackerearth.com/2022/07/01/logging-millions-of-requests-reliably-with-our-new-data-ingestion-pipeline/>)

Published: 2022-07-01T00:00:00Z

Content type: article

Language: en

Sources: [HackerEarth](<https://devfeed.tech/sources/hackerearth.md>)

Topics: [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Web app](<https://devfeed.tech/topics/webapp.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>), [software-architecture](<https://devfeed.tech/topics/software-architecture.md>), [API Logging](<https://devfeed.tech/topics/api-logging.md>)

Tags: [amazon-kinesis](<https://devfeed.tech/tags/amazon-kinesis.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [compress](<https://devfeed.tech/tags/compress.md>), [cost](<https://devfeed.tech/tags/cost.md>), [data](<https://devfeed.tech/tags/data.md>), [data-ingestion](<https://devfeed.tech/tags/data-ingestion.md>), [data-ingestion-pipeline](<https://devfeed.tech/tags/data-ingestion-pipeline.md>), [database](<https://devfeed.tech/tags/database.md>), [flow](<https://devfeed.tech/tags/flow.md>), [http](<https://devfeed.tech/tags/http.md>), [https](<https://devfeed.tech/tags/https.md>), [kinesis](<https://devfeed.tech/tags/kinesis.md>), [logging](<https://devfeed.tech/tags/logging.md>), [managed](<https://devfeed.tech/tags/managed.md>), [minutes](<https://devfeed.tech/tags/minutes.md>), [operational](<https://devfeed.tech/tags/operational.md>), [overhead](<https://devfeed.tech/tags/overhead.md>), [pipeline](<https://devfeed.tech/tags/pipeline.md>), [query](<https://devfeed.tech/tags/query.md>)

### AI overview

HackerEarth replaced a complex, self-hosted request logging system with Amazon Kinesis Firehose delivery to Redshift, using retries to protect against intermittent component failures and reporting data availability within 10-15 minutes. As request volume grew, Redshift costs led the team to retain only 12 months there, reducing analyst access to historical logs. The article describes querying compressed hourly log files in S3 with serverless Athena instead. Athena's partition projection uses the S3 date-hour path, and queries must filter on the projected datehour column to limit scanned data and improve speed and cost. Athena workgroups can cancel queries that exceed scan limits; Athena also retains query results in S3 for 45 days, allowing eligible reruns to return stored results. The account presents these as ways to manage storage and query costs while accessing longer-term logs, but gives no quantified savings.

### Source excerpt

Introduction HackerEarth handles millions of requests every day. To understand the user access patterns, get the usage of any particular feature or a page, figure out the daily active users or users who have been active for the past 6 months, etc in near real time, it is important to stream that data from across different services and ingest it to the analytics pipeline reliably. Problem Our old request logging architecture was complex and has many moving components. There were a lot of operational overheads involved in maintaining and scaling each of those components independently to ensure that all the self-hosted components were up and running all the time. Architecture Solution Last year, we revamped the way we log our web requests. It was done mainly to increase the reliability in logging the HTTP/HTTPS request data from across web services and also to reduce the operational overheads and the infrastructure cost associated with it. The new flow is making use of Kinesis Firehose data streams to deliver the request data from our web servers to Redshift (the database that we use to log and query request data) reliably with much lower cost. Amazon Kinesis Firehose is a fully managed service that automatically scales to match the throughput of our incoming request log data and requires no ongoing administration. It also allows us to compress and encrypt the data before loading it, minimizing the amount of storage used at the destination with increased security and we only need to pay for the amount of data we transmit through the service. The new flow is a fully managed solution with almost no operational overhead. We tried to keep the flow simple and straightforward with less number of moving components. The request data is now guaranteed to appear in the Redshift table within 10-15 minutes from the point we received a request at our web server's end. There are retries configured between consecutive infra components in the new flow to make sure there are no message

## Continuous Deployment for AWS Glue

DevFeed: [Continuous Deployment for AWS Glue](<https://devfeed.tech/articles/continuous-deployment-for-aws-glue-22993.md>)

Original publisher: [Read original article](<https://bravenewgeek.com/continuous-deployment-for-aws-glue/>)

Author: Mohammed

Published: 2020-10-15T15:51:25Z

Content type: tutorial

Language: en

Sources: [Brave New Geek](<https://devfeed.tech/sources/brave-new-geek.md>)

Topics: [AWS Glue](<https://devfeed.tech/topics/aws-glue.md>), [Continuous Deployment (CD)](<https://devfeed.tech/topics/continuous-deployment.md>), [GitHub Actions](<https://devfeed.tech/topics/github-actions.md>), [Jupyter Notebook](<https://devfeed.tech/topics/jupyter-notebook.md>), [Amazon S3](<https://devfeed.tech/topics/amazon-s3.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [aws](<https://devfeed.tech/tags/aws.md>), [aws-glue](<https://devfeed.tech/tags/aws-glue.md>), [ci-cd](<https://devfeed.tech/tags/ci-cd.md>), [continuous-delivery](<https://devfeed.tech/tags/continuous-delivery.md>), [continuous-deployment](<https://devfeed.tech/tags/continuous-deployment.md>), [etl](<https://devfeed.tech/tags/etl.md>), [github](<https://devfeed.tech/tags/github.md>), [github-actions](<https://devfeed.tech/tags/github-actions.md>), [jupyter](<https://devfeed.tech/tags/jupyter.md>), [jupyter-notebook](<https://devfeed.tech/tags/jupyter-notebook.md>), [s3](<https://devfeed.tech/tags/s3.md>), [serverless](<https://devfeed.tech/tags/serverless.md>)

### AI overview

A tutorial for automating continuous deployment of AWS Glue ETL jobs. It uses GitHub Actions to generate a Python script from a Jupyter notebook, copy it to Amazon S3, and update the Glue job to use the new script.

### Source excerpt

AWS Glue is a managed service for building ETL (Extract-Transform-Load) jobs. It's a useful tool for implementing analytics pipelines in AWS without having to manage server infrastructure. Jobs are implemented using Apache Spark and, with the help of Development Endpoints, can be built using Jupyter notebooks. This makes it reasonably easy to write ETL processes in an interactive, iterative fashion. Once finished, the Jupyter notebook is converted into a Python script, uploaded to S3, and then run as a Glue job.

## Implementing ETL on GCP

DevFeed: [Implementing ETL on GCP](<https://devfeed.tech/articles/implementing-etl-on-gcp-22998.md>)

Original publisher: [Read original article](<https://bravenewgeek.com/implementing-etl-on-gcp/>)

Author: Deepmala

Published: 2020-07-15T20:53:17Z

Content type: tutorial

Language: en

Sources: [Brave New Geek](<https://devfeed.tech/sources/brave-new-geek.md>)

Topics: [DataOps](<https://devfeed.tech/topics/dataops.md>), [Cloud](<https://devfeed.tech/topics/cloud.md>), [BigQuery](<https://devfeed.tech/topics/bigquery.md>), [data loss prevention](<https://devfeed.tech/topics/data-loss-prevention.md>), [Low code](<https://devfeed.tech/topics/low-code.md>), [No-code](<https://devfeed.tech/topics/no-code.md>), [olap](<https://devfeed.tech/topics/olap.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [analytics-pipeline](<https://devfeed.tech/tags/analytics-pipeline.md>), [bi-tools](<https://devfeed.tech/tags/bi-tools.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [cdap](<https://devfeed.tech/tags/cdap.md>), [cloud-data-loss-prevention](<https://devfeed.tech/tags/cloud-data-loss-prevention.md>), [cloud-dataflow](<https://devfeed.tech/tags/cloud-dataflow.md>), [cloud-dataprep](<https://devfeed.tech/tags/cloud-dataprep.md>), [cloud-dataproc](<https://devfeed.tech/tags/cloud-dataproc.md>), [cloud-pub-sub](<https://devfeed.tech/tags/cloud-pub-sub.md>), [cloud-storage](<https://devfeed.tech/tags/cloud-storage.md>), [cloud-tasks](<https://devfeed.tech/tags/cloud-tasks.md>), [data-analytics](<https://devfeed.tech/tags/data-analytics.md>), [data-fusion](<https://devfeed.tech/tags/data-fusion.md>), [data-lake](<https://devfeed.tech/tags/data-lake.md>), [data-loss-prevention](<https://devfeed.tech/tags/data-loss-prevention.md>), [elt](<https://devfeed.tech/tags/elt.md>), [etl](<https://devfeed.tech/tags/etl.md>), [gcp](<https://devfeed.tech/tags/gcp.md>), [no-code](<https://devfeed.tech/tags/no-code.md>), [serverless](<https://devfeed.tech/tags/serverless.md>), [sql](<https://devfeed.tech/tags/sql.md>)

### AI overview

A practical guide to building ETL pipelines on Google Cloud Platform using Google-managed services. It explains a two-phase architecture with Cloud Storage as a data lake, Cloud Data Loss Prevention for sensitive-data detection or redaction, and BigQuery as the curated data warehouse, with attention to low-code and no-code approaches.

### Source excerpt

ETL (Extract-Transform-Load) processes are an essential component of any data analytics program. This typically involves loading data from disparate sources, transforming or enriching it, and storing the curated data in a data warehouse for consumption by different users or systems. An example of this would be taking customer data from operational databases, joining it with data from Salesforce and Google Analytics, and writing it to an OLAP database or BI engine.