Hi,
I'm trying to find out what is the recommended way to bulk load data from csv into the database (eg postgres) regularly in prefect.
I understand I can do "insert into table ... " and use postgres.PostgresExecuteMany task, but I'm concerned that for very large files it might be slow.
Is there a way to execute pg copy (or COPY), or "insert into" is how I should do it in prefect?