Keith TanSubstring extraction from an address in MySQL vs MSSQLOne of the common use cases when cleaning customer data is address separation. An address usually contains a street address, city, state…10h ago10h ago
Keith TanWhat I learnt from being unemployedBeing unemployed is not easy. After being laid off last year, my life has been filled with uncertainty, anxiety that comes with the…Oct 11Oct 11
Keith TanToronto Bike Share Ridership Analysis with Azure Databricks Part 2Background: To continue with the analysis of Toronto Bike Share ridership, John uses the aggregated data in the bikeshare_gold table to…Aug 27Aug 27
Keith TanToronto Bike Share Ridership Analysis with Azure Databricks Part 1Background: This is my portfolio project to showcase how Azure Databricks can be used to ingest, transform and visualise data in a…Aug 26Aug 26
Keith TanHow to perform Incremental Data Load using merge into on Azure DatabricksIncremental Data Load is a data integration technique where only new or updated data are loaded into a target system since the last load…Aug 13Aug 13
Keith TanHow to disable NAT Gateway for Azure DatabricksWhen creating an Azure Databricks workspace, Microsoft Azure also creates a NAT Gateway, a VNet (Virtual network) and other resources to…Aug 121Aug 121