Using DuckDB for CSV Managment

preview_player
Показать описание
In this video I install DBeaver, import csv files into duckdb, and run through some simple sql scripts. Because importing csvs is so easy in duckdb it is worth using the database as a central store of csv files.

0:00 Start
00:12 install dbeaver (01:30)
01:00 download diamonds (03:40)
01:21 import csv (04:18)
1:50 view imported data (7:20)
02:51 sql review (10:12)

FREE AND OPEN SOURCE SOFTWARE THAT I CURRENTLY USE:

  1. xvzf
  2. dbeaver
  3. duckdb
  4. csv
  5. sqlite
  6. sql
Рекомендации по теме
Using DuckDB for 0:14:06

Using DuckDB for CSV Managment

How does DuckDB 0:03:26

How does DuckDB deal with dirty data in CSV files?

Ingesting #csv files 0:00:54

Ingesting #csv files from #github into #duckdb

Joining CSV files 0:04:36

Joining CSV files on the fly with DuckDB

DuckDB Tutorial For 0:11:25

DuckDB Tutorial For Beginners

Using DuckDB to 0:04:19

Using DuckDB to analyze the data quality of Apache Parquet files

5 ways that 0:03:53

5 ways that DuckDB makes SQL better

Analyse Your Data 0:00:44

Analyse Your Data Locally With DuckDB! #shorts

Exploring DuckDB: A 0:35:26

Exploring DuckDB: A relational database built for online analytical processing

How to Extract 0:02:50

How to Extract Information from CSV Files using DuckDB and SQL

Using DuckDB and 0:06:52

Using DuckDB and Data-Diff together to compare text/csv data files

CSV: easy as 0:12:16

CSV: easy as 1-2-3 with ibis and duckdb

Load data into 0:00:59

Load data into DuckDB and unlock your Data - In 59secs!

Exporting CSV files 0:04:49

Exporting CSV files to Parquet with Pandas, Polars, and DuckDB

DuckDB Tutorial - 0:25:53

DuckDB Tutorial - DuckDB course for beginners

Why use DuckDB 0:22:26

Why use DuckDB in your data pipelines ft. Niels Claeys

Composable Queries with 0:07:06

Composable Queries with DuckDB

Use SQL to 0:05:26

Use SQL to manipulate CSV Files & Python in Jupyter Notebook with DuckDB

How to use 0:05:47

How to use DuckDB: A fast, self-contained analytics database

DuckDB: The Ultimate 0:02:08

DuckDB: The Ultimate Tool for CSV Querying in the Terminal

DuckDB and SQL 0:24:31

DuckDB and SQL - for Data Analysis and Processing

Analyze MILLIONS of 0:29:34

Analyze MILLIONS of points in SECONDS (on your computer) with DuckDB for GIS

Practical Applications for 1:08:05

Practical Applications for DuckDB (with Simon Aubury & Ned Letcher)

Using the {arrow} 0:18:18

Using the {arrow} and {duckdb} packages to wrangle medical datasets that are Larger than RAM

Комментарии
Автор

Nice video, thanks. I've just been trying it out myself over the last week as an alternative to importing in PostgreSQL and it's pretty handy

malcolmcoull
Автор

What problem I have run into with duckdb 0.8 couldnt read db created with 0.71....

CaribouDataScience