Systems | Development | Analytics | API | Testing

Data Warehouses

Snowflake CDC: A 101 Guide from a Data Scientist

Snowflake is one of the top cloud data warehouses. Regardless of the many documentations available, I have personally faced issues while carrying out Snowflake CDC (Change data capture). Therefore, I thought sharing everything a data practitioner should know about this before you start would be helpful. Let’s jump right into it!

Best Practices for Building Robust Data Warehouses

In the ever-expanding world of data-driven decision-making, data warehouses serve as the backbone for actionable insights. From seamless ETL (extract, transform, load)processes to efficient query optimization, building and managing a data warehouse requires thoughtful planning and execution. Based on my extensive experience in the ETL field, here are the best practices that mid-market companies should adopt for effective data warehousing.

Securely Query Confluent Cloud from Amazon Redshift with mTLS

Querying databases comes with costs—wall clock time, CPU usage, memory consumption, and potentially actual dollars. As your application scales, optimizing these costs becomes crucial. Materialized views offer a powerful solution by creating a pre-computed, optimized data representation. Imagine a retail scenario with separate customer and product tables. Typically, retrieving product details for a customer's purchase requires cross-referencing both tables.

Databricks Data Lakehouse Versus a Data Warehouse: What's the Difference?

Businesses today rely heavily on data to inform decisions, predict trends, and optimize operations. However, more data volume and complexity has led to growing pressure to find scalable, cost-effective solutions for data storage while staying within IT budgets. Companies want to handle both structured and unstructured data efficiently, while supporting advanced data analysis and machine learning use cases.

Comparing Snowflake vs. SQL Server: Which Data Warehouse Fits Your Needs

Data’s rising importance for businesses has also increased the necessity of tools and technologies to manage it efficiently. A data warehouse is a reliable solution as it effectively stores your data and keeps it ready for analysis. Understanding Snowflake and SQL Server’s pros and cons can help you choose the right solution for your data warehousing requirements.

Surprise, your data warehouse can RAG

If you’re one of the cool kids building AI-based products you’ve probably heard of — or are already doing — RAG. If you’re not, let me tell you what RAG is before telling you one weird fact about it. “Retrieval-Augmented Generation” is nothing more than a fancy way of saying “including helpful information in your LLM prompt.” Still, there are many ways to do it and many questions to answer when building a RAG pipeline.

Databricks vs. Snowflake: A Comparative Analysis

With the data management landscape continuously evolving, it has given rise to powerful platforms like Databricks and Snowflake, each offering distinct capabilities for organizations to manage and analyze their data efficiently. Our 5 key takeaways in the Databricks vs. Snowflake debate are: In this article, we will dive into a comprehensive comparison of Databricks and Snowflake and examine the data companies’ features, performance, scalability, and more.