Duckdb

# def get_schema_from_file_by_duckdb(file_path, buffer_record: int = 10_000) -> dict[str, str]:
#     import duckdb
#     tmp_table_name = "_".join([re.sub(re.compile(r"[+-]", re.A), "_", ModelFileMetadata.from_path(file_path).name), uuid.uuid4().hex[:8]])
#     with duckdb.connect(database=":memory:") as con:
#         con.execute(f"CREATE TABLE {tmp_table_name} AS SELECT * FROM read_csv_auto('{file_path}', sample_size={buffer_record})")
#         schema = con.execute(f"DESCRIBE {tmp_table_name}").fetchall()
#         dict_schema = {column[0]: column[1] for column in schema}
#         return dict_schema