1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[4918],{55016:function(e,t,a){(window.__NEXT_P=window.__NEXT_P||[]).push(["/fivetran-sources",function(){return a(96862)}])},96862:function(e,t,a){"use strict";a.r(t),a.d(t,{CH:function(){return l},__toc:function(){return u},chCodeConfig:function(){return g}});var n=a(52322),o=a(28287),i=a(20337),s=a(93988);a(58614);var r=a(71199),d=a(65854),c=a(93808);let l={annotations:d.ds,Code:d.EK},g={staticMediaQuery:"not screen, (max-width: 768px)",lineNumbers:!0,showCopyButton:!0,themeName:"material-theme-darker"},u=[{depth:2,value:"Overview",id:"overview"},{depth:2,value:"Fivetran Source",id:"fivetran-source"},{depth:2,value:"Requirements and prerequisites",id:"requirements-and-prerequisites"},{depth:2,value:"Set up guide",id:"set-up-guide"},{depth:3,value:"Create a Fivetran Source.",id:"create-a-fivetran-source"},{depth:4,value:"A. Create a Fivetran Source using dbt packages for Fivetran.",id:"a-create-a-fivetran-source-using-dbt-packages-for-fivetran"},{depth:4,value:"B. Create a Fivetran Source without importing packages.",id:"b-create-a-fivetran-source-without-importing-packages"},{depth:3,value:"Create a new connection or use an existing connection.",id:"create-a-new-connection-or-use-an-existing-connection"},{depth:3,value:"Declare the Fivetran Connector ID, database and schema of your Fivetran tables.",id:"declare-the-fivetran-connector-id-database-and-schema-of-your-fivetran-tables"},{depth:3,value:"Verify selected tables and columns.",id:"verify-selected-tables-and-columns"},{depth:3,value:"Commit your changes.",id:"commit-your-changes"},{depth:2,value:"Considerations",id:"considerations"}];function h(e){let t=Object.assign({h1:"h1",p:"p",h2:"h2",a:"a",ul:"ul",li:"li",strong:"strong",h3:"h3",h4:"h4",code:"code"},(0,r.a)(),e.components);return l||m("CH",!1),l.Code||m("CH.Code",!0),c.zH||m("FileTree",!1),c.zH.Folder||m("FileTree.Folder",!0),(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)("style",{dangerouslySetInnerHTML:{__html:'[data-ch-theme="material-theme-darker"] { --ch-t-colorScheme: dark;--ch-t-foreground: #EEFFFF;--ch-t-background: #212121;--ch-t-lighter-inlineBackground: #212121e6;--ch-t-editor-background: #212121;--ch-t-editor-foreground: #EEFFFF;
1--ch-t-editor-lineHighlightBackground: #00000050;--ch-t-editor-rangeHighlightBackground: #FFFFFF0d;--ch-t-editor-infoForeground: #3794FF;--ch-t-editor-selectionBackground: #61616150;--ch-t-focusBorder: #FFFFFF00;--ch-t-tab-activeBackground: #212121;--ch-t-tab-activeForeground: #FFFFFF;--ch-t-tab-inactiveBackground: #212121;--ch-t-tab-inactiveForeground: #616161;--ch-t-tab-border: #212121;--ch-t-tab-activeBorder: #80CBC4;--ch-t-editorGroup-border: #00000030;--ch-t-editorGroupHeader-tabsBackground: #212121;--ch-t-editorLineNumber-foreground: #424242;--ch-t-input-background: #2B2B2B;--ch-t-input-foreground: #EEFFFF;--ch-t-input-border: #FFFFFF10;--ch-t-icon-foreground: #C5C5C5;--ch-t-sideBar-background: #212121;--ch-t-sideBar-foreground: #616161;--ch-t-sideBar-border: #21212160;--ch-t-list-activeSelectionBackground: #212121;--ch-t-list-activeSelectionForeground: #80CBC4;--ch-t-list-hoverBackground: #212121;--ch-t-list-hoverForeground: #FFFFFF; }'}}),"\n","\n",(0,n.jsx)(t.h1,{children:"Fivetran"}),"\n",(0,n.jsx)(t.p,{children:"Trigger and manage Fivetran Connector syncs."}),"\n",(0,n.jsx)(c.Ee,{src:"/docs/screenshots/fivetran-cover-1.webp",alt:"Trigger Fivetran syncs out of Y42.",priority:!0}),"\n",(0,n.jsx)(t.h2,{id:"overview",children:"Overview"}),"\n",(0,n.jsx)(t.p,{children:"Y42 allows you to trigger and manage your Fivetran Connectors. Fivetran Source serves as a bridge between your Fivetran Connector and the Fivetran-produced tables within your data warehouse."}),"\n",(0,n.jsx)(t.h2,{id:"fivetran-source",children:"Fivetran Source"}),"\n",(0,n.jsx)(t.p,{children:"When a build is triggered, Y42 initiates a Sync request to Fivetran API, then monitors Sync status updates. Upon a successful sync, Y42 creates views for each updated Fivetran table, and subsequently triggers builds for any downstream assets, including data tests and models."}),"\n",(0,n.jsx)(t.h2,{id:"requirements-and-prerequisites",children:"Requirements and prerequisites"}),"\n",(0,n.jsxs)(t.p,{children:["Before setting up a Fivetran Source, you have to ",(0,n.jsx)(t.a,{href:"https://fivetran.com/docs/getting-started/fivetran-dashboard/connectors",children:"setup a Fivetran Connector"})," and initiate the first Sync. Your Fivetran Connector needs to be run at least once before the Connector can be triggered by Y42."]}),"\n",(0,n.jsx)(t.p,{children:"You will need to provide the following details during the setup process:"}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsxs)(t.li,{children:[(0,n.jsx)(t.strong,{children:"Connector ID"}),": A unique identifier generated by Fivetran for each Connector. This can be found under Connector > Setup."]}),"\n",(0,n.jsxs)(t.li,{children:[(0,n.jsx)(t.strong,{children:"API Key"}),": Can be generated under User > API Key."]}),"\n",(0,n.jsxs)(t.li,{children:[(0,n.jsx)(t.strong,{children:"API Secret"}),": Can be generated under User > API Key."]}),"\n",(0,n.jsxs)(t.li,{children:[(0,n.jsx)(t.strong,{children:"Project / Database"}),": The project / database of the Fivetran generated dataset / schema."]}),"\n",(0,n.jsxs)(t.li,{children:[(0,n.jsx)(t.strong,{children:"Dataset / Schema"})," The dataset / schema of the Fivetran generated tables."]}),"\n"]}),"\n",(0,n.jsx)(c.UW,{type:"info",children:"The Fivetran destination needs to be in the same project as the Y42 space. Furthermore, Fivetran tables should be in the same region as the Y42 space dataset and accessible by the Y42 space's service account. "}),"\n",(0,n.jsx)(t.h2,{id:"set-up-guide",children:"Set up guide"}),"\n",(0,n.jsxs)(c.Rg,{children:[(0,n.jsx)(t.h3,{id:"create-a-fivetran-source",children:"Create a Fivetran Source."}),(0,n.jsx)(t.p,{children:"You can choose to use dbt packages for Fivetran or set up your source without them."}),(0,n.jsx)(t.h4,{id:"a-create-a-fivetran-source-using-dbt-packages-for-fivetran",children:"A. Create a Fivetran Source using dbt packages for Fivetran."}),(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsxs)(t.li,{children:["Y42 facilitates the use of community-maintained ",(0,n.jsx)(t.a,{href:"https://hub.getdbt.com/fivetran/",children:"dbt packages for Fivetran"}),". To install these packages, open the ",(0,n.jsx)(t.code,{children:"packages.yml"})," file located in the root directory in code mode. Then, add the following entry to the yml file:"]}),"\n"]}),(0,n.jsx)(l.Code,{codeConfig:g,northPanel:{tabs:[""],active:"",heightRatio:1},files:[{name:"",focus:"",code:{lines:[{tokens:[{content:" - ",props:{style:{color:"#89DDFF"}}},{content:"package",props:{style:{color:"#F07178"}}},{content:": ",props:{style:{color:"#89DDFF"}}},{content:"fivetran/package_name",props:{style:{color:"#C3E88D"}}}]},{tokens:[{content:" version",props:{style:{color:"#F07178"}}},{content:": ",props:{style:{color:"#89DDFF"}}},{content:"x.xx.x",props:{style:{color:"#C3E88D"}}}]}],lang:"yml"},annotations:[]}]}),(0,n.jsxs)(t.p,{children:["Copy the name and version from the latest package description page, like the ",(0,n.jsx)(t.a,{href:"https://hub.getdbt.com/fivetran/google_ads/latest/",children:"Google Ads package"}),". For instance, add the following to the yml file:"]}),(0,n.jsx)(l.Code,{codeConfig:g,northPanel:{tabs:[""],active:"",heightRatio:1},files:[{name:"",focus:"",code:{lines:[{tokens:[{content:" - ",props:{style:{color:"#89DDFF"}}},{content:"package",props:{style:{color:"#F07178"}}},{content:": ",props:{style:{color:"#89DDFF"}}},{content:"fivetran/google_ads",props:{style:{color:"#C3E88D"}}}]},{tokens:[{content:" version",props:{style:{color:"#F07178"}}},{content:": ",props:{style:{color:"#89DDFF"}}},{content:"0.10.1",props:{style:{color:"#F78C6C"}}}]}],lang:"yml"},annotations:[]}]}),(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsxs)(t.li,{children:["\n",(0,n.jsxs)(t.p,{children:["Next, install the packages by pressing ",(0,n.jsx)("kbd",{children:"CMD"})," / ",(0,n.jsx)("kbd",{children:"CTRL"})," + ",(0,n.jsx)("kbd",{children:"K"})," and selecting ",(0,n.jsx)(t.strong,{children:"Install package dependencies"}),'. This will create a new "dbt_packages" folder in the catalogue, containing a folder for each installed package, along with all its dependencies.']}),"\n"]}),"\n",(0,n.jsxs)(t.li,{children:["\n",(0,n.jsxs)(t.p,{children:["Locate the source folder within a package folder under ",(0,n.jsx)(t.code,{children:"dbt_package"}),' folder in the Code view. The community maintaining Fivetran dbt packages typically names source folders with a "source" suffix (e.g., ',(0,n.jsx)(t.code,{children:"google_ads_source"})," or ",(0,n.jsx)(t.code,{children:"hubspot_source"}),")."]}),"\n"]}),"\n"]}),(0,n.jsxs)(c.UW,{type:"warning",children:["The ",(0,n.jsx)(t.code,{children:"dbt_packages"})," folder is git-ignored and is not under version control."]}),(0,n.jsx)(c.zH,{children:(0,n.jsx)(c.zH.Folder,{name:"y42",defaultOpen:!0,children:(0,n.jsxs)(c.zH.Folder,{name:"dbt_packages",defaultOpen:!0,children:[(0,n.jsx)(c.zH.Folder,{name:"google_ads",defaultOpen:!0}),(0,n.jsx)(c.zH.Folder,{name:"google_ads_source",defaultOpen:!0}),(0,n.jsx)(c.zH.Folder,{name:"hubspot",defaultOpen:!0}),(0,n.jsx)(c.zH.Folder,{name:"hubspot_source",defaultOpen:!0})]})})}),(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:'Finally, click on the desired source and select "External Fivetran." This links the source in the package with your Fivetran credentials, enabling API calls to the Fivetran API for initiating data syncs.'}),"\n"]}),(0,n.jsx)(t.h4,{id:"b-create-a-fivetran-source-without-importing-packages",children:"B. Create a Fivetran Source without importing packages."}),(0,n.jsx)(t.p,{children:'In the asset creation pop up, select "External Fivetran" and enter a unique name for the Fivetran Source.'}),(0,n.jsx)(c.Ee,{src:"/docs/screenshots/fivetran-add-new-1.webp",alt:"Add a new Fivetran source."}),(0,n.jsx)(t.h3,{id:"create-a-new-connection-or-use-an-existing-connection",children:"Create a new connection or use an existing connection."}),(0,n.jsx)(t.p,{children:"On the source setup page, on the Authorization panel, select from existing secrets or create a new one."}),(0,n.jsx)(c.Ee,{src:"/docs/screenshots/fivetran-create-conn.webp",alt:"Create new Fivetran connection."}),(0,n.jsxs)(t.p,{children:["To create a new secret, enter a unique name and provide ",(0,n.jsx)(t.a,{href:"https://fivetran.com/docs/rest-api/getting-started#instructions",children:"Fivetran API key and secret"}),"."]}),(0,n.jsx)(c.Ee,{src:"/docs/screenshots/fivetran-generate-api-key.webp",alt:"Generate a new Fivetran API key."}),(0,n.jsx)(t.h3,{id:"declare-the-fivetran-connector-id-database-and-schema-of-your-fivetran-tables",children:"Declare the Fivetran Connector ID, database and schema of your Fivetran tables."}),(0,n.jsx)(t.p,{children:"Open the settings tab and enter:"}),(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsxs)(t.li,{children:[(0,n.jsx)(t.code,{children:"Fivetran Connector ID"}),". Can be found under Connector > Setup section."]}),"\n",(0,n.jsxs)(t.li,{children:[(0,n.jsx)(t.code,{children:"Project / Database"})," and ",(0,n.jsx)(t.code,{children:"Dataset / Schema"})," of your Fivetran tables. Those are the properties of your DWH where Fivetran created tables after the initial sync."]}),"\n"]}),(0,n.jsx)(t.h3,{id:"verify-selected-tables-and-columns",children:"Verify selected tables and columns."}),(0,n.jsx)(t.p,{children:"Open the schema tab and verify that you are referencing the correct tables."}),(0,n.jsx)(c.UW,{children:"All tables and columns will be automatically imported and the selection cannot be changed."}),(0,n.jsx)(t.h3,{id:"commit-your-changes",children:"Commit your changes."})]}),"\n",(0,n.jsx)(t.h2,{id:"considerations",children:"Considerations"}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:"An individual Fivetran table build will automatically trigger builds for all tables of the Fivetran Connector. Fivetran does not allow individual table syncs."}),"\n",(0,n.jsx)(t.li,{children:"Failed data tests on Fivetran tables will only stop the DAG and not prevent any updates on the tables themselves."}),"\n"]})]})}function m(e,t){throw Error("Expected "+(t?"component":"object")+" `"+e+"` to be defined: you likely forgot to import, pass, or provide it.")}let p={MDXContent:function(){let e=arguments.length>0&&void 0!==arguments[0]?arguments[0]:{},{wrapper:t}=Object.assign({},(0,r.a)(),e.components);return t?(0,n.jsx)(t,{...e,children:(0,n.jsx)(h,{...e})}):h(e)},pageOpts:{filePath:"pages/fivetran-sources.mdx",route:"/fivetran-sources",pageMap:[{kind:"MdxPage",name:"404",route:"/404"},{kind:"Meta",data:{404:{title:"Page not found",display:"hidden",theme:{layout:"raw"}},index:{title:"Home",display:"hidden",theme:{pagination:!1,toc:!1}},home:{title:"â Y42.com",type:"page",href:"https://www.y42.com"},tutorials:{title:"Tutorials",type:"page",href:"/docs/tutorials",display:"hidden"},"api-reference":{title:"API reference",type:"page",href:"https://y42-public-api.readme.io/reference",newWindow:!0},login:{title:"Log in",type:"page",href:"https://y42.dev",newWindow:!0},_essentials:{title:"Essentials",type:"separator"},"getting-started":{title:"Getting started",theme:{collapsed:!0}}
1,"working-with-assets":"Working with assets",integrations:"Required integrations","version-control":"Version control","branch-environments":"Branch environments","_platform-interface":{title:"Platform interface",type:"separator"},"platform-interface-overview":"Overview","platform-interface-modes":"Modes","_ai-copilot":{title:"AI Copilot",type:"separator"},"ai-copilot-overview":"Overview","documentation-wizard":"Documentation Wizard","sql-completion":"SQL Completion","_ingesting-data":{title:"Ingesting data",type:"separator"},"ingesting-data-overview":"Overview","sql-ingestion-migration":{title:"SQL Ingstion Migration Guide",display:"hidden"},"cdata-connectors":"CData connectors","airbyte-connectors":"Airbyte connectors","fivetran-sources":"Fivetran sources","python-sources":"Python sources","csv-seeds":"CSV seeds","reference-data-from-data-warehouse":"Reference data from your data warehouse","_transforming-data":{title:"Transforming data with dbt",type:"separator"},"transforming-data-overview":"Overview","dbt-models":"Models",snapshots:"Snapshots",exposures:"Exposures",analyses:"Analyses","_testing-data-quality":{title:"Testing data quality",type:"separator"},"testing-data-overview":"Overview","column-tests":"Column tests","table-tests":"Table tests","data-diff":"Data diff","anomaly-detection-tests":"Anomaly detection","_automating-workflows":{title:"Automating workflows",type:"separator"},"scheduled-builds":"Run pipelines on a schedule","python-actions":"Sync with external workflows using Python",alerts:"Alerts","_monitoring-data-assets":{title:"Monitoring data assets",type:"separator"},"asset-health-status":"Asset health status","asset-health-dashboard":"Asset health dashboard","asset-health-history":"Asset health history","_managing-your-account":{title:"Managing your account",type:"separator"},"identity-and-access-management":"Identity and access management (IAM)",organizations:"Organizations",spaces:"Spaces","user-settings":"User settings","---":{type:"separator"},"behavior-changes":"Behavior changes"}},{kind:"MdxPage",name:"ai-copilot-overview",route:"/ai-copilot-overview"},{kind:"Folder",name:"airbyte-connectors",route:"/airbyte-connectors",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}}
1,applications:{title:"Applications",display:"hidden"},databases:{title:"Databases",display:"hidden"},"file-transfers":{title:"File transfers",display:"hidden"},others:{title:"Others",display:"hidden"},"amazon-ads":{title:"Amazon Ads"},bigquery:{title:"BigQuery"},"facebook-marketing":{title:"Facebook Marketing"},faker:{title:"Faker"},"file-import":{title:"File import"},gcs:{title:"Google Cloud Storage"},"google-ads":{title:"Google Ads"},"google-analytics-4":{title:"Google Analytics 4"},"google-sheets":{title:"Google Sheets"},hubspot:{title:"Hubspot"},jira:{title:"Jira"},mysql:{title:"MySQL"},mssql:{title:"MSSQL"},postgres:{title:"Postgres"},s3:{title:"S3"},salesforce:{title:"Salesforce"},shopify:{title:"Shopify"},stripe:{title:"Stripe"}}},{kind:"MdxPage",name:"amazon-ads",route:"/airbyte-connectors/amazon-ads"},{kind:"MdxPage",name:"bigquery",route:"/airbyte-connectors/bigquery"},{kind:"MdxPage",name:"facebook-marketing",route:"/airbyte-connectors/facebook-marketing"},{kind:"MdxPage",name:"faker",route:"/airbyte-connectors/faker"},{kind:"MdxPage",name:"file-import",route:"/airbyte-connectors/file-import"},{kind:"MdxPage",name:"gcs",route:"/airbyte-connectors/gcs"},{kind:"MdxPage",name:"google-ads",route:"/airbyte-connectors/google-ads"},{kind:"MdxPage",name:"google-analytics-4",route:"/airbyte-connectors/google-analytics-4"},{kind:"MdxPage",name:"google-sheets",route:"/airbyte-connectors/google-sheets"},{kind:"MdxPage",name:"hubspot",route:"/airbyte-connectors/hubspot"},{kind:"MdxPage",name:"jira",route:"/airbyte-connectors/jira"},{kind:"MdxPage",name:"mssql",route:"/airbyte-connectors/mssql"},{kind:"MdxPage",name:"mysql",route:"/airbyte-connectors/mysql"},{kind:"MdxPage",name:"postgres",route:"/airbyte-connectors/postgres"},{kind:"MdxPage",name:"s3",route:"/airbyte-connectors/s3"},{kind:"MdxPage",name:"salesforce",route:"/airbyte-connectors/salesforce"},{kind:"MdxPage",name:"shopify",route:"/airbyte-connectors/shopify"},{kind:"MdxPage",name:"stripe",route:"/airbyte-connectors/stripe"}]},{kind:"MdxPage",name:"airbyte-connectors",route:"/airbyte-connectors"},{kind:"MdxPage",name:"alerts",route:"/alerts"},{kind:"MdxPage",name:"analyses",route:"/analyses"},{kind:"Folder",name:"anomaly-detection-tests",route:"/anomaly-detection-tests",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"configure-anomaly-detection":"Configure anomaly detection","all-columns-anomalies":"All columns anomalies","anomaly-tests-parameters":"Anomaly tests parameters"}},{kind:"MdxPage",name:"all-columns-anomalies",route:"/anomaly-detection-tests/all-columns-anomalies"},{kind:"MdxPage",name:"anomaly-tests-parameters",route:"/anomaly-detection-tests/anomaly-tests-parameters"},{kind:"MdxPage",name:"configure-anomaly-detection",route:"/anomaly-detection-tests/configure-anomaly-detection"}]},{kind:"MdxPage",name:"anomaly-detection-tests",route:"/anomaly-detection-tests"},{kind:"MdxPage",name:"asset-health-dashboard",route:"/asset-health-dashboard"},{kind:"MdxPage",name:"asset-health-history",route:"/asset-health-history"},{kind:"MdxPage",name:"asset-health-status",route:"/asset-health-status"},{kind:"MdxPage",name:"behavior-changes",route:"/behavior-changes"},{kind:"Folder",name:"branch-environments",route:"/branch-environments",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"virtual-data-builds":"Virtual Data Builds","publish-assets":"Publish assets","continuous-integration":"Continuous integration (CI)","custom-schemas-databases":"Building into custom schemas or databases"}},{kind:"MdxPage",name:"continuous-integration",route:"/branch-environments/continuous-integration"},{kind:"MdxPage",name:"custom-schemas-databases",route:"/branch-environments/custom-schemas-databases"},{kind:"MdxPage",name:"publish-assets",route:"/branch-environments/publish-assets"},{kind:"MdxPage",name:"virtual-data-builds",route:"/branch-environments/virtual-data-builds"}]},{kind:"MdxPage",name:"branch-environments",route:"/branch-environments"},{kind:"Folder",name:"cdata-connectors",route:"/cdata-connectors",children:[{kind:"Meta",data:{"api-aircall":"AirCall",airtable:"Airtable",bigquery:"BigQuery","bing-ads":"Bing Ads",facebook:"Facebook","facebook-ads":"Facebook Ads","google-ads":"Google Ads","google-analytics":"Google Analytics","google-sheets":"Google Sheets",hubspot:"Hubspot",db2:"IBM DB2",instagram:"Instagram",linkedin:"LinkedIn",linkedinads:"LinkedIn Ads",mariadb:"MariaDB",mongodb:"MongoDB",mysql:"MySQL",pinterest:"Pinterest",postgres:"Postgres",salesforce:"Salesforce",snapchatads:"Snapchat Marketing",shopify:"Shopify",snowflake:"Snowflake",stripe:"Stripe","youtube-analytics":"YouTube Analytics",zendesk:"Zendesk"}},{kind:"MdxPage",name:"airtable",route:"/cdata-connectors/airtable"},{kind:"MdxPage",name:"api-aircall",route:"/cdata-connectors/api-aircall"},{kind:"MdxPage",name:"bigquery",route:"/cdata-connectors/bigquery"},{kind:"MdxPage",name:"bing-ads",route:"/cdata-connectors/bing-ads"},{kind:"MdxPage",name:"db2",route:"/cdata-connectors/db2"},{kind:"MdxPage",name:"facebook-ads",route:"/cdata-connectors/facebook-ads"},{kind:"MdxPage",name:"facebook",route:"/cdata-connectors/facebook"},{kind:"MdxPage",name:"google-ads",route:"/cdata-connectors/google-ads"},{kind:"MdxPage",name:"google-analytics",route:"/cdata-connectors/google-analytics"},{kind:"MdxPage",name:"google-sheets",route:"/cdata-connectors/google-sheets"},{kind:"MdxPage",name:"hubspot",route:"/cdata-connectors/hubspot"},{kind:"MdxPage",name:"instagram",route:"/cdata-connectors/instagram"},{kind:"MdxPage",name:"linkedin",route:"/cdata-connectors/linkedin"},{kind:"MdxPage",name:"linkedinads",route:"/cdata-connectors/linkedinads"},{kind:"MdxPage",name:"mariadb",route:"/cdata-connectors/mariadb"},{kind:"MdxPage",name:"mongodb",route:"/cdata-connectors/mongodb"},{kind:"MdxPage",name:"mysql",route:"/cdata-connectors/mysql"},{kind:"MdxPage",name:"pinterest",route:"/cdata-connectors/pinterest"},{kind:"MdxPage",name:"postgres",route:"/cdata-connectors/postgres"},{kind:"MdxPage",name:"salesforce",route:"/cdata-connectors/salesforce"},{kind:"MdxPage",name:"shopify",route:"/cdata-connectors/shopify"},{kind:"MdxPage",name:"snapchatads",route:"/cdata-connectors/snapchatads"},{kind:"MdxPage",name:"snowflake",route:"/cdata-connectors/snowflake"},{kind:"MdxPage",name:"stripe",route:"/cdata-connectors/stripe"},{kind:"MdxPage",name:"youtube-analytics",route:"/cdata-connectors/youtube-analytics"},{kind:"MdxPage",name:"zendesk",route:"/cdata-connectors/zendesk"}]},{kind:"MdxPage",name:"cdata-connectors",route:"/cdata-connectors"},{kind:"MdxPage",name:"column-tests",route:"/column-tests"},{kind:"MdxPage",name:"csv-seeds",route:"/csv-seeds"},{kind:"MdxPage",name:"data-diff",route:"/data-diff"},{kind:"Folder",name:"dbt-models",route:"/dbt-models",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}
1},"create-a-dbt-model":"Create a dbt model","materialization-types":"Materialization types","incremental-models":"Incremental models",macros:"Macros",packages:"Packages",hooks:"Hooks",jinja:"Jinja templating","sql-fluff":"Linting with SQLFluff","generate-staging-models":"Generate staging models","bigquery-partitioning-and-clustering":"BigQuery partitioning and clustering","sql-header":"Configure SQL before model execution","preview-changes-locally":"Preview changes locally"}},{kind:"MdxPage",name:"bigquery-partitioning-and-clustering",route:"/dbt-models/bigquery-partitioning-and-clustering"},{kind:"MdxPage",name:"create-a-dbt-model",route:"/dbt-models/create-a-dbt-model"},{kind:"MdxPage",name:"generate-staging-models",route:"/dbt-models/generate-staging-models"},{kind:"MdxPage",name:"hooks",route:"/dbt-models/hooks"},{kind:"MdxPage",name:"incremental-models",route:"/dbt-models/incremental-models"},{kind:"MdxPage",name:"jinja",route:"/dbt-models/jinja"},{kind:"MdxPage",name:"macros",route:"/dbt-models/macros"},{kind:"MdxPage",name:"materialization-types",route:"/dbt-models/materialization-types"},{kind:"MdxPage",name:"packages",route:"/dbt-models/packages"},{kind:"MdxPage",name:"preview-changes-locally",route:"/dbt-models/preview-changes-locally"},{kind:"MdxPage",name:"sql-fluff",route:"/dbt-models/sql-fluff"},{kind:"MdxPage",name:"sql-header",route:"/dbt-models/sql-header"}]},{kind:"MdxPage",name:"dbt-models",route:"/dbt-models"},{kind:"MdxPage",name:"documentation-wizard",route:"/documentation-wizard"},{kind:"MdxPage",name:"exposures",route:"/exposures"},{kind:"MdxPage",name:"fivetran-sources",route:"/fivetran-sources"},{kind:"Folder",name:"getting-started",route:"/getting-started",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"account-setup":{title:"1. Set up an account"},"create-a-space":{title:"2. Create a space"},"ingest-data":{title:"3. Ingest data"},"transform-data":{title:"4. Transform data"},"schedule-build":{title:"5. Schedule a build"},"merge-changes":{title:"6. Merge changes"}}},{kind:"MdxPage",name:"account-setup",route:"/getting-started/account-setup"},{kind:"Folder",name:"create-a-space",route:"/getting-started/create-a-space",children:[{kind:"Meta",data:{"bigquery-gcp":{title:"BigQuery and Google Cloud Storage"},"snowflake-aws":{title:"Snowflake and Amazon Web Services S3"},"snowflake-azure":{title:"Snowflake and Azure Blob Storage"},snowflake:{display:"hidden",title:"Snowflake"}}},{kind:"MdxPage",name:"bigquery-gcp",route:"/getting-started/create-a-space/bigquery-gcp"},{kind:"MdxPage",name:"snowflake-aws",route:"/getting-started/create-a-space/snowflake-aws"},{kind:"MdxPage",name:"snowflake-azure",route:"/getting-started/create-a-space/snowflake-azure"},{kind:"MdxPage",name:"snowflake",route:"/getting-started/create-a-space/snowflake"}]},{kind:"MdxPage",name:"create-a-space",route:"/getting-started/create-a-space"},{kind:"MdxPage",name:"ingest-data",route:"/getting-started/ingest-data"},{kind:"MdxPage",name:"merge-changes",route:"/getting-started/merge-changes"},{kind:"MdxPage",name:"schedule-build",route:"/getting-started/schedule-build"},{kind:"MdxPage",name:"transform-data",route:"/getting-started/transform-data"}]},{kind:"MdxPage",name:"getting-started",route:"/getting-started"},{kind:"Folder",name:"identity-and-access-management",route:"/identity-and-access-management",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"invite-users":"Invite users to an organization","invitation-policy":"Set organization invitation policy","manage-roles":"Manage roles","api-keys":"API keys","single-sign-on":"Single sign-on (SSO)","two-factor-authentication":"Two-factor authentication (2FA)"}},{kind:"MdxPage",name:"api-keys",route:"/identity-and-access-management/api-keys"},{kind:"MdxPage",name:"invitation-policy",route:"/identity-and-access-management/invitation-policy"},{kind:"MdxPage",name:"invite-users",route:"/identity-and-access-management/invite-users"},{kind:"MdxPage",name:"manage-roles",route:"/identity-and-access-management/manage-roles"},{kind:"Folder",name:"single-sign-on",route:"/identity-and-access-management/single-sign-on",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}
1},okta:"Okta",saml:"SAML",oauth2:"OAuth2"}},{kind:"MdxPage",name:"oauth2",route:"/identity-and-access-management/single-sign-on/oauth2"},{kind:"MdxPage",name:"okta",route:"/identity-and-access-management/single-sign-on/okta"},{kind:"MdxPage",name:"saml",route:"/identity-and-access-management/single-sign-on/saml"}]},{kind:"MdxPage",name:"single-sign-on",route:"/identity-and-access-management/single-sign-on"},{kind:"MdxPage",name:"two-factor-authentication",route:"/identity-and-access-management/two-factor-authentication"}]},{kind:"MdxPage",name:"index",route:"/"},{kind:"Folder",name:"ingesting-data-overview",route:"/ingesting-data-overview",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},secrets:"Secrets","sync-modes":"Sync modes","source-data-freshness":"Source data freshness","ip-whitelist":"IP address whitelist"}},{kind:"MdxPage",name:"ip-whitelist",route:"/ingesting-data-overview/ip-whitelist"},{kind:"MdxPage",name:"secrets",route:"/ingesting-data-overview/secrets"},{kind:"MdxPage",name:"source-data-freshness",route:"/ingesting-data-overview/source-data-freshness"},{kind:"MdxPage",name:"sync-modes",route:"/ingesting-data-overview/sync-modes"}]},{kind:"MdxPage",name:"ingesting-data-overview",route:"/ingesting-data-overview"},{kind:"Folder",name:"integrations",route:"/integrations",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"data-warehouse":"Data warehouse","git-repository":"Git repository"}},{kind:"MdxPage",name:"data-warehouse",route:"/integrations/data-warehouse"},{kind:"Folder",name:"git-repository",route:"/integrations/git-repository",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"connect-github-repository":"Connect your GitHub repository","connect-gitlab-repository":"Connect your GitLab repository"}},{kind:"MdxPage",name:"connect-github-repository",route:"/integrations/git-repository/connect-github-repository"},{kind:"MdxPage",name:"connect-gitlab-repository",route:"/integrations/git-repository/connect-gitlab-repository"}]},{kind:"MdxPage",name:"git-repository",route:"/integrations/git-repository"}]},{kind:"Folder",name:"organizations",route:"/organizations",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"customize-your-organization":"Customize your organization","delete-an-organization":"Delete an organization"}},{kind:"MdxPage",name:"customize-your-organization",route:"/organizations/customize-your-organization"},{kind:"MdxPage",name:"delete-an-organization",route:"/organizations/delete-an-organization"}]},{kind:"Folder",name:"platform-interface-modes",route:"/platform-interface-modes",children:[{kind:"Meta",data:{"asset-list":"Asset list","code-editor":"Code editor",lineage:"Lineage","asset-catalog":"Asset catalog"}},{kind:"MdxPage",name:"asset-catalog",route:"/platform-interface-modes/asset-catalog"},{kind:"MdxPage",name:"asset-list",route:"/platform-interface-modes/asset-list"},{kind:"MdxPage",name:"code-editor",route:"/platform-interface-modes/code-editor"},{kind:"MdxPage",name:"lineage",route:"/platform-interface-modes/lineage"}]},{kind:"MdxPage",name:"platform-interface-modes",route:"/platform-interface-modes"},{kind:"MdxPage",name:"platform-interface-overview",route:"/platform-interface-overview"},{kind:"Folder",name:"python-actions",route:"/python-actions",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"sync-data-with-census":"Sync data with Census","sync-data-with-hightouch":"Sync data with Hightouch","send-slack-notifications":"Send Slack notifications"}},{kind:"MdxPage",name:"send-slack-notifications",route:"/python-actions/send-slack-notifications"},{kind:"MdxPage",name:"sync-data-with-census",route:"/python-actions/sync-data-with-census"},{kind:"MdxPage",name:"sync-data-with-hightouch",route:"/python-actions/sync-data-with-hightouch"}]},{kind:"MdxPage",name:"python-actions",route:"/python-actions"},{kind:"MdxPage",name:"python-sources",route:"/python-sources"},{kind:"MdxPage",name:"reference-data-from-data-warehouse",route:"/reference-data-from-data-warehouse"},{kind:"MdxPage",name:"scheduled-builds",route:"/scheduled-builds"},{kind:"MdxPage",name:"snapshots",route:"/snapshots"},{kind:"Folder",name:"spaces",route:"/spaces",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}
1},"create-a-space":{title:"Create a space",href:"/getting-started/create-a-space"},"customize-a-space":"Customize a space","configure-space-integrations":"Configure space integrations","automatically-delete-unused-tables":"Automatically delete unused tables","delete-a-space":"Delete a space",secrets:{title:"Secrets",href:"/ingesting-data-overview/secrets"}}},{kind:"MdxPage",name:"automatically-delete-unused-tables",route:"/spaces/automatically-delete-unused-tables"},{kind:"MdxPage",name:"configure-space-integrations",route:"/spaces/configure-space-integrations"},{kind:"MdxPage",name:"customize-a-space",route:"/spaces/customize-a-space"},{kind:"MdxPage",name:"delete-a-space",route:"/spaces/delete-a-space"}]},{kind:"MdxPage",name:"sql-completion",route:"/sql-completion"},{kind:"MdxPage",name:"sql-ingestion-migration",route:"/sql-ingestion-migration"},{kind:"MdxPage",name:"table-tests",route:"/table-tests"},{kind:"MdxPage",name:"testing-data-overview",route:"/testing-data-overview"},{kind:"MdxPage",name:"transforming-data-overview",route:"/transforming-data-overview"},{kind:"Folder",name:"user-settings",route:"/user-settings",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"configure-user-profile":"Configure user profile","secure-your-user-account":"Secure your user account","manage-linked-identities":"Managed linked Git identities","customize-user-interface":"Customize user interface","delete-user-account":"Delete your user account"}},{kind:"MdxPage",name:"configure-user-profile",route:"/user-settings/configure-user-profile"},{kind:"MdxPage",name:"customize-user-interface",route:"/user-settings/customize-user-interface"},{kind:"MdxPage",name:"delete-user-account",route:"/user-settings/delete-user-account"},{kind:"MdxPage",name:"manage-linked-identities",route:"/user-settings/manage-linked-identities"},{kind:"MdxPage",name:"secure-your-user-account",route:"/user-settings/secure-your-user-account"}]},{kind:"MdxPage",name:"user-settings",route:"/user-settings"},{kind:"Folder",name:"version-control",route:"/version-control",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"commit-changes":"Commit changes","stash-changes":"Stash changes","revert-changes":"Revert changes","working-with-branches":"Working with branches","pull-requests":"Pull requests"}},{kind:"MdxPage",name:"commit-changes",route:"/version-control/commit-changes"},{kind:"MdxPage",name:"pull-requests",route:"/version-control/pull-requests"},{kind:"MdxPage",name:"revert-changes",route:"/version-control/revert-changes"},{kind:"MdxPage",name:"stash-changes",route:"/version-control/stash-changes"},{kind:"MdxPage",name:"working-with-branches",route:"/version-control/working-with-branches"}]},{kind:"Folder",name:"working-with-assets",route:"/working-with-assets",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"project-configuration":"Project configuration","stateful-data-assets":"Stateful assets","asset-properties":"Asset properties","selecting-assets-to-run":"Selecting assets to run","development-modes":"Development modes"}},{kind:"MdxPage",name:"asset-properties",route:"/working-with-assets/asset-properties"},{kind:"MdxPage",name:"development-modes",route:"/working-with-assets/development-modes"},{kind:"MdxPage",name:"project-configuration",route:"/working-with-assets/project-configuration"},{kind:"Folder",name:"selecting-assets-to-run",route:"/working-with-assets/selecting-assets-to-run",children:[{kind:"Meta",data:{"*":{theme:{pagination:!0}},"build-command-examples":"Build command examples","yaml-selectors":"YAML selectors"}},{kind:"MdxPage",name:"build-command-examples",route:"/working-with-assets/selecting-assets-to-run/build-command-examples"},{kind:"MdxPage",name:"yaml-selectors",route:"/working-with-assets/selecting-assets-to-run/yaml-selectors"}]},{kind:"MdxPage",name:"selecting-assets-to-run",route:"/working-with-assets/selecting-assets-to-run"},{kind:"MdxPage",name:"stateful-data-assets",route:"/working-with-assets/stateful-data-assets"}]},{kind:"MdxPage",name:"working-with-assets",route:"/working-with-assets"}],flexsearch:{codeblocks:!0},title:"Fivetran",headings:u},pageNextRoute:"/fivetran-sources",nextraLayout:i.ZP,themeConfig:s.Z};t.default=(0,o.j)(p)}},function(e){e.O(0,[3273,4996,9006,2493,7507,6344,2888,9774,179],function(){return e(e.s=55016)}),_N_E=e.O()}]);
Line numbers count LF bytes from the start of the resource, as the search results do. Vendor segments are library code the classifier recognised; they are stored but not indexed. Bytes are shown as Latin1 characters, one per byte.