0

Trigger a Incorta Load with custom filters in script

I want to add dynamic input to my sql where condition to support reloads if required.

filter condition would be based on the date.

This will help us not to change the sql in prod environments in case of relaods

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Gnaneshwar Muthaluri -- can you provide an example of what you'd like the SQL to look like ideally?  That will help us make suggestions that the platform would support.

    Like
  • Example :

    Consider history TableA .

    Expected Query :

    select * from TABLEA  where  snapshotdate =  ( CASE WHEN '@datevariable' IS NULL THEN '@SYSDATE' ELSE  '@datevariable'   END )

    '@datevariable' = This will be a dynamic/user input if the table needs to be reloaded for a previous date.

    Like
Like Follow
  • 2 yrs agoLast active
  • 2Replies
  • 51Views
  • 2 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.