Connect Dataiku to Postgres

rafael_rosado97

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

Alexandru

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