duckdb_quickstart_csv_ingestion_and_sql_queries.py

1import duckdb
2
3# Create a connection to an in-memory database
4con = duckdb.connect(database=':memory:')
5
6# Create a table from a CSV file (using a sample URL or local path)
7con.execute("CREATE TABLE users AS SELECT * FROM 'https://raw.githubusercontent.com/duckdb/duckdb/master/data/csv/iris.csv'")
8
9# Run a SQL query and fetch the result as a list of tuples
10results = con.execute("SELECT * FROM users LIMIT 5").fetchall()
11
12# Print the results
13for row in results:
14    print(row)
15
16# You can also fetch results as a Pandas DataFrame or Polars DataFrame
17# df = con.execute("SELECT * FROM users").df()