Închis

Import large text file into Auora DB Postgres

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.

Aptitudini: PostgreSQL, Servicii Web Amazon

Vezi mai multe: sorting large text file, script numbering large text file, large text file viewer, import large excel file multiple worksheets, vbs import custom text file access, algorithm search large text file php, vbscript read header large text file, open large large large text file access access, vbscript import line text file access, quick sort large text file, import large sqlgz file mysql, import export text file vbs, python import script text file tab, sorting large text file java, free large text file translater, can coding import csv text file datagrid view, excel macro vba import csv text file, excel import large text file multiple worksheets, import large text file into excel

Despre angajator:
( 1 părere ) Băilești, Romania

ID Proiect: #28945870

7 freelanceri licitează în medie 170$ pentru acest proiect

(2 recenzii)
1.9
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.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(1 părere)
1.5
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 3 zile
(2 recenzii)
1.6
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)
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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(0 recenzii)
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

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 4 zile
(0 recenzii)
1.6
(0 recenzii)
0.0