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.
A process to import this text file into our RDS instance in a timely manner.
7 freelanceri licitează în medie 170$ pentru acest proiect
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.
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 Mai multe
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 Mai multe
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 Mai multe
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