This post outlines five useful operations for working with DuckDB, including data shuffling, copying table schemas, specifying CSV data types, updating CSV files in-place, and pretty-printing floating-point numbers. Various SQL snippets demonstrate how to achieve these operations efficiently.
Table of contents
Creating the example data setPretty-printing floating-point numbersCopying the schema of a tableShuffling dataSpecifying types in the CSV loaderUpdating CSV files in-placeClosing thoughts1 Comment
Sort: