Sign Up
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Introducing the new era of #ValueDrivenAI. Welcome to the DataRobot AI Platform 9.0. Find out more.

Export to Existing Postgres Table

ahatisTW
NiCd Battery
‎10-15-2019 08:13 PM

Export to Existing Postgres Table

We have a Data Connector to a Postgres database (AWS Aurora). The connector can browse the table space and read data from the tables. However, when we try export a data set through the connector we get a failure. 

Steps to perform export:

  1. Navigate to Library.
  2. Select EXPORT from the data set.
  3. Select the configured Postgres data connector.
  4. Browse the table space to the location "demand_planning/public". No tables are listed.
  5. Click the SELECT button.
  6. For the name, enter "DataQualityResults". This is the name of an existing table under "demand_planning/public".
  7. The export fails with the following error.
Reason: Batch entry 0 INSERT INTO "demand_planning"."public"."DataQualityResults" ("CLIENT", "RECORD_TYPE", "ITEM_DESCRIPTION", "SALES_UOM", "ALL_EXCEPTIONS", "EXCEPTION_DESCRIPTION", "TIMESTAMP", "ITEM_NUMBER", "UA_ITEM_DESCRIPTION", "UNIT_OF_MEASURE_CONVERSION", "ALTERNATE_UNIT_OF_MEASURE", "ALT_UOM_QUANTITY", "UNIT_OF_MEASURE (UOM)", "WEEK_STARTING_DATE") VALUES ('Wings','SALES_HISTORY',NULL,'EA','SE008|SE003','Missing Item Number In Sales History|Se003|||||','2019-10-01',NULL,'Classic Buffalo',NULL,NULL,NULL,'EA','2019-3-17 17:0:0.000000 -7:0:0') was aborted.  Call getNextException to see the cause.
If we enter a new unique name (that isn't an existing table), the export succeeds.

We are using the master user and password for the database, so it cannot be a database permissions error.
Labels (1)
Labels
0 Kudos
Reply
3 Replies
Melanie
Linear Actuator
‎10-16-2019 07:38 PM

@ahatisTW thank you for the suggestion and duly noted. cheers
0 Kudos
Reply
ahatisTW
NiCd Battery
‎10-16-2019 04:20 AM

Thanks. That was it and should have checked the structures. An enhance idea is to just throw a more descriptive error when this occurs. 
0 Kudos
Reply
bstephens
Linear Actuator
‎10-15-2019 08:42 PM

@ahatisTW

When attempting to export data into an existing database table, you have to make sure that the column names of the new dataset exactly match the the existing table.  Can you verify that the dataset and table columns match? 

If they don't match, you can rename the columns in a Project to match the table structure and attempt to export again. 

Thanks,
Bill
0 Kudos
Reply