Category: Uncategorized

Open Table Format = the metadata layer that makes those files behave like database tables. What is a Data Lake? A data lake is a storage system that keeps large amounts of raw and processed data in inexpensive object storage such as: Instead of storing data inside a traditional database, the data is stored as…

Claude Code as AI software engineering agent that lives in the terminal (CLI). Instead of just chatting in a browser, it can directly interact with your codebase, terminal, git repo, files, tests, APIs, and development workflows. Think of it as: A lot of professional developers use it as a “junior-to-mid-level engineer that can execute tasks,”…

GitHub: https://github.com/noeespino/dbql_collect 🧠 1. Conceptual foundation (what you’re actually doing) When you “push code to GitHub,” you’re working with three layers: 🔹 1. Sublime Text Your editor → where you write code 🔹 2. Git Your version control engine → tracks changes locally 🔹 3. GitHub Your remote repository → stores your code online 🔹…

Debugging a Memory Dump with GDB 1. What a “memory dump” actually is Before touching gdb, it’s critical to understand what you are debugging. A memory dump (often called a core dump) is a snapshot of a process’s virtual address space at a specific moment—usually when it crashes (e.g., segmentation fault, abort). The operating system…

Teradata Viewpoint is a web‑based monitoring and management portal provided by Teradata.It gives DBAs, system administrators, workload managers, and support teams a single, centralized view of the Teradata system’s health, performance, and activity. Think of Viewpoint as the “control cockpit” of a Teradata system. It does not store data itself; instead, it pulls metadata and…

List of teradata articles published as a PSE (Product Support Engineer) at Teradata Database – Global Support Organization (TD GSO DBS). KB0056039: Restore job failure: Error 3706 Syntax error: Maximum allowable histogram size exceeded KB0048456: Tables created as FALLBACK although system level dafault is NON-FALLBACK. KB0042200: GRANT CONNECT THROUGH statement fails with 9214 error. KB0045724:…

OOP is a programming paradigm based on the concept of objects, which are self-contained units that combine: Instead of writing programs as a sequence of instructions (as in procedural programming), OOP organizes code around models of real-world entities. 🧱 The Core Idea Think of a class as a blueprint and an object as an instance…

FastLoad is a high‑performance bulk data loading utility in Teradata, designed to load very large volumes of data into empty tables as fast as possible. FastLoad achieves its speed by: In short: FastLoad is optimized for speed, not flexibility. 2. Key Characteristics of FastLoad Feature Description Load Type Bulk insert only Target Table Must be…

Teradata Architecture Overview Teradata is a shared-nothing, massively parallel processing (MPP) database designed to scale linearly. Every component participates in parallel query execution, which is why Teradata performs especially well for large analytical workloads. At a high level: All of this runs on one or more nodes. 1. Nodes A node is a physical or…

The OSI Model is a 7‑layer conceptual framework that describes how data moves from one device to another across a network. 👉 It does not tell you how to build a network👉 It tells you where problems occur and which technology operates at which layer Cisco uses the OSI model primarily for: OSI Layer Overview…