Duckdb 0.6.1 timestamp-in-csv parsing issues

convert_all.py

#!/usr/bin/env python
from datetime import datetime
from pathlib import Path

import duckdb

import sql_statements


def main():
    csv_dir = Path('csv.gz')
    csv_files = sorted(csv_dir.glob('*.csv.gz'))

    con = duckdb.connect('demo.duckdb')

    for csv_file in csv_files:
        parquet_file = str(csv_file).replace('csv.gz', 'parquet')
        print(f'{datetime.now()} Converting file {csv_file} to {parquet_file}')
        convert_sql = sql_statements.convert_template % (csv_file, parquet_file)
        con.execute(convert_sql)


if __name__ == '__main__':
    main()

convert_demo.sql

LOAD parquet;

COPY (
    SELECT
        cast(created as timestamptz),
        type_,
    FROM read_csv(
        'demo.csv',
        header=True,
        columns={
            'created':  'varchar',
            'type_':    'int4'
        }
    )
) TO 'demo.parquet' (format 'parquet');

demo.csv

stdout.txt

# Run in bash with `< convert_demo.sql duckdb`
# macOS with duckdb 0.6.1, homebrew-installed

Error: near line 3: Conversion Error: timestamp field value out of range: "2020-08-30 06:00:07.378966 UTC", expected format is (YYYY-MM-DD HH:MM:SS[.US][±HH:MM| ZONE])