CONCAT in Snowflake when there is NULL valueWhen dealing with concatenation in SQL, you may, in some rare use cases, encounter the situation where you have NULL in some of those…May 3May 3
Deploy Python Script to Azure Functions AppThe scenario for this post is to create Python Scripts that fetch json file from SportsRadar API, filer some unwanted information and save…Aug 2, 2023Aug 2, 2023
Power BI DAX — Filter FunctionsThere are two major kinds of purposes when using DAX in Power BI, creating a calculated column, or creating a measure.Jul 14, 2023Jul 14, 2023
Data Engineering and Data ArchitectureData engineering cannot be practiced without data architecture, data architecture cannot be instantiated without data engineering.Dec 13, 2022Dec 13, 2022
Apache Airflow: Self-trigger & Looping in DAGApache Airflow has become one of the most popular scheduling and orchestration platform across the current data engineering landscape.Nov 7, 2022Nov 7, 2022
Setting Up Apache Airflow Celery Executor ClusterApache airflow is one of the most common tools for routine task execution such as data ETL pipeline and workflow orchestration. When…Jun 8, 2021Jun 8, 2021
Fundamental Networking: Setting VPC, subnets, IGW, Route table and instance on AWSAWS is one of the platform that you can run your web server or application quickly and easilyNov 5, 2020Nov 5, 2020
Setting Up Apache Spark ClusterStep by Step setting up Apache Spark cluster based on HadoopSep 29, 2020Sep 29, 2020