Pinned2022 : Modern Data StackYou might have seen multiple posts around this subject as time keeps evolving and bringing changes into tech stack, however this includes recent discovery in data processing frameworks, visualization tools, ETL tools, Development notebooks, Data catalog..etc Over the time, we might have come across different terms like ETL, ELT, Reverse…Datastack5 min readDatastack5 min read
PinnedWhy Apache Arrow is faster with PySpark?Apache Arrow defines a language-independent columnar memory format for in-memory analytics. It contains a set of technologies that enable big data systems to process and move data fast. Before going through the performance improvements provided by Apache Arrow, let’s quickly go through the usual process happening in PySpark and Pandas…Arrow2 min readArrow2 min read
Jun 28, 2022Can Snowpark supersede Databricks and AWS EMR?Introduction Ever since the introduction of Hadoop, computing power and storage are seen as two different entities (unlike OLTP databases where computing and storage are tightly coupled). For example, Map Reduce, Spark, Flink, Storm are frameworks to process big data in distributed environment, whereas HDFS, Cloud storage (S3, Azure Blob, Google…Snowflake3 min readSnowflake3 min read
Jun 13, 2022Deep Dive into Windowing concepts in Apache FlinkWindows plays a major role and also defined as a core part in processing infinite streams. Windows split the incoming stream into buckets of finite size, over which required transformations can be applied. Though there are many components in windows that includes trigger, evictor, allowedLateness, sideOutputLateData…etc, this post focusses on…Windows4 min readWindows4 min read
Apr 16, 2022Delta Lake Clones: Systematic Approach for Testing, Sharing dataLet’s begin with some issues faced in data engineering projects, followed by usage of Delta Lake clones and let’s take a final step by resolving issues. What’s clone in Delta Lake? It’s just a replica of a source table at a given point in time. In other database terminology, we…Databricks4 min readDatabricks4 min read
Mar 16, 2022Simplify ETL Pipelines using Delta Live TablesConsider a common scenario of data engineering pipeline where raw data needs to be cleansed, transformed or aggregated before writing to a target system. For this case, usually we create 3-4 tables to store raw data, cleansed data, transformed data and aggregated data respectively. In order to implement, this needs…Databricks6 min readDatabricks6 min read
Feb 14, 2022Expedite Spark Processing using Parquet Bloom FilterSo, what’s Bloom filter? Bloom filter index is a space-efficient probabilistic data structure that is used to test whether an element is a member of set. It skips the values of chosen columns, particularly for fields containing arbitrary text. A Bloom filter can tell you if a key is in a set and with…Databricks3 min readDatabricks3 min read
Dec 20, 2021Databricks AutoLoader : Enhance ETL by simplifying Data Ingestion ProcessIntroduction: Before we start deep diving on AutoLoader, let us focus on the existing data engineering issues in ingestion process that fits into one of the below categories: High Latency due to batch processing: Though data is landing at regular intervals for every few minutes, most of the cases a batch…Databricks4 min readDatabricks4 min read
Oct 12, 2021Hadoop Admin Interview Questions and Answers : Part 1Though big data platform has introduced lot of new frameworks like Spark, Druid, Delta Lake, Hudi, Governed tables, Snowflake..etc and covered a huge distance, explored various issues after introduction of Hadoop, but still there are lot of data stores of project set up using Hadoop. So, even nowadays there are…Hadoop6 min readHadoop6 min read
Oct 6, 2021DeltaLake on EMRApologies, if the heading is misleading, because we all know that Databricks and AWS are competing on Data Engineering and Machine Learning space. So, you might be wondering how a Databricks product can get installed on AWS EMR. …Emr2 min readEmr2 min read
