import duckdb

conn = duckdb.connect()
conn.execute("""
CREATE TABLE csv_table AS
SELECT *
FROM read_csv('path/to/your/csv/file.csv', header=True)
""")

conn.execute("""
CREATE TABLE parquet_table AS
SELECT *
FROM read_parquet('path/to/your/parquet/file.parquet')
""")

conn.execute("""
SELECT *
FROM csv_table
JOIN parquet_table
ON csv_table.common_column = parquet_table.common_column
""")
Copy code