Connect Dataiku to Postgres
![rafael_rosado97](https://us.v-cdn.net/6038231/uploads/Dataiku/nAvatar14.png)
Hello, Dataiku Team
I made a connection between a Postgres RDS and Dataiku. It worked ok.
I decided to make a backup in a new virtual machine (ubuntu) in a EC2 of the RDS. I restored it on the installed Postgres in this virtual machine. Before restoring, I created a new user and bd to restore it. I made the new connection between the postgres virtual machine and Dataiku, it worked well. But when I wanted to run a recipe on one of those tables that become from the backup, it shows, for example: Job failed: ERROR: relation "my_table" already exists.
I already executed the next commands in psql:
GRANT ALL PRIVILEGES ON DATABASE <bd_name> TO <user_name>;
GRANT SELECT, INSERT, UPDATE, DELETE ON ALL TABLES IN SCHEMA <schema_name> TO <user_name>;
When I create a complete new table with a recipe, it works well.
Why does it happen?
Thank you!!!!
Operating system used: Ubuntu
Answers
-
Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,211 Dataiker
Hi,
The error suggests the table already exists; this can happen if the table name is too long > 63 characters(postgres limitation).
You should change the table name in the settings tab of the shorter name to resolve this.
Thanks