SKSion Kiminsionkim.hashnode.dev·May 5, 2025 · 8 min readExtracting Structured Data from Credit Letters - LLM vs OCRIntroduction Credit rating letters are critical in the debt securities market, providing assessments of the creditworthiness of entities and their debt instruments. Manually extracting company ratings, security details, etc., is time-consuming and er...00
SKSion Kiminsionkim.hashnode.dev·Feb 20, 2025 · 3 min readEnforcing Snowflake Unique Key Constraint in Retool (No More Duplicate Data!)Introduction Retool is an amazing visual wrapper for Snowflake. It offers query abstractions, such as GUI mode and dependency for success/failure. But as we dive into complex applications, we encounter the limit of Snowflake: Snowflake doesn’t enforc...00
SKSion Kiminsionkim.hashnode.dev·Oct 13, 2024 · 7 min readLittle Bit of Analytics EngineeringThis article is a note on a book Analytics Engineering with SQL and dbt. Chapter 1. Analytics Engineering Data Analytics Lifecycle Problem definitionFirst, we need to understand the problem. Identify the business objectives and available resources t...00
SKSion Kiminsionkim.hashnode.dev·Sep 27, 2024 · 3 min readDatabase Systems - Relational Model & AlgebraNotes from CMU Intro to Database Systems Database Organized collection of inter-related data that models some aspect of the real-world DBMS (Database Management System) Software that allows applications to store and analyze information in a databa...00
SKSion Kiminsionkim.hashnode.dev·Sep 12, 2024 · 1 min readSnowflake Architecture at High LevelSnowflake Managed OLAP DBMS written in C++ from scratch Shared disk architecture with compute side local caching (save money to retrieve objects from S3) Three Distinct Layers Database storage Snowflake has cloud hosted object store on AWS S3, Azu...00