How does DuckDB deal with dirty data in CSV files?

Описание: In this video, we learn how to use DuckDB to query CSV files that have dirty data.

#duckdb #sql #csv

Resources
► DuckDB - https://duckdb.org/
► Jeff Sackmann's Tennis Dataset - https://github.com/JeffSackmann/tenni...
► DuckDB queries -https://gist.github.com/mneedham/6701...

Timeline
00:00:00 Intro
00:00:24 Inferring the schema for players CSV file
00:00:31 Schema inference fails
00:00:54 All fields varchars
00:01:29 Sample all the rows
00:01:59 Manually define the schema
00:02:23 Ignore bad rows
00:02:50 Outro