Import to Neon from Parquet files
Hi, I have a use case in which i need to migrate a table stored in parquet to Neon. With postgres, there are a few options (pg_parquet or use duckdb). Can I use any of the above two options to write data from parquet to Neon? Thank you!
4 Replies
generous-apricot•6mo ago
Hi, we don't support either extension currently but keep an eye out. We may announce something in the near future. You could convert to CSV or explore other methods in the meantime.
abundant-blushOP•6mo ago
what about we go with this route: Parquet -> A postgres database -> Take a backup -> Restore the postgres backup to a Neon database.
eager-peach•6mo ago
Sorry for hopping in from the sidelines, but since Neon is just Postgresql I don't see why that wouldn't work. It'd be the same as restoring the backup to the database it was taken from.
abundant-blushOP•6mo ago
Sounds great! Thank you! Our data is pretty large so the plan is to restore from parquet files to a postgres database, take a backup and restore that backup to Neon.