Error while migrating data from a postgresql table into a redshift table #25
Unanswered
darshansetty
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Hi ,
I am getting the below error while migrating a table from postgres to redshift table. Please help me explain the error and a solution to it.
Error Below :
map[dsType:redshift error:FATAL: terminating connection due to administrator command (SQLSTATE 57P01) query:INSERT INTO modere_staging.marts_sales_history (item, ship_from_code, ship_to_customer_code, ship_to_cust_id_exigo, sdate, order_creation_date, order_id, order_id_exigo, order_line_number, order_status, ordered_ship_quantity, sqty, unit_of_measure, all_customers, all_locations, record_creation_timestamp) VALUES ('16003GB','1','EUD680549','3955384','2022-09-19 00:00:00.000000 +0000','2022/09/17',301921648,'19352848',2,'Invoiced',1,1,'ea','All','All','2023-02-07 16:26:20.532160 +0000'),('17004GB','1','EUD680549','3955384','2022-09-19 00:00:00.000000 +0000','2022/09/17',301921648,'19352848',3,'Invoiced',1,1,'ea','All','All','2023-02-07 16:26:20.532160 +0000'),('17004GB','1','EUD680549','3955384','2022-09-19 00:00:00.000000 +0000','2022/09/17',301921648,'19352848',4,'Invoiced',1,1,'ea','All','All','2023-02-07 16:26:20.532160 +0000'),('17006GB','1','EUD680549','3955384','2022-09-19 00:00:00.000000 +0000','2022/09/17',301921648,'19352848',9,'Invoiced',1,1,'ea','All','All','2023-02-07 16:26:2 ... (Rest of query truncated)] db.Query() threw an error
SQLPIPE command Below:
./sqlpipe transfer
--source-ds-type "postgresql"
--source-hostname "data-warehouse-non-prod.garvis.ai"
--source-port 5432
--source-db-name "data_warehouse"
--source-username "master"
--source-password ""
--target-ds-type "redshift"
--target-hostname "default.443079718186.eu-west-1.redshift-serverless.amazonaws.com"
--target-port 5439
--target-db-name "dev"
--target-username "airbyte"
--target-password ""
--target-schema "modere_staging"
--target-table "marts_sales_history" \
--overwrite
--query "select * from modere_staging.marts_sales_history"
All reactions