-
Using DuckDB for Data Analytics
By:
Wei-Meng Lee
Last updated: Monday, December 8, 2025
Published in: CODE Magazine: 2023 - May/Jun
In this article by Wei-Meng Lee, the author introduces DuckDB, a Relational Database Management System (RDBMS) that supports Structured Query Language (SQL) and is designed for data analytics. Unlike traditional database systems, DuckDB does not require installation and can run queries directly on Pandas data. The article provides examples and demonstrations of how to use DuckDB for data analytics tasks, including loading datasets, querying data using SQL, and performing analytics on the data. The author also discusses the recently added support for JSON ingestion in DuckDB. Overall, the article highlights the convenience and efficiency of using DuckDB for data analytics tasks.
-
Introduction to Snowflake
By:
Rod Paddock
Last updated: Wednesday, November 22, 2023
Published in: CODE Magazine: 2023 - March/April
In this article, author Rod Paddock introduces Snowflake, a cloud-based SQL database that offers a range of capabilities for developers. Paddock discusses the features of Snowflake, such as its cloud-agnostic nature, support for querying JSON data, and secure data sharing capabilities. He explains how Snowflake's unique architecture allows for "infinite" computing through its warehouse concept and provides insights into using Snowsight, the web-based application for managing Snowflake infrastructure. Rod also discusses building a data loading pipeline, securing data with masking, and sharing data with other Snowflake users. He concludes by highlighting the power and user-friendly nature of Snowflake as a game-changing product.
-
The Secrets of Manipulating CSV Files
By:
Last updated: Tuesday, January 14, 2025
Published in: CODE Magazine: 2022 - January/February
Rod shows you how CSV is anything but old news.
- Home
Articles filed in category 'CSV'