Import large text file into Auora DB Postgres

Đã Đóng Đã đăng vào 3 năm trước Thanh toán khi bàn giao
Đã Đóng Thanh toán khi bàn giao

We have a dataset that needs to be imported into our RDS Postgres instance. The dataset is a text file delimited with |.

The catch is the table has 100+ columns and fails with the COPY command. This is because the row size is too large.

Deliverables

A process to import this text file into our RDS instance in a timely manner.

PostgreSQL Amazon Web Services

ID dự án: #28945870

Về dự án

6 đề xuất Dự án từ xa 3 năm trước đang mở

6 freelancer chào giá trung bình$193 cho công việc này

SqlDevelopment

I can efficiently help with problematic data import because I am Senior Database/BI Developer with more than 10 years of professional experience and with highly advanced expertise in implementation of complex ETL proce Thêm

$250 USD trong 3 ngày
(5 Nhận xét)
3.0
basselafrem

I have been working with aws since 2019 and I know aws s3, cloudfront, ec2 very well. I am a AWS solution architect proffessional certified, networking and security specialized.

$278 USD trong 5 ngày
(1 Nhận xét)
1.5
abhigupta0493

Hey, I am abhi gupta. I have 6 years 2 months experience Big data & Java Developement using: Technology: -Java -Spring Boot -Spring Data -Spring core & mvc framework -Spring Security -Hibernate -Spring Web -Spring JD Thêm

$100 USD trong 2 ngày
(0 Nhận xét)
0.0
esale

Hi, I have a Master of Engineering degree and a lot of experience with Postgres and importing datasets. One question, are you getting the "ERROR: row is too big: size xxxxxx maximum size 8160" error or something simi Thêm

$170 USD trong 5 ngày
(0 Nhận xét)
0.0
goodwork20k

Hello, I am a powershell and postgress sql expert, i can help you to make powershell script and import the data into postgress db Please ping me for further disuccsion thanks

$200 USD trong 4 ngày
(0 Nhận xét)
1.5