Sudhanshu MathurDuplicate Record Detection in Tables: A Simplified ApproachAs a Data Analyst or Data Engineer it’s a very regular task to look for duplicate rows in a table. What if you have various tables having…Mar 20Mar 20
Sudhanshu MathurPySpark Interview: Coding Challenge — Part 1Let me walk you through to some of the coding questions that I faced in the interviews for a Data Engineer role. Let’s quickly jump on to…Mar 4Mar 4
Sudhanshu MathurStep-by-Step Guide: Migrating Data from Oracle to BigQueryMigrating data from Oracle to Google BigQuery involves several steps to ensure a smooth transition. Follow this comprehensive tutorial to…Dec 5, 2023Dec 5, 2023
Sudhanshu MathurBigQuery Architecture Unveiled: A Quick Guide for Data EngineersAs data engineers, navigating the intricate architecture of tools like Google BigQuery is essential to harness the full potential of data…Dec 5, 2023Dec 5, 2023
Sudhanshu MathurDebugging in BigQueryGoogleSQL for BigQuery has the following debugging Function/Statement:Oct 19, 2023Oct 19, 2023
Sudhanshu MathurImportant Date Functions in BigQueryLet’s understand some important Date functions in BigQuery by taking the example of Relations table. It has 5 columns: id, name…Sep 30, 2023Sep 30, 2023
Sudhanshu MathurImportant Array Functions in BigQueryLet’s understand some important Array functions in BigQuery by taking the example of Customer table. It has 5 columns: customer_id, name…Sep 6, 2023Sep 6, 2023