APAnish Pandainanish601.hashnode.dev·Feb 2 · 1 min readAdvanced SQL Practice - Q2 [Med] - TeslaYou are given a table of product launches by company by year. Write a query to count the net difference between the number of products companies launched in 2020 with the number of products companies launched in the previous year. Output the name of ...00
APAnish Pandainanish601.hashnode.dev·Jan 30 · 1 min readAdvanced SQL Practice - Q1 [Med]You are analyzing a social network dataset at Google. Your task is to find mutual friends between two users, Karl and Hans. There is only one user named Karl and one named Hans in the dataset. The output should contain 'user_id' and 'user_name' col...00
APAnish Pandainanish601.hashnode.dev·Jan 29 · 4 min readCommon Data Engineering PatternsA Holistic View of Data Engineering Design Patterns A Real World Use Case Walkthrough Data Engineering design patterns are best understood not as isolated techniques, but as a journey the journey your data takes from raw ingestion to trusted, busines...00
APAnish Pandainanish601.hashnode.dev·Jan 26 · 4 min readCommon Cloud Dataflow Patterns (Python Implementation)1. GroupBy Using Multiple Data Properties Pattern Description: When data elements need to be grouped by more than one property (e.g., location and device type), you cannot simply pass multiple keys to a standard group transform. Solution: Create a co...00