\n
The problem is with this part
\n
I copy my result set.
\nI keep my first output
\nAnd aggregate my second output
\nAnd finally I want to take those aggregate results using a lookup.
This make my pipeline run endlessly. And if I remove the lookup (or join) and write to two different files it takes less than 2 minutes.
\nI think may be its because the two outputs are the image of the same result set.
Could you please tell me if you have seen this issue before and how to treat it.
\nThank you
","body@stringLength":"621","rawBody":"Hello,
\nI am working on this pipeline
\n
The problem is with this part
\n
I copy my result set.
\nI keep my first output
\nAnd aggregate my second output
\nAnd finally I want to take those aggregate results using a lookup.
This make my pipeline run endlessly. And if I remove the lookup (or join) and write to two different files it takes less than 2 minutes.
\nI think may be its because the two outputs are the image of the same result set.
Could you please tell me if you have seen this issue before and how to treat it.
\nThank you
","kudosSumWeight":0,"postTime":"2021-09-07T09:34:51.870-07:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:17776_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":9454},"read":false,"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"searchSnippet":"Hello, \n I am working on this pipeline \n \n The problem is with this part \n \n I copy my result set. \nI keep my first output \nAnd aggregate my second output \nAnd finally I want to take those a...","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8MQ","node":{"__ref":"AcceptedSolutionMessage:message:17784"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Mg","node":{"__ref":"ForumReplyMessage:message:17777"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Mw","node":{"__ref":"ForumReplyMessage:message:17778"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8NA","node":{"__ref":"ForumReplyMessage:message:17780"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8NQ","node":{"__ref":"ForumReplyMessage:message:17781"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Ng","node":{"__ref":"ForumReplyMessage:message:17782"}},{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wxMHwxNDowLDM5OjF8Nw","node":{"__ref":"ForumReplyMessage:message:17787"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:17776":{"__typename":"Conversation","id":"conversation:17776","solved":true,"topic":{"__ref":"ForumTopicMessage:message:17776"},"lastPostingActivityTime":"2023-06-02T06:20:38.275-07:00","lastPostTime":"2023-06-02T06:20:38.275-07:00","unreadReplyCount":11,"isSubscribed":false},"ModerationData:moderation_data:17776":{"__typename":"ModerationData","id":"moderation_data:17776","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:17776_1":{"__typename":"Revision","id":"revision:17776_1","lastEditTime":"2021-09-07T09:34:51.870-07:00"},"CachedAsset:theme:customTheme1-1750778159383":{"__typename":"CachedAsset","id":"theme:customTheme1-1750778159383","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"webicon-1744319537585.png","imageLastModified":"1744319538967","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"snaplogic-rgb-cropped-1744295700098.png","imageLastModified":"1744295701820","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1350px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"100vw","borderRadius":"100vw","borderRadiusLg":"100vw","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"20px","paddingXLg":"32px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"700","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"NONE","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.06)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.15)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"#006EF5","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","defaultMessageFontFamily":"var(--lia-bs-font-family-base)","forumColor":"#4099E2","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#148563","blogColor":"#1CBAA0","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#4C6B90","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#949494","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#003399","secondary":"#333333","bodyText":"#0E1831","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FFD700","danger":"#D13A1F","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#2DA493","#FF0083","#006EF5","#FFD700","#F26D0E","#182852","#E7F5FF"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Poppins","fontStyle":"NORMAL","fontWeight":"500","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"30px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"30px","tableBgColor":"transparent","tableBorderColor":"var(--lia-bs-gray-700)","tableBorderStyle":"solid","tableCellPaddingX":"5px","tableCellPaddingY":"5px","tableTextColor":"var(--lia-bs-body-color)","tableVerticalAlign":"middle","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"Roboto","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"GOOGLE","name":"Poppins","styles":[{"style":"NORMAL","weight":"300","__typename":"FontStyleData"},{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"500","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"},{"style":"ITALIC","weight":"500","__typename":"FontStyleData"},{"style":"ITALIC","weight":"700","__typename":"FontStyleData"}],"assetNames":["Poppins-italic-400.woff2","Poppins-italic-500.woff2","Poppins-italic-700.woff2","Poppins-normal-300.woff2","Poppins-normal-400.woff2","Poppins-normal-500.woff2","Poppins-normal-700.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1750955844577","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:pipelines-1754514903715":{"__typename":"CachedAsset","id":"quilt:snaplogic.prod:pages/forums/ForumMessagePage:board:pipelines-1754514903715","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"removeComponents":["community.widget.bannerWidget"],"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"items":[{"layout":"MAIN_SIDE","id":"message-list","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"messages.widget.relatedContentWidget","props":{"lazyLoad":true},"__typename":"QuiltComponent"},{"id":"messages.widget.messageListForNodeByRecentActivityWidget","props":{"viewVariant":{"type":"inline","props":{"useUnreadCount":false,"useViewCount":false,"renderPostTimeBeforeAuthor":true,"useSearchSnippet":false,"useAuthorLogin":true,"clampBodyLines":3,"useAvatar":true,"useBoardIcon":false,"useAuthorRank":false,"useKudosCount":false,"useMedia":false,"usePreviewMedia":false,"useTags":false,"useNode":false,"useNodeLink":true,"useTextBody":true,"truncateBodyLength":-1,"useBody":false,"useRepliesCount":false,"useSolvedBadge":true,"useTimeToRead":false,"timeStampType":"conversation.lastPostingActivityTime","useMessageTimeLink":true,"clampSubjectLines":1,"useSpoilerFreeBody":true,"useNodeHoverCard":true,"avatarSize":"40","boardIconSize":"24","subjectAs":"h6"}},"pagerVariant":{"type":"loadMore"},"panelType":"divider","pageSize":5,"useTitle":true,"sorts":{"conversationLastPostingActivityTime":{"direction":"DESC"}},"hideIfEmpty":true,"style":"compact","showTabs":false},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"},"__typename":"MainSideQuiltSection"}],"__typename":"QuiltContainer"},"__typename":"Quilt"},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1750955844577","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1750955844577","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived"},"localOverride":false},"CachedAsset:quiltWrapper:snaplogic.prod:Common:1750955844579":{"__typename":"CachedAsset","id":"quiltWrapper:snaplogic.prod:Common:1750955844579","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":false,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"links":{"sideLinks":[],"mainLinks":[{"children":[{"linkType":"INTERNAL","id":"migrated-link-2","params":{"boardId":"ai_ml","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-3","params":{"boardId":"app_integration","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-4","params":{"boardId":"data_integration","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-5","params":{"boardId":"apim","categoryId":"product_categories"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-7","params":{"boardId":"releases","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-8","params":{"boardId":"pipelines","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-9","params":{"boardId":"snaps","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-10","params":{"boardId":"snap_dev","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-11","params":{"boardId":"patterns","categoryId":"platform"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-12","params":{"boardId":"snaplabs","categoryId":"products"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-13","params":{"boardId":"sl-tech-blog","categoryId":"products"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-14","params":{"boardId":"solutions","categoryId":"products"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-15","params":{"boardId":"ux_program","categoryId":"products"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-0","params":{"categoryId":"products"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-17","params":{"boardId":"getting_started","categoryId":"learning"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-18","params":{"boardId":"training","categoryId":"learning"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-16","params":{"categoryId":"learning"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-20","params":{"boardId":"sigma","categoryId":"architecture_center"},"routeName":"ForumBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-21","params":{"boardId":"sigma_podcasts","categoryId":"architecture_center"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-19","params":{"categoryId":"architecture_center"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"migrated-link-22","params":{"categoryId":"sl-events"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-24","params":{"groupHubId":"partners"},"routeName":"GroupHubPage"},{"linkType":"INTERNAL","id":"migrated-link-25","params":{"groupHubId":"higher_ed_users"},"routeName":"GroupHubPage"}],"linkType":"INTERNAL","id":"migrated-link-23","params":{"categoryId":"user-groups"},"routeName":"CategoryPage"},{"children":[{"linkType":"INTERNAL","id":"migrated-link-27","params":{"boardId":"about","categoryId":"community_hub"},"routeName":"BlogBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-28","params":{"boardId":"about-this-community","categoryId":"nation-hub"},"routeName":"TkbBoardPage"},{"linkType":"INTERNAL","id":"migrated-link-29","params":{"categoryId":"mvp"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-30","params":{"categoryId":"customer_awards"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"migrated-link-31","params":{"boardId":"hiring","categoryId":"community_hub"},"routeName":"ForumBoardPage"}],"linkType":"INTERNAL","id":"migrated-link-26","params":{"categoryId":"community_hub"},"routeName":"CategoryPage"}]},"className":"QuiltComponent_lia-component-edit-mode__0nCcm","style":{"boxShadow":"0","linkFontWeight":"500","controllerHighlightColor":"#FF0083","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkFontSize":"16px","linkBoxShadowHover":"none","backgroundOpacity":1,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","linkTextBorderBottom":"none","hamburgerColor":"var(--lia-nav-controller-icon-color)","brandLogoHeight":"48px","linkLetterSpacing":"normal","linkBgHoverColor":"transparent","collapseMenuDividerOpacity":0.16,"paddingBottom":"15px","dropdownPaddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"0","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","linkJustifyContent":"center","linkColor":"var(--lia-bs-primary)","collapseMenuDividerBg":"var(--lia-nav-link-color)","dropdownPaddingTop":"10px","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerHighlightTextColor":"var(--lia-yiq-dark)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-primary)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-primary)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","linkPaddingX":"10px","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","paddingTop":"15px","linkPaddingY":"5px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkBgColor":"transparent","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-primary)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-primary)"},"showSearchIcon":true,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-body-color)","visualEffects":{"showBottomBorder":false},"linkTextColor":"var(--lia-bs-primary)"},"__typename":"QuiltComponent"},{"id":"community.widget.bannerWidget","props":{"backgroundColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"backgroundOpacity":100,"backgroundImageProps":{"assetName":"community-widget-bannerWidget-1744318647965.png","backgroundSize":"COVER","lastModified":"1744318648000,1744318648000","backgroundPosition":"CENTER_CENTER","backgroundRepeat":"NO_REPEAT"},"fontColor":"var(--lia-bs-white)"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"custom.widget.CustomFooterSnaplogic","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":true,"backgroundColor":"#003399","useBackground":false,"backgroundOpacity":1,"title":""},"__typename":"QuiltComponent"},{"id":"custom.widget.Custom_Footer_Snaplogic_Subfooter","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":true,"backgroundColor":"#182852","useBackground":false,"backgroundOpacity":1,"title":""},"__typename":"QuiltComponent"},{"id":"community.widget.footerWidget","props":null,"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1750955844577","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:component:custom.widget.CustomFooterSnaplogic-en-us-1750778173423":{"__typename":"CachedAsset","id":"component:custom.widget.CustomFooterSnaplogic-en-us-1750778173423","value":{"component":{"id":"custom.widget.CustomFooterSnaplogic","template":{"id":"CustomFooterSnaplogic","markupLanguage":"REACT","style":null,"texts":{},"defaults":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.CustomFooterSnaplogic","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.Custom_Footer_Snaplogic_Subfooter-en-us-1750778173423":{"__typename":"CachedAsset","id":"component:custom.widget.Custom_Footer_Snaplogic_Subfooter-en-us-1750778173423","value":{"component":{"id":"custom.widget.Custom_Footer_Snaplogic_Subfooter","template":{"id":"Custom_Footer_Snaplogic_Subfooter","markupLanguage":"HANDLEBARS","style":".custom-footer-bottom {\n --footer-bg-color-darker: #182852;\n --footer-link-color: #ffffff;\n --footer-fg-jade: #2da493;\n\n background-color: var(--footer-bg-color-darker);\n color: var(--footer-link-color);\n padding: 40px 0 32px;\n display: flex;\n flex-direction: column-reverse;\n\n @media (min-width: 991px) {\n flex-direction: row;\n justify-content: space-between;\n }\n\n ul,\n p {\n margin: 0;\n padding: 0;\n list-style: none;\n }\n\n a.link {\n color: var(--footer-link-color);\n font-weight: bold;\n text-decoration: underline;\n\n &:hover {\n color: var(--footer-fg-jade);\n text-decoration: none;\n }\n }\n}\n\n.footer-copyright,\n.social-media-icons {\n width: 100%;\n text-align: center;\n\n @media (min-width: 991px) {\n width: auto;\n text-align: left;\n }\n}\n\n.footer-copyright {\n display: block;\n margin-top: 20px;\n\n @media (min-width: 781px) {\n display: flex;\n justify-content: center;\n gap: 0 20px;\n flex-grow: 1;\n flex-wrap: wrap;\n }\n\n @media (min-width: 991px) {\n margin-top: 0;\n justify-content: flex-start;\n }\n\n ul {\n li {\n display: inline-block;\n }\n\n li + li {\n margin-left: 20px;\n }\n }\n}\n\n.social-media-icons {\n ul.list-inline {\n display: flex;\n align-items: center;\n justify-content: center;\n margin-bottom: 0;\n\n @media (min-width: 781px) {\n align-items: flex-end;\n }\n\n li {\n padding-right: 0;\n\n a {\n padding: 10px;\n\n svg {\n width: 26px;\n height: 26px;\n fill: var(--footer-link-color);\n transition: fill 0.1s ease-in-out;\n }\n }\n\n a:hover {\n svg {\n fill: var(--footer-fg-jade);\n }\n }\n }\n }\n}\n","texts":{},"defaults":{"config":{"applicablePages":[],"description":"Custom footer for links and social media","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Custom_Footer_Snaplogic_Subfooter","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"Custom footer for links and social media","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_Custom_Footer_Snaplogic_Subfooter_custom-footer-bottom_1nmjj_1 {\n --footer-bg-color-darker: #182852;\n --footer-link-color: #ffffff;\n --footer-fg-jade: #2da493;\n\n background-color: var(--footer-bg-color-darker);\n color: var(--footer-link-color);\n padding: 2.5rem 0 2rem;\n display: flex;\n flex-direction: column-reverse;\n\n @media (min-width: 991px) {\n flex-direction: row;\n justify-content: space-between;\n }\n\n ul,\n p {\n margin: 0;\n padding: 0;\n list-style: none;\n }\n\n a.custom_widget_Custom_Footer_Snaplogic_Subfooter_link_1nmjj_24 {\n color: var(--footer-link-color);\n font-weight: bold;\n text-decoration: underline;\n\n &:hover {\n color: var(--footer-fg-jade);\n text-decoration: none;\n }\n }\n}\n\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_footer-copyright_1nmjj_36,\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_social-media-icons_1nmjj_37 {\n width: 100%;\n text-align: center;\n\n @media (min-width: 991px) {\n width: auto;\n text-align: left;\n }\n}\n\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_footer-copyright_1nmjj_36 {\n display: block;\n margin-top: 1.25rem;\n\n @media (min-width: 781px) {\n display: flex;\n justify-content: center;\n gap: 0 1.25rem;\n flex-grow: 1;\n flex-wrap: wrap;\n }\n\n @media (min-width: 991px) {\n margin-top: 0;\n justify-content: flex-start;\n }\n\n ul {\n li {\n display: inline-block;\n }\n\n li + li {\n margin-left: 1.25rem;\n }\n }\n}\n\n.custom_widget_Custom_Footer_Snaplogic_Subfooter_social-media-icons_1nmjj_37 {\n ul.custom_widget_Custom_Footer_Snaplogic_Subfooter_list-inline_1nmjj_76 {\n display: flex;\n align-items: center;\n justify-content: center;\n margin-bottom: 0;\n\n @media (min-width: 781px) {\n align-items: flex-end;\n }\n\n li {\n padding-right: 0;\n\n a {\n padding: 0.625rem;\n\n svg {\n width: 1.625rem;\n height: 1.625rem;\n fill: var(--footer-link-color);\n transition: fill 0.1s ease-in-out;\n }\n }\n\n a:hover {\n svg {\n fill: var(--footer-fg-jade);\n }\n }\n }\n }\n}\n","tokens":{"custom-footer-bottom":"custom_widget_Custom_Footer_Snaplogic_Subfooter_custom-footer-bottom_1nmjj_1","link":"custom_widget_Custom_Footer_Snaplogic_Subfooter_link_1nmjj_24","footer-copyright":"custom_widget_Custom_Footer_Snaplogic_Subfooter_footer-copyright_1nmjj_36","social-media-icons":"custom_widget_Custom_Footer_Snaplogic_Subfooter_social-media-icons_1nmjj_37","list-inline":"custom_widget_Custom_Footer_Snaplogic_Subfooter_list-inline_1nmjj_76"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1750955844577","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1750955844577","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListForNodeByRecentActivityWidget-1750955844577","value":{"title@userScope:other":"Recent Content","title@userScope:self":"Contributions","title@board:FORUM@userScope:other":"Recent Discussions","title@board:BLOG@userScope:other":"Recent Blogs","emptyDescription":"No content to show","MessageListForNodeByRecentActivityWidgetEditor.nodeScope.label":"Scope","title@instance:1737670726207":"Community Activity"},"localOverride":false},"CachedAsset:text:en_US-components/community/FooterWidget-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/FooterWidget-1750955844577","value":{"homeLink":"Community Home","topOfPage":"Top of Page","buildHash":"Build Hash:","buildNumber":"Build Number:","buildTime":"Build Time:","privacyPolicy":"Privacy Policy","helpLink":"Help"},"localOverride":false},"Forum:board:app_integration":{"__typename":"Forum","id":"board:app_integration","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:data_integration":{"__typename":"Forum","id":"board:data_integration","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:apim":{"__typename":"Forum","id":"board:apim","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:ai_ml":{"__typename":"Forum","id":"board:ai_ml","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:releases":{"__typename":"Forum","id":"board:releases","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:snaps":{"__typename":"Forum","id":"board:snaps","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:patterns":{"__typename":"Forum","id":"board:patterns","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:solutions":{"__typename":"Forum","id":"board:solutions","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:learning":{"__typename":"Category","id":"category:learning","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:getting_started":{"__typename":"Forum","id":"board:getting_started","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:sl-events":{"__typename":"Category","id":"category:sl-events","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:mvp":{"__typename":"Category","id":"category:mvp","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:customer_awards":{"__typename":"Category","id":"category:customer_awards","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:partners":{"__typename":"GroupHub","id":"grouphub:partners","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"GroupHub:grouphub:higher_ed_users":{"__typename":"GroupHub","id":"grouphub:higher_ed_users","grouphubPolicies":{"__typename":"GroupHubPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:community_hub":{"__typename":"Category","id":"category:community_hub","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:about":{"__typename":"Blog","id":"board:about","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:user-groups":{"__typename":"Category","id":"category:user-groups","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:hiring":{"__typename":"Forum","id":"board:hiring","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:training":{"__typename":"Forum","id":"board:training","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:ux_program":{"__typename":"Forum","id":"board:ux_program","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:snap_dev":{"__typename":"Forum","id":"board:snap_dev","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:architecture_center":{"__typename":"Category","id":"category:architecture_center","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:sigma":{"__typename":"Forum","id":"board:sigma","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:sl-tech-blog":{"__typename":"Blog","id":"board:sl-tech-blog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Forum:board:snaplabs":{"__typename":"Forum","id":"board:snaplabs","forumPolicies":{"__typename":"ForumPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Conversation:conversation:40388":{"__typename":"Conversation","id":"conversation:40388","topic":{"__typename":"ForumTopicMessage","uid":40388},"lastPostingActivityTime":"2025-08-11T11:30:02.503-07:00","solved":false},"ForumTopicMessage:message:40388":{"__typename":"ForumTopicMessage","subject":"Pagination and nextCursor in header","conversation":{"__ref":"Conversation:conversation:40388"},"id":"message:40388","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40388","revisionNum":1,"uid":40388,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":5263,"login":"jfpelletier","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-2.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":33},"postTime":"2025-07-29T14:13:40.344-07:00","lastPublishTime":"2025-07-29T14:13:40.344-07:00","readOnly":false},"Conversation:conversation:40381":{"__typename":"Conversation","id":"conversation:40381","topic":{"__typename":"ForumTopicMessage","uid":40381},"lastPostingActivityTime":"2025-07-17T14:46:28.452-07:00","solved":true},"ForumTopicMessage:message:40381":{"__typename":"ForumTopicMessage","subject":"Javascript to promote top level lists","conversation":{"__ref":"Conversation:conversation:40381"},"id":"message:40381","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40381","revisionNum":1,"uid":40381,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":5714,"login":"Coyote","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-4.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":30},"postTime":"2025-07-17T12:09:05.438-07:00","lastPublishTime":"2025-07-17T12:09:05.438-07:00","readOnly":false},"Conversation:conversation:40369":{"__typename":"Conversation","id":"conversation:40369","topic":{"__typename":"ForumTopicMessage","uid":40369},"lastPostingActivityTime":"2025-06-20T13:57:59.877-07:00","solved":false},"ForumTopicMessage:message:40369":{"__typename":"ForumTopicMessage","subject":"Google Sheets Subscribe questions","conversation":{"__ref":"Conversation:conversation:40369"},"id":"message:40369","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40369","revisionNum":1,"uid":40369,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":5263,"login":"jfpelletier","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-2.svg?time=0"}},"metrics":{"__typename":"MessageMetrics","views":94},"postTime":"2025-06-20T13:57:59.877-07:00","lastPublishTime":"2025-06-20T13:57:59.877-07:00","readOnly":false},"Conversation:conversation:16868":{"__typename":"Conversation","id":"conversation:16868","topic":{"__typename":"ForumTopicMessage","uid":16868},"lastPostingActivityTime":"2025-06-04T05:57:52.226-07:00","solved":true},"ForumTopicMessage:message:16868":{"__typename":"ForumTopicMessage","subject":"Basic string transformations not working","conversation":{"__ref":"Conversation:conversation:16868"},"id":"message:16868","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:16868","revisionNum":1,"uid":16868,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":2269,"login":"darshthakkar","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/images/dS0yMjY5LTY0MDBpQTdBMUQ0MURDRUUzNUZDNw"}},"metrics":{"__typename":"MessageMetrics","views":3347},"postTime":"2023-05-18T10:58:12.261-07:00","lastPublishTime":"2023-05-18T10:58:12.261-07:00","readOnly":false},"Conversation:conversation:40044":{"__typename":"Conversation","id":"conversation:40044","topic":{"__typename":"ForumTopicMessage","uid":40044},"lastPostingActivityTime":"2025-06-04T05:49:25.845-07:00","solved":true},"ForumTopicMessage:message:40044":{"__typename":"ForumTopicMessage","subject":"Can we generate XML file in pretty print format using native snapLogic snaps?","conversation":{"__ref":"Conversation:conversation:40044"},"id":"message:40044","entityType":"FORUM_TOPIC","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:40044","revisionNum":1,"uid":40044,"depth":0,"board":{"__ref":"Forum:board:pipelines"},"author":{"__typename":"User","uid":2269,"login":"darshthakkar","registrationData":{"__typename":"RegistrationData","status":null},"deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/images/dS0yMjY5LTY0MDBpQTdBMUQ0MURDRUUzNUZDNw"}},"metrics":{"__typename":"MessageMetrics","views":672},"postTime":"2025-04-14T09:19:56.464-07:00","lastPublishTime":"2025-04-14T09:19:56.464-07:00","readOnly":false},"QueryVariables:TopicReplyList:message:17776:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:17776:1","value":{"id":"message:17776","first":10,"sorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"kudosSumWeight":{"direction":"DESC","order":0},"postTime":{"direction":"ASC","order":1}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":true,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/Navbar-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1750955844577","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","migrated-link-9":"Snaps","migrated-link-7":"Release Notes and Announcements","migrated-link-8":"Designing and Running Pipelines","Common-sigma-framework-link":"Sigma Framework","migrated-link-1":"Product Category Discussions","Common-data_integration-link":"Data Integration","migrated-link-2":"AI/ML & GenAI App Builder","migrated-link-0":"Discussions","migrated-link-5":"API Management","migrated-link-6":"Getting the Most Out of the SnapLogic Platform","migrated-link-3":"App Integration","Common-learning-link":"Learning","migrated-link-4":"Data Integration","Common-ai_ml-link":"AI/ML & GenAI App Builder","Common-partner-group-link":"Partner Group","Common-customer_awards-link":"Customer Awards","Common-discussions-link":"Discussions","Common-snap-labs-link":"Snap Labs","Common-app-integration-link":"Product Category Discussions","Common-hiring-link":"Who's Hiring","Common-enterprise-alchemists-link":"Enterprise Alchemists","Common-higher-ed-user-groupsforum-board-link":"Higher Ed Users Group","Common-snaps-link":"Snaps","Common-snap_dev-link":"Snap Development","Common-partner-user-groupsforum-board-link":"Partner User Group","migrated-link-30":"Customer Awards","migrated-link-31":"Who's Hiring","Common-mvp-link":"MVP Program","Common-solution-for-your-business-link":"Solutions for Your Business","Common-platform-link":"Getting the Most Out of the SnapLogic Platform","migrated-link-29":"MVP Program","Common-sigma-framework-library-link":"Sigma Framework Library","migrated-link-27":"About the Nation","Common-pipelines-link":"Designing and Running Pipelines","migrated-link-28":"About this Community","migrated-link-25":"Higher Ed Users Group","migrated-link-26":"Nation Hub","Common-patterns-link":"Patterns","migrated-link-23":"User Groups","Common-partner-category-link":"Partner Category","migrated-link-24":"Partner User Group","Common-product-category-discussions-link":"Product Category Discussions","Common-get-started-link":"Getting Started","Common-about-the-nation-link":"About the Nation","Common-sl-events-link":"All Events","Common-about-this-community-link":"About this Community","Common-nation-hub-link":"Nation Hub","migrated-link-21":"Enterprise Alchemists","migrated-link-22":"All Events","migrated-link-20":"Sigma Framework Library","migrated-link-18":"SnapLogic Academy","migrated-link-19":"Sigma Framework","migrated-link-16":"Learning","migrated-link-17":"Getting Started","migrated-link-14":"Solutions for Your Business","migrated-link-15":"User Experience Program","migrated-link-12":"SnapLabs","migrated-link-13":"SnapLogic Technical Blog","Common-ux_program-link":"User Experience Program","Common-snaplabsforum-board-link":"SnapLabs","migrated-link-10":"Snap Development","migrated-link-11":"Patterns","Common-snaplogic-technical-blog-link":"SnapLogic Technical Blog","Common-releases-link":"Release Notes and Announcements","Common-app_integration-link":"App Integration","Common-snap-logic-academy-link":"SnapLogic Academy","Common-apim-link":"API Management","Common-user-groups-link":"User Groups"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1750955844577","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1750955844577","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1750955844577","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/search/SpotlightSearchIcon-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/search/SpotlightSearchIcon-1750955844577","value":{"search":"Search"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1750955844577","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1750955844577","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1750955844577","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solution","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1750955844577","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1750955844577","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1750955844577","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/BuildInformation-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/BuildInformation-1750955844577","value":{"buildHash":"Build Hash: {buildHash}","buildNumber":"Build Number: {buildNumber}","buildTime":"Build Time: {buildTime}"},"localOverride":false},"CachedAsset:text:en_US-components/community/KhorosLogo-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/KhorosLogo-1750955844577","value":{"alt":"Powered By Khoros"},"localOverride":false},"Rank:rank:4":{"__typename":"Rank","id":"rank:4","position":3,"name":"Employee","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:769":{"__typename":"User","id":"user:769","uid":769,"login":"ptaylor","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2018-09-11T09:43:15.303-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:4"},"entityType":"USER","eventPath":"community:iaudz84835/user:769"},"ModerationData:moderation_data:17784":{"__typename":"ModerationData","id":"moderation_data:17784","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"AcceptedSolutionMessage:message:17784":{"__typename":"AcceptedSolutionMessage","uid":17784,"id":"message:17784","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17784","revisionNum":1,"author":{"__ref":"User:user:769"},"readOnly":false,"repliesCount":2,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:17776"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17784"},"body":"Hi Wassim,
\nThis is actually a known issue (SWAT-3096) that we’re working on a fix for. It happens when there are at least 1024 records being copied by the Copy snap, for reasons that are a bit difficult to explain.
\nUntil we have a fix, there are at least three workarounds:
\nSorted streams
property to Unsorted
.thank you very much @ptaylor
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2021-09-09T07:06:07.514-07:00","lastPublishTime":"2021-09-09T07:06:07.514-07:00","metrics":{"__typename":"MessageMetrics","views":3436},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"Rank:rank:18":{"__typename":"Rank","id":"rank:18","position":17,"name":"New Contributor III","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:2884":{"__typename":"User","id":"user:2884","uid":2884,"login":"vgautam64","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2022-09-30T04:41:05.391-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-2.svg?time=0"},"rank":{"__ref":"Rank:rank:18"},"entityType":"USER","eventPath":"community:iaudz84835/user:2884"},"ModerationData:moderation_data:17786":{"__typename":"ModerationData","id":"moderation_data:17786","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:17786":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:2884"},"id":"message:17786","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17786","revisionNum":1,"uid":17786,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"AcceptedSolutionMessage:message:17784"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17786"},"body":"I too faced this exact problem recently and this thread proved really helpful. Thanks a lot!
\nConsidering this post is more than 1.5 years old now, what is the status on the fix for this issue?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"196","kudosSumWeight":0,"repliesCount":0,"postTime":"2023-05-31T08:03:53.749-07:00","lastPublishTime":"2023-05-31T08:03:53.749-07:00","metrics":{"__typename":"MessageMetrics","views":794},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"Rank:rank:16":{"__typename":"Rank","id":"rank:16","position":15,"name":"Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:1548":{"__typename":"User","id":"user:1548","uid":1548,"login":"viktor_n","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2020-11-10T08:27:15.624-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:16"},"entityType":"USER","eventPath":"community:iaudz84835/user:1548"},"ModerationData:moderation_data:17777":{"__typename":"ModerationData","id":"moderation_data:17777","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:17777":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1548"},"id":"message:17777","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17777","revisionNum":1,"uid":17777,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:17776"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17777"},"body":"Hi @Wassim,
\nTry first to sort the data before you send it to the join.
\nHow many records did you get before coping the records ?
\nIf it’s only one, then instead of using Join snap try it with Gate snap. You will get same result as it is with Join. If there are more records and you are joining by some conditions then you can not use Gate.
Regards.
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2021-09-07T11:47:42.048-07:00","lastPublishTime":"2021-09-07T11:47:42.048-07:00","metrics":{"__typename":"MessageMetrics","views":4151},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:17778":{"__typename":"ModerationData","id":"moderation_data:17778","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Rank:rank:3":{"__typename":"Rank","id":"rank:3","position":2,"name":"Former Employee","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:56":{"__typename":"User","id":"user:56","uid":56,"login":"skatpally","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2017-02-22T11:12:51.683-08:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-6.svg?time=0"},"rank":{"__ref":"Rank:rank:3"},"entityType":"USER","eventPath":"community:iaudz84835/user:56"},"ForumReplyMessage:message:17778":{"__typename":"ForumReplyMessage","uid":17778,"id":"message:17778","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17778","revisionNum":1,"author":{"__ref":"User:user:1885"},"readOnly":false,"repliesCount":1,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:17776"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17778"},"body":"Hi Viktor,
\nThank you for the answer.
\nI have 6k rows so i cant use the gate.
\nI sorted on the same field i group with and it doesnt help.
\n
Did you mean Join Snap when you referred to Lookup snap here ? Also what is the output from the Aggregate Snap and Mapper after that ?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"136","kudosSumWeight":0,"repliesCount":0,"postTime":"2021-09-07T16:26:21.262-07:00","lastPublishTime":"2021-09-07T16:26:21.262-07:00","metrics":{"__typename":"MessageMetrics","views":4151},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:17780":{"__typename":"ModerationData","id":"moderation_data:17780","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:17780":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1885"},"id":"message:17780","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17780","revisionNum":1,"uid":17780,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:17776"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17780"},"body":"\nHi skatpally thank you very much for the answer. its a lookup snap
\n
Here is the aggregate
\n
and here is the mapper after the aggregate
\n
thank you
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"repliesCount":0,"postTime":"2021-09-08T07:27:57.510-07:00","lastPublishTime":"2021-09-08T07:27:57.510-07:00","metrics":{"__typename":"MessageMetrics","views":4155},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"Rank:rank:14":{"__typename":"Rank","id":"rank:14","position":13,"name":"Valued Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:1049":{"__typename":"User","id":"user:1049","uid":1049,"login":"SpiroTaleski","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2019-04-17T08:14:53.091-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/images/dS0xMDQ5LTEyMjQ1aTU1QTY2MkMyMkVGQ0UwQzU"},"rank":{"__ref":"Rank:rank:14"},"entityType":"USER","eventPath":"community:iaudz84835/user:1049"},"ModerationData:moderation_data:17781":{"__typename":"ModerationData","id":"moderation_data:17781","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:17781":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1049"},"id":"message:17781","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17781","revisionNum":1,"uid":17781,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:17776"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17781"},"body":"\nBelow are some points that you should take about In-Memory Lookup Snap:
\nDid you have another processes that are running in parallel with this process, that are also using similar snaps(join, snaps for aggregation, group snaps etc.) inside, which have an impact of the memory?
\nDid you tried the same scenario using JOIN Snap?
\nRegards,
\nSpiro Taleski
@Spiro_Taleski
\nThank you for the answer.
\ni did try join also.
\ni am aware of all that. i have 6000 rows. to aggregate to join to my first result and its not even moving
\nits like this
\n
if i duplicate my snaps and make the aggregate and the join to the intial snaps it will take less than a minute.
\nRegards
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"203","kudosSumWeight":0,"postTime":"2021-09-08T10:57:00.581-07:00","lastPublishTime":"2021-09-08T10:57:00.581-07:00","metrics":{"__typename":"MessageMetrics","views":3435},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"MessageEdge","cursor":"MjUuNHwyLjF8b3wzfDE0OjAsMzk6MXwx","node":{"__ref":"ForumReplyMessage:message:17783"}}]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"ModerationData:moderation_data:17783":{"__typename":"ModerationData","id":"moderation_data:17783","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:17783":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:1885"},"id":"message:17783","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17783","revisionNum":1,"uid":17783,"depth":2,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumReplyMessage:message:17782"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17783"},"body":"here is a simple example
\ntest copy and join_2021_09_08.slp (14.2 KB)
test - 2021-09-03T152531.018.xlsx (740.4 KB)
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"119","kudosSumWeight":0,"repliesCount":0,"postTime":"2021-09-08T11:20:36.860-07:00","lastPublishTime":"2021-09-08T11:20:36.860-07:00","metrics":{"__typename":"MessageMetrics","views":3435},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"customFields":[],"attachments":{"__typename":"AttachmentConnection","edges":[{"__typename":"AttachmentEdge","cursor":"MjUuNHwyLjF8b3w1fF9OVl98MQ","node":{"__ref":"Attachment:{\"id\":\"attachment:message17783AttachmentNumber1\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/9415/1/test%20copy%20and%20join_2021_09_08.slp\"}"}},{"__typename":"AttachmentEdge","cursor":"MjUuNHwyLjF8b3w1fF9OVl98Mg","node":{"__ref":"Attachment:{\"id\":\"attachment:message17783AttachmentNumber2\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/9415/2/test%20-%202021-09-03T152531.018.xlsx\"}"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}}},"Rank:rank:19":{"__typename":"Rank","id":"rank:19","position":18,"name":"New Contributor II","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:4494":{"__typename":"User","id":"user:4494","uid":4494,"login":"dd_snaplogic","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2023-03-31T04:43:47.958-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://community.snaplogic.com/t5/s/iaudz84835/m_assets/avatars/default/avatar-5.svg?time=0"},"rank":{"__ref":"Rank:rank:19"},"entityType":"USER","eventPath":"community:iaudz84835/user:4494"},"ModerationData:moderation_data:17787":{"__typename":"ModerationData","id":"moderation_data:17787","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:17787":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:4494"},"id":"message:17787","entityType":"FORUM_REPLY","eventPath":"category:platform/category:products/community:iaudz84835board:pipelines/message:17776/message:17787","revisionNum":1,"uid":17787,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:pipelines"},"parent":{"__ref":"ForumTopicMessage:message:17776"},"conversation":{"__ref":"Conversation:conversation:17776"},"subject":"Re: Problem with copy and join","moderationData":{"__ref":"ModerationData:moderation_data:17787"},"body":"Hey I’m also facing the same issue, any updates on the fix?
","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"61","kudosSumWeight":0,"repliesCount":0,"postTime":"2023-06-02T06:20:38.275-07:00","lastPublishTime":"2023-06-02T06:20:38.275-07:00","metrics":{"__typename":"MessageMetrics","views":792},"visibilityScope":"PUBLIC","placeholder":false,"showMoveIndicator":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"QueryVariables:MessageSolutions":{"__typename":"QueryVariables","id":"MessageSolutions","value":{"first":10,"constraints":{"topicId":{"eq":"message:17776"},"solution":{"eq":true}},"sorts":{"postTime":{"direction":"ASC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":false,"useBody":true,"useKudosCount":false,"useTimeToRead":false,"useMedia":true,"useRepliesCount":false,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":true,"useTags":false,"useUserHoverCard":false,"useNodeHoverCard":false,"usePreviewSubjectModal":false,"useMessageStatus":false}},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1750955844577","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1750955844577","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1750955844577","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1750955844577","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1750955844577","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1750955844577","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1750955844577","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1750955844577","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1750955844577","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1750955844577","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolutionList-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolutionList-1750955844577","value":{"emptyDescription":"No has been message solutions yet"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageListMenu-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageListMenu-1750955844577","value":{"postTimeAsc":"Oldest","postTimeDesc":"Newest","kudosSumWeightAsc":"Least Liked","kudosSumWeightDesc":"Most Liked","sortTitle":"Sort By","sortedBy.item":" { itemName, select, postTimeAsc {Oldest} postTimeDesc {Newest} kudosSumWeightAsc {Least Liked} kudosSumWeightDesc {Most Liked} other {}}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1750955844577","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved","topicAlreadySolvedErrorTitle":"Solution Already Exists","topicAlreadySolvedErrorDesc":"Refresh the browser to view the existing solution"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Pager/PagerLoadMore-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Pager/PagerLoadMore-1750955844577","value":{"loadMore":"Show More"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewInline-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewInline-1750955844577","value":{"bylineAuthor":"{bylineAuthor}","bylineBoard":"{bylineBoard}","anonymous":"Anonymous","place":"Place {bylineBoard}","gotoParent":"Go to parent {name}"},"localOverride":false},"Attachment:{\"id\":\"attachment:message17783AttachmentNumber1\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/9415/1/test%20copy%20and%20join_2021_09_08.slp\"}":{"__typename":"Attachment","id":"attachment:message17783AttachmentNumber1","filename":"test copy and join_2021_09_08.slp","filesize":14546,"contentType":"application/octet-stream","url":"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/9415/1/test%20copy%20and%20join_2021_09_08.slp"},"Attachment:{\"id\":\"attachment:message17783AttachmentNumber2\",\"url\":\"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/9415/2/test%20-%202021-09-03T152531.018.xlsx\"}":{"__typename":"Attachment","id":"attachment:message17783AttachmentNumber2","filename":"test - 2021-09-03T152531.018.xlsx","filesize":758169,"contentType":"application/octet-stream","url":"https://community.snaplogic.com/t5/s/iaudz84835/attachments/iaudz84835/pipelines/9415/2/test%20-%202021-09-03T152531.018.xlsx"},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1750955844577","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1750955844577","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/common/ExternalLinkWarningModal-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/common/ExternalLinkWarningModal-1750955844577","value":{"title":"Leaving the Community","description":"You're about to leave this site and navigate to an external domain. Are you sure you want to continue?","action.submit":"Continue","action.cancel":"Go Back"},"localOverride":false},"CachedAsset:text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1750955844577":{"__typename":"CachedAsset","id":"text:en_US-components/attachments/AttachmentView/AttachmentViewChip-1750955844577","value":{"errorTitle":"Failed!","previewFile":"Preview File","downloadFile":"Download File {name}","removeFile":"Remove File {name}","errorBadExtension":"This file does not have a valid extension. \"{extensions}\" are the valid extensions.","errorFileEmpty":"This file is empty or does not exist.","errorTooLarge":"The maximum file size is: {maxFileSize}.","errorTooMany":"Too many attachments. The maximum number of attachments per message is: {maxAttachmentCount, number, integer}.","errorDuplicate":"This file is already attached."},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"pipelines","messageSubject":"problem-with-copy-and-join","messageId":"17776"},"buildId":"8CqYPsxb5UG4aoIp8lqTz","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","surveysEnabled":true,"openTelemetry":{"clientEnabled":false,"configName":"snaplogic","serviceVersion":"25.4.0","universe":"prod","collector":"http://localhost:4318","logLevel":"error","routeChangeAllowedTime":"5000","headers":"","enableDiagnostic":"false","maxAttributeValueLength":"4095"},"apolloDevToolsEnabled":false,"quiltLazyLoadThreshold":"3"},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["components_seo_QAPageSchema","components_community_Navbar_NavbarWidget","components_community_Breadcrumb_BreadcrumbWidget","components_messages_TopicWithThreadedReplyListWidget","components_messages_MessageListForNodeByRecentActivityWidget","components_customComponent_CustomComponent","components_community_FooterWidget","components_messages_MessageView_MessageViewStandard","components_messages_ThreadedReplyList","components_external_components_ExternalComponent","components_community_FooterWidgetHelpLink","components_community_KhorosLogo","components_messages_EscalatedMessageBanner","shared_client_components_common_List_UnstyledList","components_messages_MessageView","shared_client_components_common_Pager_PagerLoadMore","shared_client_components_common_List_ListGroup","components_messages_MessageView_MessageViewInline","components_customComponent_CustomComponentContent_TemplateContent","shared_client_components_common_List_UnwrappedList","components_attachments_AttachmentView","components_attachments_AttachmentView_AttachmentViewChip"],"appGip":true,"scriptLoader":[]}