Client APIs
CSV Files
CSV files can be read using the `read_csv` function, called either from within Python or directly from within SQL. By default, the `read_csv` function attempts to auto-detect the CSV settings by sampling from the provided file.  
Read from a file using fully auto-detected settings:  
```python
duckdb.read_csv("example.csv")
```  
Read multiple CSV files from a folder:  
```python
duckdb.read_csv("folder/*.csv")
```  
Specify options on how the CSV is formatted internally:  
```python
duckdb.read_csv("example.csv", header = False, sep = ",")
```  
Override types of the first two columns:  
```python
duckdb.read_csv("example.csv", dtype = ["int", "varchar"])
```  
Directly read a CSV file from within SQL:  
```python
duckdb.sql("SELECT * FROM 'example.csv'")
```  
Call `read_csv` from within SQL:  
```python
duckdb.sql("SELECT * FROM read_csv('example.csv')")
```  
See the [CSV Import](#docs:data:csv:overview) page for more information.