Data Resources

Streamline Your ELT Workflow in Snowflake With Dynamic Tables and Medallion Design

Dynamic Tables in Snowflake bring declarative, incremental ELT. Define SQL + freshness target, and Snowflake handles the orchestration, no dbt or Airflow needed.

July 16, 2025

by Harshavardhan Yedla

· 4,180 Views · 1 Like

Data Ingestion: The Front Door to Modern Data Infrastructure

AWS offers a rich set of ingestion services. This guide provides industry use cases and a cheat sheet to help you choose the right one for your organization.

July 16, 2025

by Junaith Haja

· 2,672 Views · 3 Likes

Dashboards Are Dead Weight Without Context: Why BI Needs More Than Visuals

BI engineers must build context-rich, code-driven dashboards that enable decisions. Actionable pipelines and semantic clarity are now the standard.

July 15, 2025

by Venkata Murali Krishna Nerusu

· 4,382 Views · 1 Like

Analysis of the Data Processing Framework of Pandas and Snowpark Pandas API

This is a process analysis of migrating existing Pandas workflows to an almost lift-and-shift approach using the Snowpark Pandas API to meet ever-growing data needs.

July 15, 2025

by Prasath Chetty Pandurangan

· 2,776 Views · 1 Like

API Standards Are Data Standards

API standards are often created separately from an org's data standards. However, they are much more similar than many realize and, therefore, should be created together.

July 15, 2025

by Scott Sosna

CORE

· 4,209 Views · 2 Likes

Designing Configuration-Driven Apache Spark SQL ETL Jobs with Delta Lake CDC

Simplify complex ETL pipelines and enable scalable, maintainable data processing with Spark SQL and Delta Lake Change Data Capture.

July 14, 2025

by Janaki Ganapathi

· 2,090 Views

Turn SQL into Conversation: Natural Language Database Queries With MCP

Exemplifies how a dedicated MCP server that is able to access databases can enable LLMs to inspect them and offer their users useful pieces of information.

July 14, 2025

by Horatiu Dan

CORE

· 3,377 Views · 8 Likes

Understanding Time Series Databases

Time series databases (TSDBs) are specialized database systems optimized for storing, retrieving, and analyzing chronological data.

July 14, 2025

by Nikhil Makhija

· 2,960 Views · 3 Likes

My Dive into Local LLMs, Part 2: Taming Personal Finance with Homegrown AI (and Why Privacy Matters)

Turn your local LLM (Llama 3 + Ollama on Ubuntu) into a private finance analyzer that categorizes spending and generates insights—no cloud, full privacy.

July 14, 2025

by Praveen Chinnusamy

· 15,372 Views · 5 Likes

When MySQL, PostgreSQL, and Oracle Argue: Doris JDBC Catalog Acts as the Peacemaker

What is this magical Doris JDBC Catalog? It's like a universal key in the data world, opening the doors to multiple databases with one key.

July 11, 2025

by Zen Hua

· 2,453 Views · 1 Like

Indexed Views in SQL Server: A Production DBA's Complete Guide

Learn indexed views in SQL Server from a seasoned DBA's perspective with practical examples, performance testing, and best practices for database optimization.

July 11, 2025

by arvind toorpu

CORE

· 4,149 Views · 4 Likes

Modernize Your IAM Into Identity Fabric Powered by Connectors

In an era where most enterprises are moving their workloads to cloud, and AI-driven environments, modernizing IAM isn’t just a buzzword, but an absolute necessity.

July 10, 2025

by Anant Wairagade

· 1,962 Views

Contract-Driven ML: The Missing Link to Trustworthy Machine Learning

Model accuracy means nothing if data breaks in production. Learn how data contracts ensure reliability, prevent silent failures, and protect ML performance.

July 10, 2025

by Sana Zia Hassan

· 2,134 Views · 1 Like