One Star

Open Studio - Defining Schema at Run Time.

I have a requirement to provide the schema at runtime and I realized that it's possible for a few scenarios and NOT for others. Let me explain:
When I attempt to TRUNCATE a table using the tPostgresqlRow component, I'm able to (as shown below).

However, when I use an existing connection to INSERT data into a table I get the following error: 


ERROR: relation "customer" does not exist
  Position: 13ERROR: relation "customer" does not exist
  Position: 13ERROR: relation "customer" does not exist
  Position: 13


I noticed an article on Talend -> "Can I define a schema at run time?" Is this why my INSERT doesn't work, while TRUNCATE works as I can specify the Schema Name?
What's the workaroud? The feature of being able to provide schema name at runtime will be a great way for me to get my work done.
1 REPLY
Moderator

Re: Open Studio - Defining Schema at Run Time.

Hi,
What does your schema look like? Unknown column structure that you have to define it at run time?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.