Saturday 18 July 2015

Talend : running multiple SQL statements using database row component (example aws redshift tRedshiftRow)

Talend : running multiple SQL statements using database row component (example aws redshift tRedshiftRow)

Problem - You might need to run more than one statement in tRedshiftRow (or any other database Row component in talend).

Solution - You can do this by writing your statements in a single string separated by the statement separator for the DB you are using for redshift its ; and i guess for most its the same.

I majorly issue vacuum and analyze commands for my db tables as last job of my load.
example below - just below sql in tREdshiftRow component and it will execute it as multi-statement sql.

"vacuum table1;
vacuum table2;
vacuum table3;
"

7 comments:

  1. Very impressive and very useful post, thank you for sharing with us. Know more about talend online trianing

    ReplyDelete
  2. Set aside my effort to peruse all the remarks, however I truly delighted in the article. It's consistently pleasant when you can not exclusively be educated, yet in addition, engaged!
    360DigiTMG Data Analytics Course

    ReplyDelete
  3. wonderful bLog! its intriguing. thankful to you for sharing.

    data science certification

    ReplyDelete
  4. Truly overall quite fascinating post. I was searching for this sort of data and delighted in perusing this one. Continue posting. Much obliged for sharing.Best data analytics course in Hyderabad

    ReplyDelete
  5. Your amazing insightful information entails much to me and especially to my peers. Thanks a ton; from all of us.
    Best Data Science Courses in Hyderabad

    ReplyDelete