Hi all, I'm having an issue importing data from my...
# gooddata-platformp
Paul H
10/18/2023, 8:41 AMHi all, I'm having an issue importing data from my PostgreSQL database. It looks like my customer IDs are too large. Here is the error that is shown in the log when the data sync fails:
Upload to dataset dataset.customers failed with 'An error occured during loading of csv files: SQLSTATE_NUMERIC_VALUE_OUT_OF_RANGE. Details: numeric field overflow: 6590351081624'.Paul H
10/18/2023, 8:44 AMI can see that this column is set to int8. Is there any way to change this?
Paul H
10/18/2023, 8:47 AMOkay, I have solved the issue. I managed to change the data type for the relevant field to bigint. This has allowed me to import successfully.
🙌 1
m
Moises Morales
10/18/2023, 8:57 AMGlad to hear Paul H. It is also possible to modify the datatype via MAQL DDL as explained in our documentation: MAQL DDL | GoodData Enterprise
p
Paul H
10/18/2023, 10:07 AMGreat, thanks Moises. That's useful to know 👍