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…May 3May 3
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…Aug 2, 2023Aug 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.Jul 14, 2023Jul 14, 2023
Kuan-Chih WangData Engineering and Data ArchitectureData engineering cannot be practiced without data architecture, data architecture cannot be instantiated without data engineering.Dec 13, 2022Dec 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.Nov 7, 2022Nov 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…Jun 8, 2021Jun 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 easilyNov 5, 2020Nov 5, 2020
Kuan-Chih WangSetting Up Apache Spark ClusterStep by Step setting up Apache Spark cluster based on HadoopSep 29, 2020Sep 29, 2020