How to set sample_size =-1 for insertCSVFromPath

[aszenz]

If detect = true, duckdb fails to insert csv since it doesn't look at all the rows for sniffing column types.
Is their an option to set it to look at all rows?

[au-re]

I'm having the same issue, @aszenz did you find a workaround?

[aszenz]

Not really, one can create a table using the raw query syntax instead:

Create table mycsv as
Select * 
from read_csv_auto('https://example.com/csv', sample_size = -1 )