SL12345
New Contributor III
Joined 4 years ago
User Profile
User Widgets
Contributions
How to Safely Append New Blackout Datetime to Pipeline Schedule Without Overwriting Existing Ones?
Hi community, I’d like to ask how I can set blackout dates for a specific pipeline. Recently, the blackout date format changed — now it’s possible to specify not only the date but also the time. According to the metadata, the blackout date fields are: jsonPath($, "$schedule.repeat.blackout_datetimes[*].startDate") and jsonPath($, "$schedule.repeat.blackout_datetimes[*].endDate") My questions are: How can I add a new blackout datetime if no blackout is currently defined (i.e. the fields don't exist yet, and concat fails)? When a blackout already exists, adding a new one overwrites the existing start and end date/time. I’m looking for a universal approach to append one new blackout datetime (start + end) to the list — without creating duplicates, and whether or not blackout dates already exist. Thank you very much in advance!Best Approach for Handling CSV Import with Truncate in Pipeline: Ensuring Correct Execution Order
I want to ask: I’m attaching a screenshot of the pipeline that should: Read a CSV file, truncate SQL tables, and after the successful truncate, insert all the records from the CSV into the truncated table. It seems that the pipeline doesn't work correctly. It reads the CSV file (100k rows), then does the truncate, and inserts new rows. Shouldn’t there be a GATE or sequence before the truncate step? I mean, to make sure that the truncate happens only once after all the rows are loaded? What’s the best approach? Thank you.Logging mechanism in order to get parent pipeline name in logging pipeline
Hi Snaplogic experts i have general question, concerning logging. Lets say pipeline with logging function can be called by 5 parent pipelines: parent_pipeline_A parent_pipeline_B parent_pipeline_C .. .. then i have child_pipeline_A child_pipeline_B and pipelineWithLogging() workflow: parent calls child and child has another child - pipelineWithLogging() parent_pipeline_A -> child_pipeline_A -> pipelineWithLogging() parent_pipeline_B -> child_pipeline_B -> pipelineWithLogging() parent_pipeline_C -> pipelineWithLogging() Question: What is the best approach to get pipeline names from parent pipelines to pipelineWithLogging() in order to log them? Is good approach to get rootRuuid and parentRuuid and pair them later on and be able to read: log message: FileA from parent_pipeline_A processed successfully ? (it is just dummy text :)) Thank you
