Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.
Use the Join transformation to combine records from two different inputs. The join component can be used to add information from one data source to another data source or to filter data that exists in both data sources or exists in only one of them. It is important to select join keys (see below) that are unique in at least one of the data inputs to avoid data duplication which may result undesired consequences (e.g. billions of records in output or cluster errors due to disk or memory problems).
Join inputs
Select 2 inputs and drag and drop the component menu button onto the join component:
Within the component you can define which input is the left input and which is the right input.
Join properties
Join type
Inner - returns only those records that have a matching value in the join keys from both the left and right inputs. Note that null values are not considered matching values.
Left - returns the same records as an inner join, as well as records from the left input that have no matches in the join key in the right input. Such records will have null values in the right input fields.
Right - returns the same records as an inner join, as well as records from the right input that have no matches in the join key in the left input. Such records will have null values in the left input fields.
Full - returns all records that would be returned by an inner join (matches on both inputs), records from the left input that have no matches in the right input and records from the right input that have no matches in the left input.
Join optimization
Default - uses Hash join - both inputs are read, tagged by input and are sorted and put into buckets according to the join keys. Then for each key, the records are cross joined by input tags.
Replicated - use when one input is small enough to fit into main memory, thereby improving efficiency. The large relation should be the left input and the small one should be the right input. If the small relation doesn’t fit into main memory, the process fails and an error is generated. Replicated join only works with inner or left joins.
Skewed - use if the underlying key values are very skewed, so that processing isn’t evenly distributed. This will affect performance and may cause the process that deals with most of the data to go out of memory. When Skewed join is used, a histogram is computed on the join key using the left input and this data is used to allocate more reducers for a given key.
Join keys
Inputs are joined on equal key values. Select the key fields that should have equal values in both inputs. Make sure that the key fields are of the same data type. You may need to cast one to the same data type as the other. If multiple key fields are selected, the join component’s output the records that meet all the join conditions (logical “AND”).
If the join’s inputs contain fields with the same names, they will appear in the join output prefixed by the input’s name (e.g. adwords1::customer_id). Use a select component to fix the field aliases or remove fields that contain the same values.
Related
Cross Join Transformation
Union Transformation
Filter Transformation
Last modified on October 5, 2026
Was this page helpful?
{"docsConfig":{"theme":"aspen","$schema":"https://mintlify.com/docs.json","name":"Integrate.io","colors":{"primary":"#4324F4","light":"#9280F9","dark":"#4324F4"},"logo":{"light":"https://mintcdn.com/integrateio/fpWCvrjvoCDC-WOb/logos/light.svg?fit=max\u0026auto=format\u0026n=fpWCvrjvoCDC-WOb\u0026q=85\u0026s=6a23f8a71e1ffa0f0c27c01ddb7c3f63","dark":"https://mintcdn.com/integrateio/fpWCvrjvoCDC-WOb/logos/dark.svg?fit=max\u0026auto=format\u0026n=fpWCvrjvoCDC-WOb\u0026q=85\u0026s=091eda51ce61a9841be4614e905d68e2","href":"https://www.integrate.io"},"favicon":"https://mintcdn.com/integrateio/MGWLTifrhXADDsEf/favicon.ico?fit=max\u0026auto=format\u0026n=MGWLTifrhXADDsEf\u0026q=85\u0026s=03362dc14c0bc7ff0d53c3f858834ee0","appearance":{"default":"dark"},"background":{"color":{"dark":"#130F21"}},"navbar":{"links":[{"href":"https://www.integrate.io/demo/","label":"Get Started"}],"primary":{"type":"button","label":"Sign In","href":"https://dashboard.integrate.io/auth/login"}},"footer":{"socials":{"x":"https://x.com/integrateio","github":"https://github.com/xplenty","linkedin":"https://www.linkedin.com/company/integrateio","facebook":"https://www.facebook.com/integrate.io"}},"seo":{"metatags":{"og:site_name":"Integrate.io Documentation","twitter:site":"@integrateio"},"indexing":"all"},"fonts":{"heading":{"family":"Manrope","weight":700},"body":{"family":"Inter","weight":400}},"integrations":{"ga4":{"measurementId":"G-PKTLZ0S8Y5"}},"contextual":{"options":["copy","view","chatgpt","claude","perplexity","mcp","cursor","vscode"],"display":"header"},"metadata":{"timestamp":true},"styling":{"latex":true},"navigation":{"global":{"anchors":[{"anchor":"Contact Us","icon":"headset","href":"mailto:support@integrate.io"},{"anchor":"Blog","icon":"newspaper","href":"https://www.integrate.io/blog/"}]},"languages":[{"language":"en","default":true,"href":"etl"},{"language":"ko","href":"ko/etl/category/korean-knowledge-base"},{"language":"jp","href":"jp/etl/category/japanese-knowledge-base"}]}},"deployment":{"deploymentMetadataValue":{"subdomain":"integrateio","hasAudioNarration":false,"actualSubdomain":"integrateio","customDomains":["www.integrate.io"],"gitSource":{"type":"github","owner":"xplenty","repo":"integrate-io-docs","deployBranch":"main","contentDirectory":"","isPrivate":true,"mountPath":"","label":""},"feedback":{"thumbs":true},"entitlements":{"AI_CHAT":{"status":"ENABLED"},"REMOVE_BRANDING":{"status":"DISABLED"},"CONTEXTUAL_FEEDBACK":{"status":"DISABLED"},"CODE_SNIPPET_FEEDBACK":{"status":"DISABLED"},"WEB_MCP":{"status":"ENABLED"},"NARRATION":{"status":"ENABLED"}},"buildId":"6af74407b0809f8a84d1a5a1","clientVersion":"0.0.4143","searchFilterCounts":[{"language":"en","tag":"ETL \u0026 Reverse ETL","count":566},{"language":"en","tag":"Knowledge Base","count":564},{"language":"en","tag":"Expressions \u0026 Functions","count":207},{"language":"en","tag":"Functions A to Z","count":192},{"language":"en","tag":"Sources","count":163},{"language":"en","tag":"ELT \u0026 CDC","count":132},{"language":"en","tag":"API Reference","count":115},{"language":"jp","tag":"ETL \u0026 Reverse ETL","count":66},{"language":"jp","tag":"Knowledge Base","count":66},{"language":"ko","tag":"ETL \u0026 Reverse ETL","count":66},{"language":"ko","tag":"Knowledge Base","count":66},{"language":"en","tag":"Destinations","count":47},{"language":"en","tag":"Transformations","count":25},{"language":"en","tag":"Packages \u0026 Workflows","count":24},{"language":"jp","tag":"その他ガイド","count":13},{"language":"ko","tag":"기타 가이드","count":13},{"language":"jp","tag":"入門編ガイド","count":11},{"language":"ko","tag":"초급 가이드","count":11},{"language":"jp","tag":"中級編ガイド","count":10},{"language":"ko","tag":"중급 가이드","count":10},{"language":"jp","tag":"APIガイド","count":9},{"language":"ko","tag":"REST API 가이드","count":9},{"language":"jp","tag":"ストレージガイド","count":7},{"language":"ko","tag":"파일 스토리지 가이드","count":7},{"language":"jp","tag":"Salesforceガイド","count":5},{"language":"ko","tag":"Salesforce 가이드","count":5},{"language":"jp","tag":"データベースガイド","count":4},{"language":"jp","tag":"テンプレートガイド","count":4},{"language":"ko","tag":"데이터베이스 가이드","count":4},{"language":"ko","tag":"템플릿 가이드","count":4}],"searchSettings":{"isFiltersEnabled":false}},"assistantConfig":{"enableAskAiButton":false,"enableStarterQuestions":true,"enableContextualStarterQuestions":true,"enableAskAiSearchBar":true,"deflection":{"enabled":true,"email":"support@integrate.io","showHelpButton":true}},"basePath":"/docs","hasChatPermissions":true,"hasWebMcpPermissions":true,"toggles":[],"googleFontsInlined":true},"customCss":[],"page":{"pagePath":"etl/using-components-join-transformation","slug":"/etl/using-components-join-transformation","pageMetadata":{"title":"ETL: Join Transformation","sidebarTitle":"ETL: Join Transformation","description":"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.","jp_link":"/jp/etl/category/japanese-knowledge-base","ko_link":"/ko/etl/category/korean-knowledge-base","href":"/etl/using-components-join-transformation"},"description":{"compiledSource":"\"use strict\";\nconst {jsx: _jsx} = arguments[0];\nconst {useMDXComponents: _provideComponents} = arguments[0];\nfunction _createMdxContent(props) {\n const _components = {\n p: \"p\",\n ..._provideComponents(),\n ...props.components\n };\n return _jsx(_components.p, {\n children: \"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.\"\n });\n}\nfunction MDXContent(props = {}) {\n const {wrapper: MDXLayout} = {\n ..._provideComponents(),\n ...props.components\n };\n return MDXLayout ? _jsx(MDXLayout, {\n ...props,\n children: _jsx(_createMdxContent, {\n ...props\n })\n }) : _createMdxContent(props);\n}\nreturn {\n default: MDXContent\n};\n","frontmatter":{},"scope":{}},"pageType":"default","mdx":{"mdxSource":{"compiledSource":"\"use strict\";const{Fragment:_Fragment,jsx:_jsx,jsxs:_jsxs}=arguments[0];const{useMDXComponents:_provideComponents}=arguments[0];function _createMdxContent(props){const _components={code:`code`,li:`li`,p:`p`,strong:`strong`,ul:`ul`,..._provideComponents(),...props.components},{Card,CardGroup,Frame,Heading,OptimizedFrame,OptimizedImage}=_components;if(!Card)_missingMdxReference(`Card`,true);if(!CardGroup)_missingMdxReference(`CardGroup`,true);if(!Frame)_missingMdxReference(`Frame`,true);if(!Heading)_missingMdxReference(`Heading`,true);if(!OptimizedFrame)_missingMdxReference(`OptimizedFrame`,true);if(!OptimizedImage)_missingMdxReference(`OptimizedImage`,true);return _jsxs(_Fragment,{children:[_jsx(Frame,{children:_jsx(OptimizedFrame,{src:`https://fast.wistia.com/embed/iframe/gbjesxraav`,allowfullscreen:true,playinline:true,class:`wistia_embed`,width:`640`,height:`360`})}),`\n`,_jsx(_components.p,{children:`Use the Join transformation to combine records from two different inputs. The join component can be used to add information from one data source to another data source or to filter data that exists in both data sources or exists in only one of them. It is important to select join keys (see below) that are unique in at least one of the data inputs to avoid data duplication which may result undesired consequences (e.g. billions of records in output or cluster errors due to disk or memory problems).`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-1.png?fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=bf2bb3c89098f8fe9c634ecdc2e4959f`,alt:`Join component in the pipeline designer`,\"data-og-width\":`1200`,width:`1200`,\"data-og-height\":`828`,height:`828`,\"data-path\":`images/creating-packages/using-components-join-transformation/image-1.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-1.png?w=280\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=0e7261d3efac10e9bc8274eec1ecab13 280w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-1.png?w=560\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=f7588fbe4c3193f30ec254b7056627f4 560w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-1.png?w=840\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=6383f2577e35a192f7d21158151c97d2 840w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-1.png?w=1100\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=9a0313fa5660d74ab1dfd8b46e2e526b 1100w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-1.png?w=1650\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=efc40e0b40c85d81ead42c0660d9ffc5 1650w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-1.png?w=2500\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=69e68deae1fb8d0d6831794bf66c721a 2500w`})}),`\n`,_jsx(Heading,{level:`2`,id:`join-inputs`,children:`Join inputs`}),`\n`,_jsx(_components.p,{children:`Select 2 inputs and drag and drop the component menu button onto the join component:`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-2.png?fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=5bf4115e0730fcdeec82cc7785266718`,alt:`Dragging two inputs onto the Join component`,\"data-og-width\":`396`,width:`396`,\"data-og-height\":`300`,height:`300`,\"data-path\":`images/creating-packages/using-components-join-transformation/image-2.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-2.png?w=280\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=f980378dd9da91c3b66940e682edb587 280w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-2.png?w=560\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=e74e7779bed8a9c35c151e63033a1a8a 560w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-2.png?w=840\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=5d3bd68ddba505a340a03e7294f56169 840w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-2.png?w=1100\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=4f9d12373ba10d3d57d842e06cdde7ce 1100w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-2.png?w=1650\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=dc9a6403d1c49e450b3a9abd74dcbb1a 1650w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-2.png?w=2500\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=c2d4acc1e298435cf82e4638b78f0ab0 2500w`})}),`\n`,_jsx(_components.p,{children:`Within the component you can define which input is the left input and which is the right input.`}),`\n`,_jsx(Heading,{level:`2`,id:`join-properties`,children:`Join properties`}),`\n`,_jsx(Heading,{level:`3`,id:`join-type`,children:`Join type`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-3.png?fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=e8978833b301f02ff61af17ee79412ea`,alt:`Join type dropdown with Inner, Left, Right, and Full options`,\"data-og-width\":`418`,width:`418`,\"data-og-height\":`238`,height:`238`,\"data-path\":`images/creating-packages/using-components-join-transformation/image-3.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-3.png?w=280\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=14afc87a315686b6bc3a420d6f66cffe 280w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-3.png?w=560\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=8333d0803dd2a2ebcf99fd36e227e51f 560w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-3.png?w=840\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=748b9d7d53e9b7674694d9e98ce310d0 840w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-3.png?w=1100\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=470ed76a521d853b078797dbab8d1e54 1100w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-3.png?w=1650\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=c9c3e86bcbd201e6bc292dad152f6655 1650w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-3.png?w=2500\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=5c47cae85cff168ebfc167e674773947 2500w`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Inner`}),` - returns only those records that have a matching value in the join keys from both the left and right inputs. Note that null values are not considered matching values.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Left`}),` - returns the same records as an inner join, as well as records from the left input that have no matches in the join key in the right input. Such records will have null values in the right input fields.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Right`}),` - returns the same records as an inner join, as well as records from the right input that have no matches in the join key in the left input. Such records will have null values in the left input fields.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Full`}),` - returns all records that would be returned by an inner join (matches on both inputs), records from the left input that have no matches in the right input and records from the right input that have no matches in the left input.`]}),`\n`]}),`\n`,_jsx(Heading,{level:`3`,id:`join-optimization`,children:`Join optimization`}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-4.png?fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=e32bb1ae49bde96a2effdf98d3e7907d`,alt:`Join optimization options: Default, Replicated, and Skewed`,\"data-og-width\":`426`,width:`426`,\"data-og-height\":`200`,height:`200`,\"data-path\":`images/creating-packages/using-components-join-transformation/image-4.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-4.png?w=280\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=f3a95576bdb66c56ed987dd4a2e514b6 280w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-4.png?w=560\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=4a2fd104c07e72ef9ac26351a9069848 560w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-4.png?w=840\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=214dc85f11c608621f0e7a28a6a4c271 840w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-4.png?w=1100\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=a90967e2173a26dc2ab077d36b3fbb42 1100w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-4.png?w=1650\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=13a22fc317f16647cc2435b9b188cb6c 1650w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-4.png?w=2500\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=4011066e06920020056ae3a12b71309d 2500w`})}),`\n`,_jsxs(_components.ul,{children:[`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Default`}),` - uses Hash join - both inputs are read, tagged by input and are sorted and put into buckets according to the join keys. Then for each key, the records are cross joined by input tags.`]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Replicated`}),` - use when one input is small enough to fit into main memory, thereby improving efficiency. The large relation should be the left input and the small one should be the right input. If the small relation doesn’t fit into main memory, the process fails and an error is generated. `,_jsx(_components.strong,{children:`Replicated join only works with inner or left joins.`})]}),`\n`,_jsxs(_components.li,{children:[_jsx(_components.strong,{children:`Skewed`}),` - use if the underlying key values are very skewed, so that processing isn’t evenly distributed. This will affect performance and may cause the process that deals with most of the data to go out of memory. When Skewed join is used, a histogram is computed on the join key using the left input and this data is used to allocate more reducers for a given key.`]}),`\n`]}),`\n`,_jsx(Heading,{level:`2`,id:`join-keys`,children:`Join keys`}),`\n`,_jsxs(_components.p,{children:[`Inputs are joined on equal key values. Select the key fields that should have equal values in both inputs. Make sure that `,_jsx(_components.strong,{children:`the key fields are of the same data type`}),`. You may need to cast one to the same data type as the other. If multiple key fields are selected, the join component’s output the records that meet all the join conditions (logical “AND”).`]}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-5.png?fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=cd38e8d3f0d8d66dfcb858c7b774860a`,alt:`Selecting join key fields from left and right inputs`,\"data-og-width\":`1200`,width:`1200`,\"data-og-height\":`828`,height:`828`,\"data-path\":`images/creating-packages/using-components-join-transformation/image-5.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-5.png?w=280\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=cc42c0dad94761124ed51ed5a15d6de1 280w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-5.png?w=560\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=5e00c4c1dea3dac1e61660b0535d2977 560w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-5.png?w=840\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=385acfb11d995c9e392b3087ce39a1ba 840w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-5.png?w=1100\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=b326f16ab60dbd9e1efe035f6691a625 1100w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-5.png?w=1650\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=49ca7d6b139f7fdf94335cd7376fbaf9 1650w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-5.png?w=2500\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=526ee2eaaf28bcfc7948d81eae70881a 2500w`})}),`\n`,_jsxs(_components.p,{children:[`If the join’s inputs contain fields with the same names, they will appear in the join output prefixed by the input’s name (e.g. `,_jsx(_components.code,{children:`adwords1::customer_id`}),`). Use a select component to fix the field aliases or remove fields that contain the same values.`]}),`\n`,_jsx(Frame,{children:_jsx(OptimizedImage,{src:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-6.png?fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=d6bace88502bb98a5b52a850640ff22d`,alt:`Output fields prefixed with input names to resolve duplicates`,\"data-og-width\":`1200`,width:`1200`,\"data-og-height\":`828`,height:`828`,\"data-path\":`images/creating-packages/using-components-join-transformation/image-6.png`,\"data-optimize\":`true`,\"data-opv\":`3`,srcset:`https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-6.png?w=280\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=bdb0fd9fc6e1ca911e8720e3b8f9aeed 280w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-6.png?w=560\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=0290c68489811fbac3f61da8be640ea2 560w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-6.png?w=840\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=fcb88cfdc2ed43a1d8ed63211d3fb989 840w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-6.png?w=1100\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=c1cbfcc3c51829e7ec48fe16a4d3ce19 1100w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-6.png?w=1650\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=7d0c6d6bbecbd36aad0d179c39126074 1650w, https://mintcdn.com/integrateio/OwEKdS5aIKsEcmhX/images/creating-packages/using-components-join-transformation/image-6.png?w=2500\u0026fit=max\u0026auto=format\u0026n=OwEKdS5aIKsEcmhX\u0026q=85\u0026s=b8466fe36f540402b12c088aa6a9c170 2500w`})}),`\n`,_jsx(Heading,{level:`2`,id:`related`,children:`Related`}),`\n`,_jsxs(CardGroup,{cols:2,children:[_jsx(Card,{title:`Cross Join Transformation`,icon:`arrow-right`,href:`/etl/using-components-cross-join-transformation`,horizontal:true}),_jsx(Card,{title:`Union Transformation`,icon:`arrow-right`,href:`/etl/using-components-union-transformation`,horizontal:true}),_jsx(Card,{title:`Filter Transformation`,icon:`arrow-right`,href:`/etl/using-components-filter-transformation`,horizontal:true})]})]})}function MDXContent(props={}){const{wrapper:MDXLayout}={..._provideComponents(),...props.components};return MDXLayout?_jsx(MDXLayout,{...props,children:_jsx(_createMdxContent,{...props})}):_createMdxContent(props)}return{default:MDXContent};function _missingMdxReference(id,component){throw new Error(`Expected `+(component?`component`:`object`)+\" `\"+id+\"` to be defined: you likely forgot to import, pass, or provide it.\")}","frontmatter":{},"scope":{"config":{},"pageMetadata":{"title":"ETL: Join Transformation","sidebarTitle":"ETL: Join Transformation","description":"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.","jp_link":"/jp/etl/category/japanese-knowledge-base","ko_link":"/ko/etl/category/korean-knowledge-base","href":"/etl/using-components-join-transformation"}}},"mdxSourceWithNoJs":null},"mdxExtracts":{"tableOfContents":[{"title":"Join inputs","slug":"join-inputs","depth":2,"children":[]},{"title":"Join properties","slug":"join-properties","depth":2,"children":[{"title":"Join type","slug":"join-type","depth":3,"children":[]},{"title":"Join optimization","slug":"join-optimization","depth":3,"children":[]}]},{"title":"Join keys","slug":"join-keys","depth":2,"children":[]},{"title":"Related","slug":"related","depth":2,"children":[]}],"codeExamples":{}},"jsLinks":["/docs/_mintlify/custom/integrateio/ee07775a8a76a2d8/structured-data.js"],"subdomain":"integrateio","siteName":"Integrate.io","title":"ETL: Join Transformation - Integrate.io","contextualStarterQuestions":[{"_id":"6a16243f0b8f4e5d1026c3b6","deploymentId":"6993e05a49fd188f36451435","questionText":"How do I avoid data duplication?","status":"active","generatedBy":"contextual","path":"etl/using-components-join-transformation","createdAt":"2026-05-26T22:52:47.827Z","updatedAt":"2026-05-26T22:52:47.827Z","__v":0},{"_id":"6a16243f0b8f4e5d1026c3b7","deploymentId":"6993e05a49fd188f36451435","questionText":"How do I set up join keys?","status":"active","generatedBy":"contextual","path":"etl/using-components-join-transformation","createdAt":"2026-05-26T22:52:47.827Z","updatedAt":"2026-05-26T22:52:47.827Z","__v":0},{"_id":"6a16243f0b8f4e5d1026c3b5","deploymentId":"6993e05a49fd188f36451435","questionText":"What join types does this support?","status":"active","generatedBy":"contextual","path":"etl/using-components-join-transformation","createdAt":"2026-05-26T22:52:47.827Z","updatedAt":"2026-05-26T22:52:47.827Z","__v":0}],"navMaps":{"firstHrefInVersion":{},"firstHrefInLanguage":{"en":{"href":"/etl/using-components-join-transformation","matchLevel":0},"ko":{"href":"/ko/etl/category/korean-knowledge-base","matchLevel":4},"jp":{"href":"/jp/etl/category/japanese-knowledge-base","matchLevel":4}}},"lastModified":"2026-05-25T03:22:00.320Z","gitLastModified":"2026-10-05T07:09:24.000Z","originalFileLocation":"etl/using-components-join-transformation.mdx","locale":"en"},"headHtml":"\u003cscript data-mint-head>(function(){var d=document.documentElement,p=null;if(!p){try{p=localStorage.getItem(\"isDarkMode\")}catch(e){}if(p==='true')p='dark';else if(p==='false')p='light';if(p!=='light'\u0026\u0026p!=='dark'\u0026\u0026p!=='system')p=\"dark\"}var r=p==='system'?(matchMedia(\"(prefers-color-scheme: dark)\").matches?'dark':'light'):p;d.classList.remove(r==='dark'?'light':'dark');d.classList.add(r);d.setAttribute(\"data-theme-preference\",p)})();\u003c/script>\u003cmeta data-mint-head name=\"description\" content=\"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.\">\u003cmeta data-mint-head name=\"application-name\" content=\"Integrate.io\">\u003cmeta data-mint-head name=\"generator\" content=\"Mintlify\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon/android-chrome-192x192.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"apple-touch-icon\" type=\"image/png\" sizes=\"180x180\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon/apple-touch-icon.png\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon/favicon-16x16.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon/favicon-32x32.png\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon/favicon.ico\" media=\"(prefers-color-scheme: light)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"192x192\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon-dark/android-chrome-192x192.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"16x16\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon-dark/favicon-16x16.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"icon\" type=\"image/png\" sizes=\"32x32\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon-dark/favicon-32x32.png\" media=\"(prefers-color-scheme: dark)\">\u003clink data-mint-head rel=\"shortcut icon\" type=\"image/x-icon\" href=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon-dark/favicon.ico\" media=\"(prefers-color-scheme: dark)\">\u003cmeta data-mint-head property=\"og:title\" content=\"ETL: Join Transformation - Integrate.io\">\u003cmeta data-mint-head property=\"og:description\" content=\"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.\">\u003cmeta data-mint-head property=\"og:site_name\" content=\"Integrate.io Documentation\">\u003cmeta data-mint-head property=\"og:url\" content=\"https://www.integrate.io/docs/etl/using-components-join-transformation\">\u003cmeta data-mint-head property=\"og:type\" content=\"website\">\u003cmeta data-mint-head property=\"og:image\" content=\"https://integrateio.mintlify.site/docs/_mintlify/api/og/v2?division=Transformations\u0026amp;title=ETL%3A+Join+Transformation\u0026amp;description=Use+the+Join+transformation+to+combine+records+from+two+inputs+based+on+matching+key+fields.+Supports+inner%2C+left%2C+right%2C+and+full+outer+joins.\u0026amp;theme=c665eb0793984e38cca55537\u0026amp;signature=d4913a462fced4789d7b293d2c1f123038e101c0bea22d03881de65375f15be9\">\u003cmeta data-mint-head property=\"og:image:width\" content=\"1200\">\u003cmeta data-mint-head property=\"og:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"twitter:card\" content=\"summary_large_image\">\u003cmeta data-mint-head name=\"twitter:title\" content=\"ETL: Join Transformation - Integrate.io\">\u003cmeta data-mint-head name=\"twitter:description\" content=\"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.\">\u003cmeta data-mint-head name=\"twitter:image\" content=\"https://integrateio.mintlify.site/docs/_mintlify/api/og/v2?division=Transformations\u0026amp;title=ETL%3A+Join+Transformation\u0026amp;description=Use+the+Join+transformation+to+combine+records+from+two+inputs+based+on+matching+key+fields.+Supports+inner%2C+left%2C+right%2C+and+full+outer+joins.\u0026amp;theme=c665eb0793984e38cca55537\u0026amp;signature=d4913a462fced4789d7b293d2c1f123038e101c0bea22d03881de65375f15be9\">\u003cmeta data-mint-head name=\"twitter:image:width\" content=\"1200\">\u003cmeta data-mint-head name=\"twitter:image:height\" content=\"630\">\u003cmeta data-mint-head name=\"msapplication-config\" content=\"/docs/mintlify-assets/_mintlify/favicons/integrateio/aKp_gZA-xHF0z4no/_generated/favicon/browserconfig.xml\">\u003cmeta data-mint-head name=\"apple-mobile-web-app-title\" content=\"Integrate.io\">\u003cmeta data-mint-head name=\"msapplication-TileColor\" content=\"#4324F4\">\u003clink data-mint-head rel=\"canonical\" href=\"https://www.integrate.io/docs/etl/using-components-join-transformation\">\u003clink data-mint-head rel=\"alternate\" type=\"application/xml\" href=\"/docs/sitemap.xml\">\u003clink data-mint-head rel=\"alternate\" type=\"text/markdown\" href=\"/docs/etl/using-components-join-transformation.md\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"en\" href=\"https://www.integrate.io/docs/etl/using-components-join-transformation\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ko\" href=\"https://www.integrate.io/docs/ko/etl/category/korean-knowledge-base\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"ja\" href=\"https://www.integrate.io/docs/jp/etl/category/japanese-knowledge-base\">\u003clink data-mint-head rel=\"alternate\" hreflang=\"x-default\" href=\"https://www.integrate.io/docs/etl/using-components-join-transformation\">\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https://www.integrate.io/#organization\",\"name\":\"Integrate.io\",\"url\":\"https://www.integrate.io\",\"logo\":{\"@type\":\"ImageObject\",\"url\":\"https://mintcdn.com/integrateio/fpWCvrjvoCDC-WOb/logos/light.svg?fit=max\u0026auto=format\u0026n=fpWCvrjvoCDC-WOb\u0026q=85\u0026s=6a23f8a71e1ffa0f0c27c01ddb7c3f63\"}},{\"@type\":\"WebSite\",\"@id\":\"https://www.integrate.io/docs#website\",\"name\":\"Integrate.io\",\"url\":\"https://www.integrate.io/docs\",\"publisher\":{\"@id\":\"https://www.integrate.io/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https://www.integrate.io/docs/etl/using-components-join-transformation#webpage\",\"url\":\"https://www.integrate.io/docs/etl/using-components-join-transformation\",\"name\":\"ETL: Join Transformation\",\"description\":\"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.\",\"dateModified\":\"2026-10-05T07:09:24.000Z\",\"isPartOf\":{\"@id\":\"https://www.integrate.io/docs#website\"},\"breadcrumb\":{\"@id\":\"https://www.integrate.io/docs/etl/using-components-join-transformation#breadcrumb\"}},{\"@type\":\"BreadcrumbList\",\"@id\":\"https://www.integrate.io/docs/etl/using-components-join-transformation#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Transformations\",\"item\":\"https://www.integrate.io/docs/etl/category/transformations\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ETL: Join Transformation\",\"item\":\"https://www.integrate.io/docs/etl/using-components-join-transformation\"}]},{\"@type\":[\"Article\",\"TechArticle\"],\"@id\":\"https://www.integrate.io/docs/etl/using-components-join-transformation#article\",\"headline\":\"ETL: Join Transformation\",\"name\":\"ETL: Join Transformation\",\"description\":\"Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.\",\"url\":\"https://www.integrate.io/docs/etl/using-components-join-transformation\",\"mainEntityOfPage\":{\"@id\":\"https://www.integrate.io/docs/etl/using-components-join-transformation#webpage\"},\"dateModified\":\"2026-10-05T07:09:24.000Z\",\"publisher\":{\"@id\":\"https://www.integrate.io/#organization\"},\"isPartOf\":{\"@id\":\"https://www.integrate.io/docs#website\"}}]}\u003c/script>\u003cscript data-mint-head type=\"application/ld+json\">{\"@context\":\"https://schema.org\",\"@type\":\"WebSite\",\"name\":\"Integrate.io\",\"publisher\":{\"@type\":\"Organization\",\"name\":\"Integrate.io\"},\"provider\":{\"@type\":\"Organization\",\"name\":\"Mintlify\",\"url\":\"https://mintlify.com\"}}\u003c/script>","agentPointerHref":"/docs/etl/using-components-join-transformation.md","siteName":"Integrate.io","nav":{"global":{"anchors":[{"anchor":"Contact Us","icon":"headset","href":"mailto:support@integrate.io"},{"anchor":"Blog","icon":"newspaper","href":"https://www.integrate.io/blog/"}]},"languages":[{"language":"en","default":true,"products":[{"product":"ETL \u0026 Reverse ETL","tabs":[{"tab":"Home","icon":"house","pages":[{"title":"Home","href":"/etl"}]},{"tab":"Knowledge Base","icon":"book-open","groups":[{"group":"Getting Started","icon":"gear","pages":[{"title":"ETL: Getting Started Guides Overview","sidebarTitle":"ETL: Getting Started Overview","href":"/etl/category/getting-started"},{"title":"ETL: Getting Started","sidebarTitle":"ETL: Getting Started","href":"/etl/getting-started"},{"title":"ETL: ETL Terminology","sidebarTitle":"ETL: ETL Terminology","href":"/etl/integrateio-etl-terminology"},{"title":"ETL: Defining Connections","sidebarTitle":"ETL: Defining Connections","href":"/etl/defining-connections"},{"title":"ETL: Organize Connections with Connection Groups","sidebarTitle":"ETL: Connection Groups","href":"/etl/connection-groups"},{"title":"ETL: Packages Overview","sidebarTitle":"ETL: Packages Overview","href":"/etl/integrateio-etls-packages"},{"title":"ETL: Package Groups","sidebarTitle":"ETL: Package Groups","href":"/etl/package-groups"},{"title":"ETL: Clusters Overview","sidebarTitle":"ETL: Clusters Overview","href":"/etl/integrateio-etls-clusters"},{"title":"ETL: Ask Helm","sidebarTitle":"ETL: Ask Helm","href":"/etl/integrateio-ai-assistant"},{"title":"ETL: Best Practices Guide","sidebarTitle":"ETL: Best Practices Guide","href":"/etl/integrateio-best-practices-guide"}]},{"group":"Packages \u0026 Workflows","icon":"folder-gear","pages":[{"title":"ETL: Packages \u0026 Workflows","sidebarTitle":"ETL: Packages \u0026 Workflows Overview","href":"/etl/category/packages-and-workflows"},{"title":"ETL: Creating a New Package","sidebarTitle":"ETL: Creating a New Package","href":"/etl/creating-a-new-package-in-integrateio-etl"},{"title":"ETL: Creating a Workflow","sidebarTitle":"ETL: Creating a Workflow","href":"/etl/creating-a-workflow"},{"title":"ETL: Package Designer","sidebarTitle":"ETL: Package Designer","href":"/etl/working-in-the-new-package-designer"},{"title":"ETL: Creating a Package from a Template","sidebarTitle":"ETL: Creating a Package from a Template","href":"/etl/create-a-package-from-a-template"},{"title":"ETL: Package Creation Guide","sidebarTitle":"ETL: Package Creation Guide","href":"/etl/creating-a-new-package"},{"title":"ETL: Creating a Delivery","sidebarTitle":"ETL: Creating a Delivery","href":"/etl/how-to-create-a-delivery"},{"title":"ETL: Import or Export Package JSON","sidebarTitle":"ETL: Import or Export Package JSON","href":"/etl/how-do-i-import-or-export-a-packages-json-source-code"},{"title":"ETL: Package Version Control","sidebarTitle":"ETL: Package Version Control","href":"/etl/how-do-i-use-package-version-control"},{"title":"ETL: GitHub Integration","sidebarTitle":"ETL: GitHub Integration","href":"/etl/github-integration"},{"title":"ETL: Promoting Packages with GitHub","sidebarTitle":"ETL: Promoting Packages with GitHub","href":"/etl/promoting-packages-with-github"},{"title":"ETL: Package Drafts","sidebarTitle":"ETL: Package Drafts","href":"/etl/package-drafts"},{"title":"ETL: Component Previewer","sidebarTitle":"ETL: Component Previewer","href":"/etl/component-previewer"},{"title":"ETL: Propagating Field Changes to Downstream Components","sidebarTitle":"ETL: Propagating Field Changes","href":"/etl/propagating-field-changes-to-downstream-components"},{"title":"ETL: Dynamic Connections","sidebarTitle":"ETL: Dynamic Connections","href":"/etl/dynamic-connections"},{"title":"ETL: Defining Output Schemas","sidebarTitle":"ETL: Schemas","href":"/etl/defining-output-schemas"},{"title":"ETL: Advanced Search","sidebarTitle":"ETL: Advanced Search","href":"/etl/advanced-search"},{"title":"ETL: Validating a Package","sidebarTitle":"ETL: Validating a Package","href":"/etl/validating-a-package"},{"title":"ETL: Webhook Integrations","sidebarTitle":"ETL: Webhook Integrations","href":"/etl/webhook-integrations"},{"title":"ETL: Execute SQL","sidebarTitle":"ETL: Execute SQL","href":"/etl/using-components-execute-sql-workflow"},{"title":"ETL: File Mover","sidebarTitle":"ETL: File Mover","href":"/etl/using-components-file-mover-workflow"},{"title":"ETL: Run Package","sidebarTitle":"ETL: Run Package","href":"/etl/using-components-run-package-workflow"},{"title":"ETL: Run Workflow","sidebarTitle":"ETL: Run Workflow","href":"/etl/using-components-run-workflow"},{"title":"ETL: PDF to CSV","sidebarTitle":"ETL: PDF to CSV","href":"/etl/using-components-pdf-to-csv-workflow"}]},{"group":"Sources","icon":"server","pages":[{"title":"ETL: Sources","sidebarTitle":"ETL: Sources Overview","href":"/etl/category/sources"},{"title":"ETL: Connecting to Amazon Athena","sidebarTitle":"ETL: Amazon Athena","href":"/etl/allowing-integrateio-etl-access-to-my-amazon-athena-instance"},{"title":"ETL: Connecting to Amazon RDS","sidebarTitle":"ETL: Amazon RDS","href":"/etl/allowing-integrateio-direct-access-to-relational-databases-on-amazon-web-services-rds"},{"title":"ETL: Amazon Redshift Source","sidebarTitle":"ETL: Amazon Redshift","href":"/etl/using-components-amazon-redshift-source"},{"title":"ETL: Amazon S3 Source","sidebarTitle":"ETL: Amazon S3","href":"/etl/using-components-amazon-s3-source"},{"title":"ETL: Connecting to AWS Transfer Family","sidebarTitle":"ETL: AWS Transfer Family","href":"/etl/connecting-aws-transfer-family"},{"title":"ETL: Azure Blob Storage Source","sidebarTitle":"ETL: Azure Blob Storage","href":"/etl/using-components-azure-blob-storage-source"},{"title":"ETL: Bing Ads Source","sidebarTitle":"ETL: Bing Ads","href":"/etl/using-components-bing-ads-source"},{"title":"ETL: Crisp Chat Source","sidebarTitle":"ETL: Crisp Chat","href":"/etl/using-components-crisp-chat-source"},{"title":"ETL: Database Source","sidebarTitle":"ETL: Database","href":"/etl/using-components-database-source"},{"title":"ETL: Connecting to DB2","sidebarTitle":"ETL: DB2","href":"/etl/allowing-integrateio-etl-access-to-db2-databases"},{"title":"ETL: Dummy Source","sidebarTitle":"ETL: Dummy Source","href":"/etl/using-components-dummy-source"},{"title":"ETL: Connecting to Dynamics 365","sidebarTitle":"ETL: Dynamics 365","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-dynamics-365"},{"title":"ETL: EDI (X12) Source","sidebarTitle":"ETL: EDI (X12)","href":"/etl/using-components-edi-x12-source"},{"title":"ETL: Facebook Ads Insights Source","sidebarTitle":"ETL: Facebook Ads Insights","href":"/etl/using-components-facebook-ads-insights-source"},{"title":"ETL: File Storage Source","sidebarTitle":"ETL: File Storage","href":"/etl/using-components-file-storage-source"},{"title":"ETL: FTPS Source","sidebarTitle":"ETL: FTPS","href":"/etl/using-components-ftps-source"},{"title":"ETL: Fundraise Up","sidebarTitle":"Fundraise Up","href":"/etl/using-components-fundraise-up-source"},{"title":"ETL: Gmail Source","sidebarTitle":"ETL: Gmail","href":"/etl/using-components-google-mail-gmail-source"},{"title":"ETL: Google Ads Source","sidebarTitle":"ETL: Google Ads","href":"/etl/using-components-google-ads-source"},{"title":"ETL: Google Analytics Source","sidebarTitle":"ETL: Google Analytics","href":"/etl/using-components-google-analytics-source"},{"title":"ETL: Google Analytics 4 (GA4) Source","sidebarTitle":"ETL: Google Analytics 4 (GA4)","href":"/etl/using-components-google-analytics-4-ga4-source"},{"title":"ETL: Google BigQuery Source","sidebarTitle":"ETL: Google BigQuery","href":"/etl/using-components-google-bigquery-source"},{"title":"ETL: Google Cloud Spanner Source","sidebarTitle":"ETL: Google Cloud Spanner","href":"/etl/using-components-google-cloud-spanner-source"},{"title":"ETL: Connecting to Google Cloud SQL for MySQL","sidebarTitle":"ETL: Google Cloud SQL for MySQL","href":"/etl/allowing-integrateio-etl-access-to-google-cloud-sql-for-mysql-databases"},{"title":"ETL: Connecting to Google Cloud SQL for PostgreSQL","sidebarTitle":"ETL: Google Cloud SQL for PostgreSQL","href":"/etl/allowing-integrateio-etl-access-to-google-cloud-sql-for-postgresql-databases"},{"title":"ETL: Google Cloud Storage Source","sidebarTitle":"ETL: Google Cloud Storage","href":"/etl/using-components-google-cloud-storage-source"},{"title":"ETL: Connecting to Google Drive","sidebarTitle":"ETL: Google Drive","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-google-drive"},{"title":"ETL: Google Sheets Source","sidebarTitle":"ETL: Google Sheets","href":"/etl/using-components-google-sheets-source"},{"title":"ETL: HDFS Source","sidebarTitle":"ETL: HDFS","href":"/etl/using-components-hdfs-source"},{"title":"ETL: Connecting to Heroku Postgres","sidebarTitle":"ETL: Heroku Postgres","href":"/etl/allowing-integrateio-etl-access-to-heroku-postgres-databases"},{"title":"ETL: HubSpot Source","sidebarTitle":"ETL: HubSpot","href":"/etl/using-components-hubspot-source"},{"title":"ETL: Connecting to HubSpot","sidebarTitle":"ETL: HubSpot","href":"/etl/allowing-integrateio-etl-access-to-hubspot"},{"title":"ETL: Connecting to HubSpot (Service Token)","sidebarTitle":"ETL: HubSpot (Service Token)","href":"/etl/allowing-integrateio-etl-access-to-hubspot-service-token"},{"title":"ETL: Connecting to IBM i (AS/400)","sidebarTitle":"ETL: IBM i (AS/400)","href":"/etl/allowing-integrateio-etl-access-to-ibm-i-as400"},{"title":"ETL: Connecting to Instagram","sidebarTitle":"ETL: Instagram","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-instagram"},{"title":"ETL: Connecting to Intercom","sidebarTitle":"ETL: Intercom","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-intercom"},{"title":"ETL: Connecting to LinkedIn","sidebarTitle":"ETL: LinkedIn","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-linkedin"},{"title":"ETL: Connecting to Marketing Cloud (REST)","sidebarTitle":"ETL: Marketing Cloud (REST)","href":"/etl/allowing-integrateio-etl-access-to-my-marketing-cloud-rest"},{"title":"ETL: Connecting to Marketing Cloud (SOAP)","sidebarTitle":"ETL: Marketing Cloud (SOAP)","href":"/etl/allowing-integrateio-etl-access-to-my-marketing-cloud-soap"},{"title":"ETL: Connecting to Microsoft SQL Server","sidebarTitle":"ETL: Microsoft SQL Server","href":"/etl/allowing-integrateio-etl-access-to-microsoft-sql-server-databases"},{"title":"ETL: MongoDB Source","sidebarTitle":"ETL: MongoDB","href":"/etl/using-components-mongodb-source"},{"title":"ETL: Mouseflow Source","sidebarTitle":"ETL: Mouseflow","href":"/etl/using-components-mouseflow-source"},{"title":"ETL: Connecting to MySQL","sidebarTitle":"ETL: MySQL","href":"/etl/allowing-integrateio-etl-access-to-mysql-databases"},{"title":"ETL: NetSuite Source","sidebarTitle":"ETL: NetSuite","href":"/etl/using-components-netsuite-source"},{"title":"ETL: Ometria Source","sidebarTitle":"ETL: Ometria","href":"/etl/using-components-ometria-source"},{"title":"ETL: OneTouch Health Source","sidebarTitle":"ETL: OneTouch Health","href":"/etl/using-components-onetouch-health-source"},{"title":"ETL: Outlook Source","sidebarTitle":"ETL: Outlook","href":"/etl/using-components-outlook-source"},{"title":"ETL: Connecting to Oracle","sidebarTitle":"ETL: Oracle","href":"/etl/allowing-integrateio-etl-access-to-oracle-databases"},{"title":"ETL: Oracle Fusion","sidebarTitle":"ETL: Oracle Fusion","href":"/etl/using-components-oracle-fusion-source"},{"title":"ETL: Pipedrive Source","sidebarTitle":"ETL: Pipedrive","href":"/etl/using-components-pipedrive-source"},{"title":"ETL: Connecting to PostgreSQL","sidebarTitle":"ETL: PostgreSQL","href":"/etl/allowing-integrateio-etl-access-to-postgresql-databases"},{"title":"ETL: REST API Source","sidebarTitle":"ETL: REST API","href":"/etl/using-components-rest-api-source"},{"title":"ETL: Salesforce Source","sidebarTitle":"ETL: Salesforce","href":"/etl/using-components-salesforce-source"},{"title":"ETL: Connecting to SAP HANA","sidebarTitle":"ETL: SAP HANA","href":"/etl/allowing-integrateio-etl-access-to-sap-hana-databases"},{"title":"ETL: SFTP Source","sidebarTitle":"ETL: SFTP","href":"/etl/using-components-sftp-source"},{"title":"ETL: Connecting to SFTPToGo","sidebarTitle":"ETL: SFTPToGo","href":"/etl/allowing-access-to-my-file-data-on-sftptogo"},{"title":"ETL: SharePoint Source","sidebarTitle":"ETL: SharePoint","href":"/etl/using-components-sharepoint-source"},{"title":"ETL: Connecting to Shopify","sidebarTitle":"ETL: Shopify","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-shopify"},{"title":"ETL: Snowflake Source","sidebarTitle":"ETL: Snowflake","href":"/etl/using-components-snowflake-source"},{"title":"ETL: Square","sidebarTitle":"Square","href":"/etl/using-components-square-source"},{"title":"ETL: SugarCRM Source","sidebarTitle":"ETL: SugarCRM","href":"/etl/using-components-sugarcrm-source"},{"title":"ETL: Connecting to TikTok Ads","sidebarTitle":"ETL: TikTok Ads","href":"/etl/allowing-integrateio-etl-access-to-tiktok-ads-data"},{"title":"ETL: Trustpilot Source","sidebarTitle":"ETL: Trustpilot","href":"/etl/using-components-trustpilot-source"},{"title":"ETL: Connecting via Universal OAuth","sidebarTitle":"ETL: Universal OAuth","href":"/etl/allowing-integrateio-etl-access-to-any-api-with-oauth"},{"title":"ETL: Windows File Share Source","sidebarTitle":"ETL: Windows File Share","href":"/etl/connecting-to-windows-file-share-source"},{"title":"ETL: Connecting to Xero","sidebarTitle":"ETL: Xero","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-xero"},{"title":"ETL: Connecting to YouTube","sidebarTitle":"ETL: YouTube","href":"/etl/allowing-integrateio-etl-access-to-my-data-on-youtube"},{"title":"ETL: Zendesk Source","sidebarTitle":"ETL: Zendesk","href":"/etl/using-components-zendesk-source"},{"group":"Snapshot CDC Sources","expanded":false,"pages":[{"title":"ETL: Snapshot CDC Source","sidebarTitle":"ETL: Overview","href":"/etl/using-components-cdc-database-source"},{"title":"ETL: MySQL Snapshot CDC Source","sidebarTitle":"ETL: MySQL (CDC)","href":"/etl/using-components-mysql-cdc-source"},{"title":"ETL: PostgreSQL Snapshot CDC Source","sidebarTitle":"ETL: PostgreSQL (CDC)","href":"/etl/using-components-postgresql-cdc-source"},{"title":"ETL: SQL Server Snapshot CDC Source","sidebarTitle":"ETL: SQL Server (CDC)","href":"/etl/using-components-sql-server-cdc-source"},{"title":"ETL: Oracle Snapshot CDC Source","sidebarTitle":"ETL: Oracle (CDC)","href":"/etl/using-components-oracle-cdc-source"},{"title":"ETL: Oracle ADW Snapshot CDC Source","sidebarTitle":"ETL: Oracle ADW (CDC)","href":"/etl/using-components-oracle-adw-cdc-source"},{"title":"ETL: Amazon Redshift Snapshot CDC Source","sidebarTitle":"ETL: Amazon Redshift (CDC)","href":"/etl/using-components-amazon-redshift-cdc-source"},{"title":"ETL: Snowflake Snapshot CDC Source","sidebarTitle":"ETL: Snowflake (CDC)","href":"/etl/using-components-snowflake-cdc-source"},{"title":"ETL: Google Cloud SQL Snapshot CDC Source","sidebarTitle":"ETL: Google Cloud SQL (CDC)","href":"/etl/using-components-google-cloud-sql-cdc-source"},{"title":"ETL: Google Cloud Postgres Snapshot CDC Source","sidebarTitle":"ETL: Google Cloud Postgres (CDC)","href":"/etl/using-components-google-cloud-postgres-cdc-source"},{"title":"ETL: Heroku Postgres Snapshot CDC Source","sidebarTitle":"ETL: Heroku Postgres (CDC)","href":"/etl/using-components-heroku-postgres-cdc-source"},{"title":"ETL: AlloyDB Snapshot CDC Source","sidebarTitle":"ETL: AlloyDB (CDC)","href":"/etl/using-components-alloy-cdc-source"},{"title":"ETL: Vertica Snapshot CDC Source","sidebarTitle":"ETL: Vertica (CDC)","href":"/etl/using-components-vertica-cdc-source"},{"title":"ETL: Azure Synapse Analytics Snapshot CDC Source","sidebarTitle":"ETL: Azure Synapse Analytics (CDC)","href":"/etl/using-components-azure-synapse-analytics-cdc-source"},{"title":"ETL: IBM DB2 Snapshot CDC Source","sidebarTitle":"ETL: IBM DB2 (CDC)","href":"/etl/using-components-ibm-db2-cdc-source"},{"title":"ETL: SAP HANA Snapshot CDC Source","sidebarTitle":"ETL: SAP HANA (CDC)","href":"/etl/using-components-sap-hana-cdc-source"}]},{"group":"Tutorials \u0026 Reference","expanded":false,"pages":[{"title":"ETL: API Ingestion Guide","sidebarTitle":"ETL: API Ingestion Guide","href":"/etl/api-ingestion-guide-with-integrateio"},{"title":"ETL: Ingesting a Postman API Call","sidebarTitle":"ETL: Ingesting a Postman API Call","href":"/etl/ingesting-a-working-postman-api-call-with-integrateios-api-connector"},{"title":"ETL: Moving Data Incrementally Between Databases","sidebarTitle":"ETL: Moving Data Incrementally Between Databases","href":"/etl/how-do-i-move-data-incrementally-between-databases"},{"title":"ETL: Reading File Storage Data Incrementally","sidebarTitle":"ETL: Reading File Storage Data Incrementally","href":"/etl/how-do-i-read-data-from-file-storage-incrementally"},{"title":"ETL: File Storage Options","sidebarTitle":"ETL: File Storage Options","href":"/etl/file-storage-options"},{"title":"ETL: Salesforce Objects Reference","sidebarTitle":"ETL: Salesforce Objects Reference","href":"/etl/list-of-salesforce-objects"},{"title":"ETL: Salesforce PK Chunking","sidebarTitle":"ETL: Salesforce PK Chunking","href":"/etl/salesforce-pk-chunking"},{"title":"ETL: Selecting File Input Format","sidebarTitle":"ETL: Selecting File Input Format","href":"/etl/how-do-i-select-my-file-input-format"},{"title":"ETL: API Endpoints with Pagination","sidebarTitle":"ETL: API Endpoints with Pagination","href":"/etl/api-endpoints-with-pagination-support"},{"title":"ETL: Pattern Matching in Source Paths","sidebarTitle":"ETL: Pattern Matching in Source Paths","href":"/etl/using-pattern-matching-in-source-component-paths"},{"title":"ETL: Salesforce to SFTP Workflow","sidebarTitle":"ETL: Salesforce to SFTP Workflow","href":"/etl/creating-an-api-managed-salesforce-to-sftp-workflow"}]}]},{"group":"Transformations","icon":"wand-magic-sparkles","pages":[{"title":"ETL: Transformations","sidebarTitle":"ETL: Transformations Overview","href":"/etl/category/transformations"},{"title":"ETL: Select Transformation","sidebarTitle":"ETL: Select Transformation","href":"/etl/using-components-select-transformation"},{"title":"ETL: Filter Transformation","sidebarTitle":"ETL: Filter Transformation","href":"/etl/using-components-filter-transformation"},{"title":"ETL: Split Transformation","description":"Use the Split transformation to route each record to one of several named outputs by condition, with an optional Otherwise output.","sidebarTitle":"ETL: Split Transformation","href":"/etl/using-components-split-transformation"},{"title":"ETL: Join Transformation","sidebarTitle":"ETL: Join Transformation","jp_link":"/jp/etl/category/japanese-knowledge-base","ko_link":"/ko/etl/category/korean-knowledge-base","href":"/etl/using-components-join-transformation"},{"title":"ETL: Cross Join Transformation","sidebarTitle":"ETL: Cross Join Transformation","description":"Use the Cross Join transformation to produce a Cartesian product by combining every record from two inputs in your ETL data pipeline.","href":"/etl/using-components-cross-join-transformation"},{"title":"ETL: Lookup Transformation","sidebarTitle":"ETL: Lookup Transformation","href":"/etl/using-components-db-lookup-transformation"},{"title":"ETL: Union Transformation","sidebarTitle":"ETL: Union Transformation","href":"/etl/using-components-union-transformation"},{"title":"ETL: Aggregate Transformation","sidebarTitle":"ETL: Aggregate Transformation","href":"/etl/using-components-aggregate-transformation"},{"title":"ETL: Distinct Transformation","sidebarTitle":"ETL: Distinct Transformation","href":"/etl/using-components-distinct-transformation"},{"title":"ETL: Dedupe Transformation","sidebarTitle":"ETL: Dedupe Transformation","href":"/etl/using-components-dedupe-transformation"},{"title":"ETL: Sort Transformation","sidebarTitle":"ETL: Sort Transformation","href":"/etl/using-components-sort-transformation"},{"title":"ETL: Rank Transformation","sidebarTitle":"ETL: Rank Transformation","href":"/etl/using-components-rank-transformation"},{"title":"ETL: Window Transformation","sidebarTitle":"ETL: Window Transformation","href":"/etl/using-components-window-transformation"},{"title":"ETL: Limit Transformation","sidebarTitle":"ETL: Limit Transformation","href":"/etl/using-components-limit-transformation"},{"title":"ETL: Sample Transformation","sidebarTitle":"ETL: Sample Transformation","href":"/etl/using-components-sample-transformation"},{"title":"ETL: Clone Transformation","sidebarTitle":"ETL: Clone Transformation","href":"/etl/using-components-clone-transformation"},{"title":"ETL: Assert Transformation","sidebarTitle":"ETL: Assert Transformation","href":"/etl/using-components-assert-transformation"},{"title":"ETL: Validate Transformation","sidebarTitle":"ETL: Validate Transformation","href":"/etl/using-components-validate-transformation"},{"title":"ETL: Cube Transformation","sidebarTitle":"ETL: Cube Transformation","href":"/etl/using-components-cube-transformation"},{"title":"ETL: AI Transformation","sidebarTitle":"ETL: AI Transformation","href":"/etl/using-components-ai-transformation"},{"title":"ETL: API Call Transformation","sidebarTitle":"ETL: API Call Transformation","href":"/etl/using-components-api-call-transformation"},{"title":"ETL: Python Transformation","sidebarTitle":"ETL: Python Transformation","href":"/etl/using-components-python-transformation"},{"title":"ETL: Pivot Transformation","sidebarTitle":"ETL: Pivot Transformation","href":"/etl/using-components-pivot-transformation"},{"title":"ETL: Unpivot Transformation","sidebarTitle":"ETL: Unpivot Transformation","href":"/etl/using-components-unpivot-transformation"}]},{"group":"Expressions \u0026 Functions","icon":"function","pages":[{"title":"ETL: Expressions \u0026 Functions","sidebarTitle":"ETL: Expressions \u0026 Functions Overview","href":"/etl/category/expressions-and-functions"},{"title":"ETL: Functions Reference","sidebarTitle":"ETL: Functions Reference","href":"/etl/integrateio-etl-functions"},{"title":"ETL: Using Expressions","sidebarTitle":"ETL: Using Expressions","href":"/etl/using-expressions-in-integrateio-etl"},{"title":"ETL: Using and Setting Variables","sidebarTitle":"ETL: Using and Setting Variables","href":"/etl/using-and-setting-variables-in-your-packages"},{"title":"ETL: Global Variables","sidebarTitle":"ETL: Global Variables","href":"/etl/global-variables-account-level"},{"title":"ETL: Global Secrets","sidebarTitle":"ETL: Global Secrets","href":"/etl/global-secrets-account-level"},{"title":"ETL: PGP Keys","sidebarTitle":"ETL: PGP Keys","href":"/etl/pgp-keys-account-level"},{"title":"ETL: System and Pre-Defined Variables","sidebarTitle":"ETL: System and Pre-Defined Variables","href":"/etl/system-and-pre-defined-variables"},{"title":"ETL: ISO 8601 String Functions","sidebarTitle":"ETL: ISO 8601 String Functions","href":"/etl/using-iso-8601-string-functions"},{"title":"ETL: Encrypting and Decrypting Data","sidebarTitle":"ETL: Encrypting and Decrypting Data","href":"/etl/how-do-i-encrypt-and-decrypt-sensitive-data"},{"title":"ETL: Processing JSON Data","sidebarTitle":"ETL: Processing JSON Data","href":"/etl/how-do-i-process-json-data"},{"title":"ETL: Processing XML Data","sidebarTitle":"ETL: Processing XML Data","href":"/etl/how-do-i-process-xml-data"},{"title":"ETL: Processing Different Encodings","sidebarTitle":"ETL: Processing Different Encodings","href":"/etl/how-do-i-process-a-different-encoding"},{"title":"ETL: Working with Datetime Data","sidebarTitle":"ETL: Working with Datetime Data","href":"/etl/how-do-i-work-with-datetime-data"},{"title":"ETL: Date Time Converter","sidebarTitle":"ETL: Date Time Converter","href":"/etl/datetime-converter"},{"group":"Functions A to Z","expanded":false,"pages":[{"title":"ETL: ABS","sidebarTitle":"ETL: ABS","href":"/etl/abs"},{"title":"ETL: ACOS","sidebarTitle":"ETL: ACOS","href":"/etl/acos"},{"title":"ETL: AddDuration","sidebarTitle":"ETL: AddDuration","href":"/etl/addduration"},{"title":"ETL: AddToDate","sidebarTitle":"ETL: AddToDate","href":"/etl/addtodate"},{"title":"ETL: ASIN","sidebarTitle":"ETL: ASIN","href":"/etl/asin"},{"title":"ETL: ATAN","sidebarTitle":"ETL: ATAN","href":"/etl/atan"},{"title":"ETL: BagToString","sidebarTitle":"ETL: BagToString","href":"/etl/bagtostring"},{"title":"ETL: BagToTuple","sidebarTitle":"ETL: BagToTuple","href":"/etl/bagtotuple"},{"title":"ETL: Base64Decode","sidebarTitle":"ETL: Base64Decode","href":"/etl/base64decode"},{"title":"ETL: Base64DecodeToString","sidebarTitle":"ETL: Base64DecodeToString","href":"/etl/base64decodetostring"},{"title":"ETL: Base64Encode","sidebarTitle":"ETL: Base64Encode","href":"/etl/base64encode"},{"title":"ETL: Base64EncodeToString","sidebarTitle":"ETL: Base64EncodeToString","href":"/etl/base64encodetostring"},{"title":"ETL: BinaryCCurl","sidebarTitle":"ETL: BinaryCCurl","href":"/etl/binaryccurl"},{"title":"ETL: BinaryCurl","sidebarTitle":"ETL: BinaryCurl","href":"/etl/binarycurl"},{"title":"ETL: BrowserFamily","sidebarTitle":"ETL: BrowserFamily","href":"/etl/browserfamily"},{"title":"ETL: BrowserFullName","sidebarTitle":"ETL: BrowserFullName","href":"/etl/browserfullname"},{"title":"ETL: BrowserMajor","sidebarTitle":"ETL: BrowserMajor","href":"/etl/browsermajor"},{"title":"ETL: BrowserMinor","sidebarTitle":"ETL: BrowserMinor","href":"/etl/browserminor"},{"title":"ETL: BrowserPatch","sidebarTitle":"ETL: BrowserPatch","href":"/etl/browserpatch"},{"title":"ETL: BrowserVersion","sidebarTitle":"ETL: BrowserVersion","href":"/etl/browserversion"},{"title":"ETL: ByteArrayToString","sidebarTitle":"ETL: ByteArrayToString","href":"/etl/bytearraytostring"},{"title":"ETL: CBRT","sidebarTitle":"ETL: CBRT","href":"/etl/cbrt"},{"title":"ETL: CCurl","sidebarTitle":"ETL: CCurl","href":"/etl/ccurl"},{"title":"ETL: CCurlPoll","sidebarTitle":"ETL: CCurlPoll","href":"/etl/ccurlpoll"},{"title":"ETL: CCurlWithPagination","sidebarTitle":"ETL: CCurlWithPagination","href":"/etl/ccurlwithpagination"},{"title":"ETL: CEIL","sidebarTitle":"ETL: CEIL","href":"/etl/ceil"},{"title":"ETL: CityNameFromIP","sidebarTitle":"ETL: CityNameFromIP","href":"/etl/citynamefromip"},{"title":"ETL: ClockTime","sidebarTitle":"ETL: ClockTime","href":"/etl/clocktime"},{"title":"ETL: COALESCE","sidebarTitle":"ETL: COALESCE","href":"/etl/coalesce"},{"title":"ETL: CONCAT","sidebarTitle":"ETL: CONCAT","href":"/etl/concat"},{"title":"ETL: ContinentCodeFromIP","sidebarTitle":"ETL: ContinentCodeFromIP","href":"/etl/continentcodefromip"},{"title":"ETL: ContinentNameFromIP","sidebarTitle":"ETL: ContinentNameFromIP","href":"/etl/continentnamefromip"},{"title":"ETL: COS","sidebarTitle":"ETL: COS","href":"/etl/cos"},{"title":"ETL: COSH","sidebarTitle":"ETL: COSH","href":"/etl/cosh"},{"title":"ETL: CountryCodeFromIP","sidebarTitle":"ETL: CountryCodeFromIP","href":"/etl/countrycodefromip"},{"title":"ETL: CountryNameFromIP","sidebarTitle":"ETL: CountryNameFromIP","href":"/etl/countrynamefromip"},{"title":"ETL: CSVSPLIT","sidebarTitle":"ETL: CSVSPLIT","href":"/etl/csvsplit"},{"title":"ETL: Curl","sidebarTitle":"ETL: Curl","href":"/etl/curl"},{"title":"ETL: CurlPoll","sidebarTitle":"ETL: CurlPoll","href":"/etl/curlpoll"},{"title":"ETL: CurlWithPagination function reference","sidebarTitle":"ETL: CurlWithPagination","href":"/etl/curlwithpagination"},{"title":"ETL: CurrentTime","sidebarTitle":"ETL: CurrentTime","href":"/etl/currenttime"},{"title":"ETL: DateDiffDays","sidebarTitle":"ETL: DateDiffDays","href":"/etl/datediffdays"},{"title":"ETL: DateDiffHours","sidebarTitle":"ETL: DateDiffHours","href":"/etl/datediffhours"},{"title":"ETL: DateDiffMinutes","sidebarTitle":"ETL: DateDiffMinutes","href":"/etl/datediffminutes"},{"title":"ETL: DateDiffMonths","sidebarTitle":"ETL: DateDiffMonths","href":"/etl/datediffmonths"},{"title":"ETL: DateDiffSeconds","sidebarTitle":"ETL: DateDiffSeconds","href":"/etl/datediffseconds"},{"title":"ETL: DateDiffYears","sidebarTitle":"ETL: DateDiffYears","href":"/etl/datediffyears"},{"title":"ETL: DateToExcelSerial","sidebarTitle":"ETL: DateToExcelSerial","href":"/etl/datetoexcelserial"},{"title":"ETL: DaysBetween","sidebarTitle":"ETL: DaysBetween","href":"/etl/daysbetween"},{"title":"ETL: Decrypt","sidebarTitle":"ETL: Decrypt","href":"/etl/decrypt"},{"title":"ETL: DeviceFamily","sidebarTitle":"ETL: DeviceFamily","href":"/etl/devicefamily"},{"title":"ETL: DistInMilesHaversine","sidebarTitle":"ETL: DistInMilesHaversine","href":"/etl/distinmileshaversine"},{"title":"ETL: Encrypt","sidebarTitle":"ETL: Encrypt","href":"/etl/encrypt"},{"title":"ETL: ExcelSerialToDate","sidebarTitle":"ETL: ExcelSerialToDate","href":"/etl/excelserialtodate"},{"title":"ETL: ExecuteBQInsert","sidebarTitle":"ETL: ExecuteBQInsert","href":"/etl/executebqinsert"},{"title":"ETL: ExecuteSqlBoolean","sidebarTitle":"ETL: ExecuteSqlBoolean","href":"/etl/executesqlboolean"},{"title":"ETL: ExecuteSqlDateTime","sidebarTitle":"ETL: ExecuteSqlDateTime","href":"/etl/executesqldatetime"},{"title":"ETL: ExecuteSqlDouble","sidebarTitle":"ETL: ExecuteSqlDouble","href":"/etl/executesqldouble"},{"title":"ETL: ExecuteSqlFloat","sidebarTitle":"ETL: ExecuteSqlFloat","href":"/etl/executesqlfloat"},{"title":"ETL: ExecuteSqlInt","sidebarTitle":"ETL: ExecuteSqlInt","href":"/etl/executesqlint"},{"title":"ETL: ExecuteSqlLong","sidebarTitle":"ETL: ExecuteSqlLong","href":"/etl/executesqllong"},{"title":"ETL: ExecuteSqlNonQuery","sidebarTitle":"ETL: ExecuteSqlNonQuery","href":"/etl/executesqlnonquery"},{"title":"ETL: ExecuteSqlString","sidebarTitle":"ETL: ExecuteSqlString","href":"/etl/executesqlstring"},{"title":"ETL: EXP","sidebarTitle":"ETL: EXP","href":"/etl/exp"},{"title":"ETL: ExtractQueryStringParam","sidebarTitle":"ETL: ExtractQueryStringParam","href":"/etl/extractquerystringparam"},{"title":"ETL: ExtractSearchQuery","sidebarTitle":"ETL: ExtractSearchQuery","href":"/etl/extractsearchquery"},{"title":"ETL: ExtractUABrowserID","sidebarTitle":"ETL: ExtractUABrowserID","href":"/etl/extractuabrowserid"},{"title":"ETL: ExtractUABrowserName","sidebarTitle":"ETL: ExtractUABrowserName","href":"/etl/extractuabrowsername"},{"title":"ETL: ExtractUrlPart","sidebarTitle":"ETL: ExtractUrlPart","href":"/etl/extracturlpart"},{"title":"ETL: Flatten","sidebarTitle":"ETL: Flatten","href":"/etl/flatten"},{"title":"ETL: FLOOR","sidebarTitle":"ETL: FLOOR","href":"/etl/floor"},{"title":"ETL: FUZZY_MATCH","sidebarTitle":"ETL: FUZZY_MATCH","href":"/etl/fuzzy-match"},{"title":"ETL: GetBytes","sidebarTitle":"ETL: GetBytes","href":"/etl/getbytes"},{"title":"ETL: GetDay","sidebarTitle":"ETL: GetDay","href":"/etl/getday"},{"title":"ETL: GetHour","sidebarTitle":"ETL: GetHour","href":"/etl/gethour"},{"title":"ETL: GetMilliSecond","sidebarTitle":"ETL: GetMilliSecond","href":"/etl/getmillisecond"},{"title":"ETL: GetMinute","sidebarTitle":"ETL: GetMinute","href":"/etl/getminute"},{"title":"ETL: GetMonth","sidebarTitle":"ETL: GetMonth","href":"/etl/getmonth"},{"title":"ETL: GetSecond","sidebarTitle":"ETL: GetSecond","href":"/etl/getsecond"},{"title":"ETL: GetWeek","sidebarTitle":"ETL: GetWeek","href":"/etl/getweek"},{"title":"ETL: GetWeekYear","sidebarTitle":"ETL: GetWeekYear","href":"/etl/getweekyear"},{"title":"ETL: GetYear","sidebarTitle":"ETL: GetYear","href":"/etl/getyear"},{"title":"ETL: HoursBetween","sidebarTitle":"ETL: HoursBetween","href":"/etl/hoursbetween"},{"title":"ETL: INDEXOF","sidebarTitle":"ETL: INDEXOF","href":"/etl/indexof"},{"title":"ETL: INITCAP","sidebarTitle":"ETL: INITCAP","href":"/etl/initcap"},{"title":"ETL: IntervalIntersection","sidebarTitle":"ETL: IntervalIntersection","href":"/etl/intervalintersection"},{"title":"ETL: IsBase64","sidebarTitle":"ETL: IsBase64","href":"/etl/isbase64"},{"title":"ETL: IsEmpty","sidebarTitle":"ETL: IsEmpty","href":"/etl/isempty"},{"title":"ETL: IsISODatetime","sidebarTitle":"ETL: IsISODatetime","href":"/etl/isisodatetime"},{"title":"ETL: ISOAddDuration","sidebarTitle":"ETL: ISOAddDuration","href":"/etl/isoaddduration"},{"title":"ETL: ISODatetimeToString","sidebarTitle":"ETL: ISODatetimeToString","href":"/etl/isodatetimetostring"},{"title":"ETL: ISODatetimeToTimestampFormat","sidebarTitle":"ETL: ISODatetimeToTimestampFormat","href":"/etl/isodatetimetotimestampformat"},{"title":"ETL: ISOSubtractDuration","sidebarTitle":"ETL: ISOSubtractDuration","href":"/etl/isosubtractduration"},{"title":"ETL: ISOToDay","sidebarTitle":"ETL: ISOToDay","href":"/etl/isotoday"},{"title":"ETL: ISOToHour","sidebarTitle":"ETL: ISOToHour","href":"/etl/isotohour"},{"title":"ETL: ISOToMinute","sidebarTitle":"ETL: ISOToMinute","href":"/etl/isotominute"},{"title":"ETL: ISOToMonth","sidebarTitle":"ETL: ISOToMonth","href":"/etl/isotomonth"},{"title":"ETL: ISOToSecond","sidebarTitle":"ETL: ISOToSecond","href":"/etl/isotosecond"},{"title":"ETL: ISOToWeek","sidebarTitle":"ETL: ISOToWeek","href":"/etl/isotoweek"},{"title":"ETL: ISOToYear","sidebarTitle":"ETL: ISOToYear","href":"/etl/isotoyear"},{"title":"ETL: JsonExtract","sidebarTitle":"ETL: JsonExtract","href":"/etl/jsonextract"},{"title":"ETL: JsonExtractScalar","sidebarTitle":"ETL: JsonExtractScalar","href":"/etl/jsonextractscalar"},{"title":"ETL: JsonStringToBag","sidebarTitle":"ETL: JsonStringToBag","href":"/etl/jsonstringtobag"},{"title":"ETL: JsonStringToMap","sidebarTitle":"ETL: JsonStringToMap","href":"/etl/jsonstringtomap"},{"title":"ETL: LAST_INDEX_OF","sidebarTitle":"ETL: LAST_INDEX_OF","href":"/etl/last-index-of"},{"title":"ETL: LatitudeFromIP","sidebarTitle":"ETL: LatitudeFromIP","href":"/etl/latitudefromip"},{"title":"ETL: LCFIRST","sidebarTitle":"ETL: LCFIRST","href":"/etl/lcfirst"},{"title":"ETL: Length","sidebarTitle":"ETL: Length","href":"/etl/length"},{"title":"ETL: LOG","sidebarTitle":"ETL: LOG","href":"/etl/log"},{"title":"ETL: LOG10","sidebarTitle":"ETL: LOG10","href":"/etl/log10"},{"title":"ETL: LongitudeFromIP","sidebarTitle":"ETL: LongitudeFromIP","href":"/etl/longitudefromip"},{"title":"ETL: LOWER","sidebarTitle":"ETL: LOWER","href":"/etl/lower"},{"title":"ETL: MapToBag","sidebarTitle":"ETL: MapToBag","href":"/etl/maptobag"},{"title":"ETL: MapToQueryString","sidebarTitle":"ETL: MapToQueryString","href":"/etl/maptoquerystring"},{"title":"ETL: MD2","sidebarTitle":"ETL: MD2","href":"/etl/md2"},{"title":"ETL: MD5","sidebarTitle":"ETL: MD5","href":"/etl/md5"},{"title":"ETL: MilliSecondsBetween","sidebarTitle":"ETL: MilliSecondsBetween","href":"/etl/millisecondsbetween"},{"title":"ETL: MinutesBetween","sidebarTitle":"ETL: MinutesBetween","href":"/etl/minutesbetween"},{"title":"ETL: MonthsBetween","sidebarTitle":"ETL: MonthsBetween","href":"/etl/monthsbetween"},{"title":"ETL: NormalizeDate","sidebarTitle":"ETL: NormalizeDate","href":"/etl/normalizedate"},{"title":"ETL: NormalizeLanguage","sidebarTitle":"ETL: NormalizeLanguage","href":"/etl/normalizelanguage"},{"title":"ETL: NormalizePhone","sidebarTitle":"ETL: NormalizePhone","href":"/etl/normalizephone"},{"title":"ETL: NormalizeState","sidebarTitle":"ETL: NormalizeState","href":"/etl/normalizestate"},{"title":"ETL: OsFamily","sidebarTitle":"ETL: OsFamily","href":"/etl/osfamily"},{"title":"ETL: OsFullName","sidebarTitle":"ETL: OsFullName","href":"/etl/osfullname"},{"title":"ETL: OsMajor","sidebarTitle":"ETL: OsMajor","href":"/etl/osmajor"},{"title":"ETL: OsMinor","sidebarTitle":"ETL: OsMinor","href":"/etl/osminor"},{"title":"ETL: OsPatch","sidebarTitle":"ETL: OsPatch","href":"/etl/ospatch"},{"title":"ETL: OsPatchMinor","sidebarTitle":"ETL: OsPatchMinor","href":"/etl/ospatchminor"},{"title":"ETL: OsVersion","sidebarTitle":"ETL: OsVersion","href":"/etl/osversion"},{"title":"ETL: ParseDate","sidebarTitle":"ETL: ParseDate","href":"/etl/parsedate"},{"title":"ETL: ParseDoubleOrDefault","sidebarTitle":"ETL: ParseDoubleOrDefault","href":"/etl/parsedoubleordefault"},{"title":"ETL: ParseFloatOrDefault","sidebarTitle":"ETL: ParseFloatOrDefault","href":"/etl/parsefloatordefault"},{"title":"ETL: ParseIntOrDefault","sidebarTitle":"ETL: ParseIntOrDefault","href":"/etl/parseintordefault"},{"title":"ETL: ParseLongOrDefault","sidebarTitle":"ETL: ParseLongOrDefault","href":"/etl/parselongordefault"},{"title":"ETL: ParseMoney","sidebarTitle":"ETL: ParseMoney","href":"/etl/parsemoney"},{"title":"ETL: PlatformFamily","sidebarTitle":"ETL: PlatformFamily","href":"/etl/platformfamily"},{"title":"ETL: POW","sidebarTitle":"ETL: POW","href":"/etl/pow"},{"title":"ETL: QueryStringToMap","sidebarTitle":"ETL: QueryStringToMap","href":"/etl/querystringtomap"},{"title":"ETL: RANDOM","sidebarTitle":"ETL: RANDOM","href":"/etl/random"},{"title":"ETL: REGEX_EXTRACT","sidebarTitle":"ETL: REGEX_EXTRACT","href":"/etl/regex-extract"},{"title":"ETL: REGEX_EXTRACT_ALL","sidebarTitle":"ETL: REGEX_EXTRACT_ALL","href":"/etl/regex-extract-all"},{"title":"ETL: REGEX_FIND_ALL","sidebarTitle":"ETL: REGEX_FIND_ALL","href":"/etl/regex-find-all"},{"title":"ETL: RegionCodeFromIP","sidebarTitle":"ETL: RegionCodeFromIP","href":"/etl/regioncodefromip"},{"title":"ETL: RegionNameFromIP","sidebarTitle":"ETL: RegionNameFromIP","href":"/etl/regionnamefromip"},{"title":"ETL: REPLACE","sidebarTitle":"ETL: REPLACE","href":"/etl/replace"},{"title":"ETL: Reverse","sidebarTitle":"ETL: Reverse","href":"/etl/reverse"},{"title":"ETL: ROUND","sidebarTitle":"ETL: ROUND","href":"/etl/round"},{"title":"ETL: ROUND_TO","sidebarTitle":"ETL: ROUND_TO","href":"/etl/round-to"},{"title":"ETL: SecondsBetween","sidebarTitle":"ETL: SecondsBetween","href":"/etl/secondsbetween"},{"title":"ETL: SHA1","sidebarTitle":"ETL: SHA1","href":"/etl/sha1"},{"title":"ETL: SHA256","sidebarTitle":"ETL: SHA256","href":"/etl/sha256"},{"title":"ETL: SHA256WithRSA","sidebarTitle":"ETL: SHA256WithRSA","href":"/etl/sha256withrsa"},{"title":"ETL: SHA384","sidebarTitle":"ETL: SHA384","href":"/etl/sha384"},{"title":"ETL: SHA512","sidebarTitle":"ETL: SHA512","href":"/etl/sha512"},{"title":"ETL: SIN","sidebarTitle":"ETL: SIN","href":"/etl/sin"},{"title":"ETL: SINH","sidebarTitle":"ETL: SINH","href":"/etl/sinh"},{"title":"ETL: SIZE","sidebarTitle":"ETL: SIZE","href":"/etl/size"},{"title":"ETL: Sleep","sidebarTitle":"ETL: Sleep","href":"/etl/sleep"},{"title":"ETL: SPRINTF","sidebarTitle":"ETL: SPRINTF","href":"/etl/sprintf"},{"title":"ETL: SQRT","sidebarTitle":"ETL: SQRT","href":"/etl/sqrt"},{"title":"ETL: StringToISODatetime","sidebarTitle":"ETL: StringToISODatetime","href":"/etl/stringtoisodatetime"},{"title":"ETL: STRSPLIT","sidebarTitle":"ETL: STRSPLIT","href":"/etl/strsplit"},{"title":"ETL: STRSPLITTOBAG","sidebarTitle":"ETL: STRSPLITTOBAG","href":"/etl/strsplittobag"},{"title":"ETL: SUBSTRING","sidebarTitle":"ETL: SUBSTRING","href":"/etl/substring"},{"title":"ETL: SubtractDuration","sidebarTitle":"ETL: SubtractDuration","href":"/etl/subtractduration"},{"title":"ETL: SwitchTimeZone","sidebarTitle":"ETL: SwitchTimeZone","href":"/etl/switchtimezone"},{"title":"ETL: TAN","sidebarTitle":"ETL: TAN","href":"/etl/tan"},{"title":"ETL: TANH","sidebarTitle":"ETL: TANH","href":"/etl/tanh"},{"title":"ETL: TimestampFormatToISODatetime","sidebarTitle":"ETL: TimestampFormatToISODatetime","href":"/etl/timestampformattoisodatetime"},{"title":"ETL: TOBAG","sidebarTitle":"ETL: TOBAG","href":"/etl/tobag"},{"title":"ETL: ToDate","sidebarTitle":"ETL: ToDate","href":"/etl/todate"},{"title":"ETL: ToDateCustomFormats","sidebarTitle":"ETL: ToDateCustomFormats","href":"/etl/todatecustomformats"},{"title":"ETL: ToDateOrNull","sidebarTitle":"ETL: ToDateOrNull","href":"/etl/todateornull"},{"title":"ETL: ToHexString","sidebarTitle":"ETL: ToHexString","href":"/etl/tohexstring"},{"title":"ETL: ToJson","sidebarTitle":"ETL: ToJson","href":"/etl/tojson"},{"title":"ETL: TOKENIZE","sidebarTitle":"ETL: TOKENIZE","href":"/etl/tokenize"},{"title":"ETL: TOMAP","sidebarTitle":"ETL: TOMAP","href":"/etl/tomap"},{"title":"ETL: ToMilliSeconds","sidebarTitle":"ETL: ToMilliSeconds","href":"/etl/tomilliseconds"},{"title":"ETL: ToString","sidebarTitle":"ETL: ToString","href":"/etl/tostring"},{"title":"ETL: TOTUPLE","sidebarTitle":"ETL: TOTUPLE","href":"/etl/totuple"},{"title":"ETL: ToUnixTime","sidebarTitle":"ETL: ToUnixTime","href":"/etl/tounixtime"},{"title":"ETL: TRIM","sidebarTitle":"ETL: TRIM","href":"/etl/trim"},{"title":"ETL: UCFIRST","sidebarTitle":"ETL: UCFIRST","href":"/etl/ucfirst"},{"title":"ETL: UPPER","sidebarTitle":"ETL: UPPER","href":"/etl/upper"},{"title":"ETL: URLDecode","sidebarTitle":"ETL: URLDecode","href":"/etl/urldecode"},{"title":"ETL: URLEncode","sidebarTitle":"ETL: URLEncode","href":"/etl/urlencode"},{"title":"ETL: UUID","sidebarTitle":"ETL: UUID","href":"/etl/uuid"},{"title":"ETL: WeeksBetween","sidebarTitle":"ETL: WeeksBetween","href":"/etl/weeksbetween"},{"title":"ETL: XPath","sidebarTitle":"ETL: XPath","href":"/etl/xpath"},{"title":"ETL: XPathToBag","sidebarTitle":"ETL: XPathToBag","href":"/etl/xpathtobag"},{"title":"ETL: YearsBetween","sidebarTitle":"ETL: YearsBetween","href":"/etl/yearsbetween"}]}]},{"group":"Destinations","icon":"sliders-up","pages":[{"title":"ETL: Destinations","sidebarTitle":"ETL: Destinations Overview","href":"/etl/category/destinations"},{"title":"ETL: Amazon Redshift Destination","sidebarTitle":"ETL: Amazon Redshift","href":"/etl/using-components-amazon-redshift-destination"},{"title":"ETL: Amazon S3 Destination","sidebarTitle":"ETL: Amazon S3","href":"/etl/using-components-amazon-s3-destination"},{"title":"ETL: Azure Blob Storage Destination","sidebarTitle":"ETL: Azure Blob Storage","href":"/etl/using-components-azure-blob-storage-destination"},{"title":"ETL: Database Destination","sidebarTitle":"ETL: Database","href":"/etl/using-components-database-destination"},{"title":"ETL: Databricks Destination","sidebarTitle":"ETL: Databricks","href":"/etl/using-components-databricks-destination"},{"title":"ETL: Email Report Destination","sidebarTitle":"ETL: Email Report","href":"/etl/using-components-email-report"},{"title":"ETL: Facebook Ads Destination","sidebarTitle":"ETL: Facebook Ads","href":"/etl/using-components-facebook-ads-destination"},{"title":"ETL: File Storage Destination","sidebarTitle":"ETL: File Storage","href":"/etl/using-components-file-storage-destination"},{"title":"ETL: Google Ads Destination","sidebarTitle":"ETL: Google Ads","href":"/etl/using-components-google-ads-destination"},{"title":"ETL: Google Cloud Storage Destination","sidebarTitle":"ETL: Google Cloud Storage","href":"/etl/using-components-google-cloud-storage-destination"},{"title":"ETL: FTPS Destination","sidebarTitle":"ETL: FTPS","href":"/etl/using-components-ftps-destination"},{"title":"ETL: HDFS Destination","sidebarTitle":"ETL: HDFS","href":"/etl/using-components-hdfs-destination"},{"title":"ETL: SFTP Destination","sidebarTitle":"ETL: SFTP","href":"/etl/using-components-sftp-destination"},{"title":"ETL: Google BigQuery Destination","sidebarTitle":"ETL: Google BigQuery","href":"/etl/using-components-google-bigquery-destination"},{"title":"ETL: Google Spanner Destination","sidebarTitle":"ETL: Google Spanner","href":"/etl/using-components-google-spanner-destination"},{"title":"ETL: HubSpot Destination","sidebarTitle":"ETL: HubSpot","href":"/etl/using-components-hubspot-destination"},{"title":"ETL: MongoDB Destination","sidebarTitle":"ETL: MongoDB","href":"/etl/using-components-mongodb-destination"},{"title":"ETL: NetSuite REST Destination","sidebarTitle":"ETL: NetSuite REST","href":"/etl/using-components-netsuite-rest-destination"},{"title":"ETL: Netsuite SOAP Destination","sidebarTitle":"ETL: NetSuite SOAP","href":"/etl/using-components-netsuite-soap-destination"},{"title":"ETL: Ometria Destination","sidebarTitle":"ETL: Ometria","href":"/etl/using-components-ometria-destination"},{"title":"ETL: OneTouch Health Destination","sidebarTitle":"ETL: OneTouch Health","href":"/etl/using-components-onetouch-health-destination"},{"title":"ETL: Outlook Calendar Destination","sidebarTitle":"ETL: Outlook Calendar","href":"/etl/using-components-outlook-calendar-destination"},{"title":"ETL: Salesforce Bulk API Destination","sidebarTitle":"ETL: Salesforce Bulk API","href":"/etl/using-components-salesforce-destination"},{"title":"ETL: Salesforce Data Cloud Destination","sidebarTitle":"ETL: Salesforce Data Cloud","href":"/etl/using-components-salesforce-data-cloud-destination"},{"title":"ETL: Salesforce REST API Destination","sidebarTitle":"ETL: Salesforce REST API","href":"/etl/using-components-salesforce-rest-destination"},{"title":"ETL: SharePoint Destination","sidebarTitle":"ETL: SharePoint Destination","href":"/etl/using-components-sharepoint-destination"},{"title":"ETL: ServiceNow Destination","sidebarTitle":"ETL: ServiceNow","href":"/etl/using-components-servicenow-destination"},{"title":"ETL: REST API Destination","sidebarTitle":"ETL: REST API","href":"/etl/using-components-rest-api-destination"},{"title":"ETL: Snowflake Destination","sidebarTitle":"ETL: Snowflake","href":"/etl/using-components-snowflake-destination"},{"title":"ETL: TikTok Ads Destination","sidebarTitle":"ETL: TikTok Ads","href":"/etl/using-components-tiktok-ads-destination"},{"title":"ETL: Trustpilot Destination","sidebarTitle":"ETL: Trustpilot","href":"/etl/using-components-trustpilot-destination"},{"title":"ETL: Google Sheets Destination","sidebarTitle":"ETL: Google Sheets","href":"/etl/using-components-google-sheets-destination"},{"title":"ETL: Connecting to Azure SQL","sidebarTitle":"ETL: Azure SQL","href":"/etl/allowing-integrateio-etl-access-to-azure-sql-databases"},{"title":"ETL: Connecting to Azure Synapse Analytics","sidebarTitle":"ETL: Azure Synapse Analytics","href":"/etl/allowing-integrateio-etl-access-to-azure-synapse-analytics"},{"title":"ETL: Windows File Share Destination","sidebarTitle":"ETL: Windows File Share","href":"/etl/connecting-to-windows-file-share-destination"}]},{"group":"Scheduling, Jobs \u0026 Clusters","icon":"list-check","pages":[{"title":"ETL: Scheduling, Jobs \u0026 Clusters","sidebarTitle":"ETL: Scheduling, Jobs \u0026 Clusters Overview","href":"/etl/category/scheduling-jobs-and-clusters"},{"title":"ETL: Running Jobs","sidebarTitle":"ETL: Running Jobs","href":"/etl/running-jobs"},{"title":"ETL: Scheduling Package Execution","sidebarTitle":"ETL: Scheduling Package Execution","href":"/etl/scheduling-package-execution"},{"title":"ETL: Monitoring Jobs","sidebarTitle":"ETL: Monitoring Jobs","href":"/etl/monitoring-jobs"},{"title":"ETL: Viewing All Jobs in the Account","sidebarTitle":"ETL: Viewing All Jobs in the Account","href":"/etl/viewing-all-jobs-in-the-account"},{"title":"ETL: Viewing Completed Task Outputs","sidebarTitle":"ETL: Viewing Completed Task Outputs","href":"/etl/viewing-completed-tasks-outputs"},{"title":"ETL: Viewing Job Error Details","sidebarTitle":"ETL: Viewing Job Error Details","href":"/etl/viewing-job-error-details-for-failed-jobs"},{"title":"ETL: Viewing Job Insights","sidebarTitle":"ETL: Viewing Job Insights","href":"/etl/viewing-job-insights"},{"title":"ETL: Creating a Cluster","sidebarTitle":"ETL: Creating a Cluster","href":"/etl/creating-a-cluster"},{"title":"ETL: Editing and Scaling Clusters","sidebarTitle":"ETL: Editing and Scaling Clusters","href":"/etl/editing-and-scaling-clusters"},{"title":"ETL: Monitoring Clusters","sidebarTitle":"ETL: Monitoring Clusters","href":"/etl/monitoring-clusters"},{"title":"ETL: Terminating a Cluster","sidebarTitle":"ETL: Terminating a Cluster","href":"/etl/terminating-a-cluster"}]},{"group":"Alerts \u0026 Monitoring","icon":"bell","pages":[{"title":"ETL: Alerts \u0026 Monitoring","sidebarTitle":"ETL: Alerts \u0026 Monitoring Overview","href":"/etl/category/alerts-and-monitoring"},{"title":"ETL: Email Hooks","sidebarTitle":"ETL: Email Hooks","href":"/etl/email-hooks"},{"title":"ETL: Slack Hooks","sidebarTitle":"ETL: Slack Hooks","href":"/etl/slack-hooks"},{"title":"ETL: Microsoft Teams Hooks","sidebarTitle":"ETL: Microsoft Teams Hooks","href":"/etl/microsoft-teams-hooks"},{"title":"ETL: PagerDuty Hooks","sidebarTitle":"ETL: PagerDuty Hooks","href":"/etl/pagerduty-hooks"},{"title":"ETL: Service Hooks","sidebarTitle":"ETL: Service Hooks","href":"/etl/service-hooks"},{"title":"ETL: Web and Email Notifications","sidebarTitle":"ETL: Web and Email Notifications","href":"/etl/viewing-and-setting-web-and-email-notifications"}]},{"group":"Log Drains","icon":"tower-broadcast","pages":[{"title":"ETL: Log Drains Overview","sidebarTitle":"ETL: Log Drains Overview","href":"/etl/category/log-drains"},{"title":"ETL: Log Drains","sidebarTitle":"ETL: Log Drains","href":"/etl/log-drains"}]},{"group":"Security \u0026 Access","icon":"shield-halved","pages":[{"title":"ETL: Security \u0026 Access","sidebarTitle":"ETL: Security \u0026 Access Overview","href":"/etl/category/security-and-access"},{"title":"ETL: Two-Factor Authentication","sidebarTitle":"ETL: Two-Factor Authentication","href":"/etl/2-factor-authentication"},{"title":"ETL: Single Sign-On","sidebarTitle":"ETL: Single Sign-On","href":"/etl/single-sign-on"},{"title":"ETL: User Management","sidebarTitle":"ETL: User Management","href":"/etl/user-management-overview"},{"title":"ETL: Managing Account Members","sidebarTitle":"ETL: Managing Account Members","href":"/etl/managing-your-integrateio-etl-account-members"},{"title":"ETL: Setting Account Member Roles","sidebarTitle":"ETL: Setting Account Member Roles","href":"/etl/setting-account-member-roles"},{"title":"ETL: Custom Roles","sidebarTitle":"ETL: Custom Roles","href":"/etl/custom-roles"},{"title":"ETL: Changing Your Password","sidebarTitle":"ETL: Changing Your Password","href":"/etl/changing-your-password"},{"title":"ETL: Password Policy","sidebarTitle":"ETL: Password Policy","href":"/etl/integrateio-etl-password-policy"},{"title":"ETL: Managing SSH Keys","sidebarTitle":"ETL: Managing SSH Keys","href":"/etl/managing-your-ssh-keys"},{"title":"ETL: Reverse SSH Tunnel from Windows","sidebarTitle":"ETL: Reverse SSH Tunnel from Windows","href":"/etl/set-up-a-reverse-ssh-tunnel-from-windows"},{"title":"ETL: Reverse SSH Tunnel from Windows (PowerShell)","sidebarTitle":"ETL: Reverse SSH Tunnel from Windows (PowerShell)","href":"/etl/set-up-a-reverse-ssh-tunnel-from-windows-powershell"},{"title":"ETL: Connecting Through a Firewall","sidebarTitle":"ETL: Firewall Setup","href":"/etl/allowing-integrateio-etl-access-to-my-server-behind-a-firewall"},{"title":"ETL: IP Allowlist","sidebarTitle":"ETL: IP Allowlist","href":"/etl/integrateio-etls-ip-list"}]},{"group":"Account Management","icon":"gear-complex-code","pages":[{"title":"ETL: Account Management","sidebarTitle":"ETL: Account Management Overview","href":"/etl/category/account-management"},{"title":"ETL: Managing Account Settings","sidebarTitle":"ETL: Managing Account Settings","href":"/etl/managing-your-account-settings"},{"title":"ETL: Trading Partners","sidebarTitle":"ETL: Trading Partners","href":"/etl/trading-partners-account-level"},{"title":"ETL: Partner Profile Validation Rules","sidebarTitle":"ETL: Partner Profile Validation Rules","href":"/etl/partner-profile-validation-rules"},{"title":"ETL: Modifying Personal Settings","sidebarTitle":"ETL: Modifying Personal Settings","href":"/etl/modifying-your-personal-settings"},{"title":"ETL: Selecting an Account","sidebarTitle":"ETL: Selecting an Account","href":"/etl/selecting-the-account-to-work-in"},{"title":"ETL: Migrating from Development to Production","sidebarTitle":"ETL: Migrating from Development to Production","href":"/etl/migrate-from-development-to-production"},{"title":"ETL: Selecting a Plan","sidebarTitle":"ETL: Selecting a Plan","href":"/etl/selecting-a-plan"},{"title":"ETL: Billing and Account Usage","sidebarTitle":"ETL: Billing and Account Usage","href":"/etl/viewing-and-modifying-your-billing-information-and-account-usage"},{"title":"ETL: Signing Out","sidebarTitle":"ETL: Signing Out","href":"/etl/signing-out-from-integrateio-etl"}]}]},{"tab":"API Reference","icon":"code-simple","pages":[{"title":"API Reference","href":"/api-reference/clusters/list-clusters"}]},{"tab":"MCP","icon":"plug","pages":[{"title":"MCP","href":"/etl/integrateio-mcp-server"}]}]},{"product":"ELT \u0026 CDC","pages":[{"title":"ELT \u0026 CDC","href":"/cdc"}]}]},{"language":"ko","pages":[{"title":"ko","href":"/ko/etl/category/korean-knowledge-base"}]},{"language":"jp","pages":[{"title":"jp","href":"/jp/etl/category/japanese-knowledge-base"}]}]},"basePath":"","title":"ETL: Join Transformation - Integrate.io","buildId":"dpl_Aw98ji4XvBsgtZwL1VrkUF9ehFqz","deploymentId":"dpl_Aw98ji4XvBsgtZwL1VrkUF9ehFqz","dynamics":["07c022d89b","a74be98ba7"],"chunks":["Frame-0domioUa.js","DynamicMarkdown-BcGRTrw6.js","zoom-image-lightbox-DsiWwPWR.js","lightbox-handle-r17bVUz3.js"]}