CODE Magazine / Articles

CSV

Articles filed under CSV

Articles

Showing 1–3 of 3

  1. CODE Magazine: 2023 - May/Jun cover

    Using DuckDB for Data Analytics

    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.

  2. CODE Magazine: 2023 - March/April cover

    Introduction to Snowflake

    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.

  3. CODE Magazine: 2022 - January/February cover

    The Secrets of Manipulating CSV Files

    Rod shows you how CSV is anything but old news.