Kuan-Chih WangCONCAT 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…2 min read·May 3, 2024----
Kuan-Chih WangDeploy 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…6 min read·Aug 2, 2023----
Kuan-Chih WangPower BI DAX — Filter FunctionsThere are two major kinds of purposes when using DAX in Power BI, creating a calculated column, or creating a measure.4 min read·Jul 14, 2023----
Kuan-Chih WangData Engineering and Data ArchitectureData engineering cannot be practiced without data architecture, data architecture cannot be instantiated without data engineering.2 min read·Dec 13, 2022----
Kuan-Chih WangApache Airflow: Self-trigger & Looping in DAGApache Airflow has become one of the most popular scheduling and orchestration platform across the current data engineering landscape.2 min read·Nov 7, 2022----
Kuan-Chih WangSetting 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…5 min read·Jun 8, 2021----
Kuan-Chih WangFundamental 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 easily5 min read·Nov 5, 2020----
Kuan-Chih WangSetting Up Apache Spark ClusterStep by Step setting up Apache Spark cluster based on Hadoop4 min read·Sep 29, 2020----