https://www.y42.com/docs/_next/static/chunks/pages/airbyte-connectors/google-ads-a4235b464a54898c.js

1(self.webpackChunk_N_E=self.webpackChunk_N_E||[]).push([[8546],{43769:function(e,t,a){(window.__NEXT_P=window.__NEXT_P||[]).push(["/airbyte-connectors/google-ads",function(){return a(99059)}])},99059:function(e,t,a){"use strict";a.r(t),a.d(t,{__toc:function(){return d}});var n=a(52322),o=a(28287),s=a(20337),i=a(93988);a(58614);var r=a(71199);let d=[{depth:2,value:"Overview",id:"overview"},{depth:3,value:"Features",id:"features"},{depth:3,value:"Supported streams",id:"supported-streams"},{depth:2,value:"Requirements and prerequisites",id:"requirements-and-prerequisites"},{depth:3,value:"Set up guide",id:"set-up-guide"},{depth:3,value:"Performance considerations",id:"performance-considerations"},{depth:3,value:"Limitations",id:"limitations"}];function c(e){let t=Object.assign({h1:"h1",h2:"h2",p:"p",h3:"h3",table:"table",thead:"thead",tr:"tr",th:"th",tbody:"tbody",td:"td",ul:"ul",li:"li",a:"a",code:"code",ol:"ol",strong:"strong"},(0,r.a)(),e.components);return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)(t.h1,{children:"Google Ads"}),"\n",(0,n.jsx)(t.h2,{id:"overview",children:"Overview"}),"\n",(0,n.jsx)(t.p,{children:"This page contains the setup guide and reference information for the Google Ads source."}),"\n",(0,n.jsx)(t.h3,{id:"features",children:"Features"}),"\n",(0,n.jsxs)(t.table,{children:[(0,n.jsx)(t.thead,{children:(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.th,{children:"Feature Name"}),(0,n.jsx)(t.th,{children:"Supported"})]})}),(0,n.jsxs)(t.tbody,{children:[(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"Full Import"}),(0,n.jsx)(t.td,{children:"Yes"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"Incremental Import"}),(0,n.jsx)(t.td,{children:"Yes"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"Start Date Selection"}),(0,n.jsx)(t.td,{children:"Yes"})]}),(0,n.jsxs)(t.tr,{children:[(0,n.jsx)(t.td,{children:"End Date Selection"}),(0,n.jsx)(t.td,{children:"Yes"})]})]})]}),"\n",(0,n.jsx)(t.h3,{id:"supported-streams",children:"Supported streams"}),"\n",(0,n.jsx)(t.p,{children:"Main Tables"}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/customer",children:"accounts"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/ad_group_ad",children:"ad_group_ads"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/ad_group_ad_label",children:"ad_group_ad_labels"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/ad_group",children:"ad_groups"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/ad_group_label",children:"ad_group_labels"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/campaign_label",children:"campaign_labels"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/reference/rpc/v11/ClickView",children:"click_view"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/keyword_view",children:"keyword"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/geographic_view",children:"geographic"})}),"\n"]}),"\n",(0,n.jsxs)(t.p,{children:["Note that ",(0,n.jsx)(t.code,{children:"ad_groups"}),", ",(0,n.jsx)(t.code,{children:"ad_group_ads"}),", and ",(0,n.jsx)(t.code,{children:"campaigns"})," contain a ",(0,n.jsx)(t.code,{children:"labels"})," field, which should be joined against their respective ",(0,n.jsx)(t.code,{children:"*_labels"})," streams if you want to view the actual labels. For example, the ",(0,n.jsx)(t.code,{children:"ad_groups"})," stream contains an ",(0,n.jsx)(t.code,{children:"ad_group.labels"})," field, which you would join against the ",(0,n.jsx)(t.code,{children:"ad_group_labels"})," stream's ",(0,n.jsx)(t.code,{children:"label.resource_name"})," field."]}),"\n",(0,n.jsx)(t.p,{children:"Report Tables"}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/campaign",children:"campaigns"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/docs/migration/mapping#account_performance",children:"account_performance_report"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/docs/migration/mapping#ad_performance",children:"ad_group_ad_report"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/docs/migration/mapping#display_keyword_performance",children:"display_keyword_report"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/docs/migration/mapping#display_topics_performance",children:"display_topics_report"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/docs/migration/mapping#shopping_performance",children:"shopping_performance_report"})}),"\n",(0,n.jsx)(t.li,{children:(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/user_location_view",children:"user_location_report"})}),"\n"]}),"\n",(0,n.jsx)(t.h2,{id:"requirements-and-prerequisites",children:"Requirements and prerequisites"}),"\n",(0,n.jsxs)(t.p,{children:["A ",(0,n.jsx)(t.a,{href:"https://support.google.com/google-ads/answer/6366720",children:"Google Ads Account"})," ",(0,n.jsx)(t.a,{href:"https://support.google.com/google-ads/answer/7459601",children:"linked"})," to a ",(0,n.jsx)(t.a,{href:"https://ads.google.com/home/tools/manager-accounts/",children:"Google Ads Manager account"})]}),"\n",(0,n.jsx)(t.h3,{id:"set-up-guide",children:"Set up guide"}),"\n",(0,n.jsxs)(t.ol,{children:["\n",(0,n.jsxs)(t.li,{children:["Create a new source, enter a ",(0,n.jsx)(t.strong,{children:"Name"}),' for it and select "Google Ads (Airbyte)" from a source type list, then click ',(0,n.jsx)(t.strong,{children:"Create"})]}),"\n",(0,n.jsx)(t.li,{children:"Create a new source for Google Ads for the previously created source."}),"\n",(0,n.jsxs)(t.li,{children:["Enter a comma-separated list of the ",(0,n.jsx)(t.a,{href:"https://support.google.com/google-ads/answer/1704344",children:"Customer ID(s)"})," for your account. The format is a 10-digit number ",(0,n.jsx)(t.strong,{children:"without"})," dashes."]}),"\n",(0,n.jsxs)(t.li,{children:["Enter the ",(0,n.jsx)(t.strong,{children:"Start Date"})," in YYYY-MM-DD format. The data added on and after this date will be replicated. If this field is blank, all data will be replicated."]}),"\n",(0,n.jsxs)(t.li,{children:["(Optional) If the access to your account is through a ",(0,n.jsx)(t.a,{href:"https://ads.google.com/home/tools/manager-accounts/",children:"Google Ads Manager account"}),", enter the ",(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/docs/concepts/call-structure#cid",children:(0,n.jsx)(t.strong,{children:"Login Customer ID for Managed Accounts"})})," of the Google Ads Manager account."]}),"\n",(0,n.jsxs)(t.li,{children:["(Optional) Enter a ",(0,n.jsx)(t.a,{href:"https://support.google.com/google-ads/answer/3123169?hl=en",children:(0,n.jsx)(t.strong,{children:"Conversion Window"})}),"."]}),"\n",(0,n.jsxs)(t.li,{children:["(Optional) Enter the ",(0,n.jsx)(t.strong,{children:"End Date"})," in YYYY-MM-DD format. The data added after this date will not be replicated."]}),"\n"]}),"\n",(0,n.jsx)(t.h3,{id:"performance-considerations",children:"Performance considerations"}),"\n",(0,n.jsxs)(t.p,{children:["This source is constrained by the ",(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/docs/best-practices/quotas",children:"Google Ads API limits"}),"."]}),"\n",(0,n.jsx)(t.p,{children:"Due to a limitation in the Google Ads API which does not allow getting performance data at a granularity level smaller than a day, the Google Ads connector usually pulls data up until the previous day. For example, if the sync runs on Wednesday at 5 PM, then data up until Tuesday midnight is pulled. Data for Wednesday is exported only if a sync runs after Wednesday (for example, 12:01 AM on Thursday) and s

1o on. This avoids syncing partial performance data, only to have to resync it again once the full day's data has been recorded by Google. For example, without this functionality, a sync which runs on Wednesday at 5 PM would get ads performance data for Wednesday between 12:01 AM - 5 PM on Wednesday, then it would need to run again at the end of the day to get all of Wednesday's data."}),"\n",(0,n.jsx)(t.h3,{id:"limitations",children:"Limitations"}),"\n",(0,n.jsxs)(t.ul,{children:["\n",(0,n.jsx)(t.li,{children:"Usage of Conversion Window may lead to duplicates in Incremental Sync, because connector is forced to read data in the given range."}),"\n",(0,n.jsxs)(t.li,{children:["Due to Google Ads API constraints, the ",(0,n.jsx)(t.code,{children:"click_view"})," stream retrieves data one day at a time and can only retrieve data newer than 90 days ago. Also, ",(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/metrics",children:"metrics"})," cannot be requested for a Google Ads Manager account. Report streams are only available when pulling data from a non-manager account."]}),"\n",(0,n.jsxs)(t.li,{children:["For incremental streams, data is synced up to the previous day using your Google Ads account time zone since Google Ads can filter data only by ",(0,n.jsx)(t.a,{href:"https://developers.google.com/google-ads/api/fields/v11/ad_group_ad#segments.date",children:"date"})," without time. Also, some reports cannot load data real-time due to Google Ads ",(0,n.jsx)(t.a,{href:"https://support.google.com/google-ads/answer/2544985?hl=en",children:"limitations"}),"."]}),"\n"]})]})}let l={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)(c,{...e})}):c(e)},pageOpts:{filePath:"pages/airbyte-connectors/google-ads.mdx",route:"/airbyte-connectors/google-ads",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}},"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:"Google Ads",headings:d},pageNextRoute:"/airbyte-connectors/google-ads",nextraLayout:s.ZP,themeConfig:i.Z};t.default=(0,o.j)(l)},93988:function(e,t,a){"use strict";a.d(t,{Z:function(){return i}});var n=a(52322),o=a(20337),s=a(56788),i={head:()=>{let{frontMatter:e}=(0,o.ZR)();return(0,n.jsxs)(n.Fragment,{children:[(0,n.jsx)("meta",{name:"viewport",content:"width=device-width, initial-scale=1.0"}),(0,n.jsx)("link",{rel:"apple-touch-icon",sizes:"180x180",href:"/docs/favicon/apple-touch-icon.png"}),(0,n.jsx)("link",{rel:"icon",type:"image/png",sizes:"32x32",href:"/docs/favicon/favicon-32x32.png"}),(0,n.jsx)("link",{rel:"icon",type:"image/png",sizes:"16x16",href:"/docs/favicon/favicon-16x16.png"}),(0,n.jsx)("link",{rel:"shortcut icon",href:"/docs/favicon/favicon.ico"}),(0,n.jsx)("meta",{name:"msapplication-TileColor",content:"#111111"}),(0,n.jsx)("meta",{property:"og:type",content:"website"}),(0,n.jsx)("meta",{property:"og:locale",content:"en_US"}),(0,n.jsx)("meta",{property:"og:site_name",content:"Y42 Docs"}),e.image?(0,n.jsx)("meta",{property:"og:image",content:e.image}):null,e.video?(0,n.jsx)("meta",{property:"og:video",content:e.video}):null]})},useNextSeoProps:()=>({titleTemplate:"%s | Y42 Docs"}),logo:(0,n.jsx)(e=>{let{height:t="22px",...a}=e;return(0,n.jsxs)("svg",{xmlns:"http://www.w3.org/2000/svg",fill:"none",viewBox:"0 0 230 26",height:t,...a,children:[(0,n.jsx)("path",{fill:"#742BF2",d:"M8.32 16.195a12.1 12.1 0 013.917 8.921h11.447c0-7.455-3.485-14.1-8.923-18.415L8.32 16.195zM11.826 4.71A23.681 23.681 0 000 1.57v11.38c1.935 0 3.766.447 5.393 1.243l6.433-9.482z"}),(0,n.jsx)("path",{fill:"#EB864D",d:"M18.947 4.71c0 2.6 2.121 4.709 4.737 4.709s4.737-2.109 4.737-4.71c0-2.6-2.12-4.709-4.737-4.709-2.616 0-4.737 2.108-4.737 4.71z"}),(0,n.jsx)("path",{fill:"#fff",d:"M97.105 1.57h16.579c3.488 0 6.316 2.811 6.316 6.279v1.57c0 3.467-2.828 6.279-6.316 6.279h-12.631v4.709H120v4.71H96.316v-7.85c0-3.467 2.828-6.279 6.316-6.279h12.631V6.28H97.105V1.57zM61.579 1.57h-4.737v9.418h-14.21V1.57h-4.737v7.849c0 3.467 2.827 6.279 6.316 6.279h3.157v9.418h4.737v-9.418h3.158c3.488 0 6.316-2.812 6.316-6.28V1.57zM90 1.57h-4.737v9.418h-14.21V1.57h-4.737v7.849c0 3.467 2.828 6.279 6.316 6.279h12.631v9.418H90v-9.418h3.158v-4.71H90V1.57z"}),(0,n.jsx)("path",{stroke:"#56555B",d:"M140.5 0L140.5 25.116"}),(0,n.jsx)("path",{fill:"#BEBDBF",d:"M168.83 22.558h-6.593V2.194h6.801c1.996 0 3.709.408 5.141 1.223 1.432.81 2.529 1.973 3.291 3.49.769 1.512 1.154 3.325 1.154 5.44 0 2.12-.388 3.944-1.164 5.468-.769 1.525-1.882 2.698-3.341 3.52-1.458.815-3.221 1.223-5.289 1.223zm-3.52-2.685h3.351c1.551 0 2.84-.291 3.867-.875 1.028-.59 

11.797-1.441 2.307-2.555.511-1.12.766-2.486.766-4.097 0-1.597-.255-2.953-.766-4.066-.504-1.114-1.256-1.96-2.257-2.536-1.001-.577-2.244-.865-3.729-.865h-3.539v14.994zm23.889 2.993c-1.432 0-2.681-.328-3.749-.984-1.067-.656-1.896-1.574-2.486-2.754-.589-1.18-.884-2.559-.884-4.137 0-1.584.295-2.97.884-4.156.59-1.186 1.419-2.108 2.486-2.764 1.068-.656 2.317-.984 3.749-.984s2.681.328 3.748.984c1.068.656 1.896 1.578 2.486 2.764.59 1.187.885 2.572.885 4.156 0 1.578-.295 2.957-.885 4.137-.59 1.18-1.418 2.098-2.486 2.754-1.067.656-2.316.984-3.748.984zm.01-2.495c.928 0 1.697-.246 2.307-.736.609-.49 1.06-1.144 1.352-1.959.298-.815.447-1.713.447-2.695 0-.974-.149-1.869-.447-2.684-.292-.822-.743-1.482-1.352-1.979-.61-.497-1.379-.746-2.307-.746-.935 0-1.71.249-2.327.746-.61.497-1.064 1.157-1.362 1.979-.292.815-.438 1.71-.438 2.684 0 .982.146 1.88.438 2.695.298.815.752 1.468 1.362 1.959.617.49 1.392.736 2.327.736zm17.421 2.495c-1.478 0-2.751-.334-3.818-1.004-1.061-.676-1.876-1.607-2.446-2.794-.57-1.187-.855-2.545-.855-4.077 0-1.55.291-2.92.875-4.106.583-1.193 1.405-2.125 2.466-2.794 1.06-.67 2.31-1.004 3.748-1.004 1.16 0 2.194.215 3.102.646.909.424 1.641 1.02 2.198 1.79.563.768.898 1.667 1.004 2.694h-2.893a3.467 3.467 0 00-1.094-1.85c-.564-.516-1.319-.775-2.267-.775-.829 0-1.555.219-2.178.656-.616.431-1.097 1.048-1.441 1.85-.345.795-.518 1.737-.518 2.824 0 1.113.169 2.075.508 2.883.338.809.815 1.435 1.431 1.88.623.444 1.356.666 2.198.666.563 0 1.074-.103 1.531-.308a3.122 3.122 0 001.163-.905c.319-.391.541-.862.667-1.412h2.893a5.62 5.62 0 01-.964 2.645c-.537.775-1.257 1.385-2.158 1.83-.895.443-1.946.665-3.152.665zm21.458-11.852l-2.695.477a3.162 3.162 0 00-.537-.984 2.65 2.65 0 00-.974-.766c-.411-.199-.925-.298-1.541-.298-.842 0-1.545.189-2.108.567-.564.371-.845.852-.845 1.442 0 .51.189.921.567 1.232.377.312.987.567 1.829.766l2.426.557c1.405.325 2.453.825 3.142 1.501.69.677 1.034 1.555 1.034 2.635 0 .915-.265 1.73-.795 2.446-.524.71-1.256 1.267-2.198 1.67-.934.405-2.018.607-3.251.607-1.71 0-3.106-.364-4.186-1.093-1.081-.736-1.743-1.78-1.989-3.133l2.874-.437c.179.749.547 1.316 1.104 1.7.556.378 1.282.567 2.177.567.975 0 1.753-.202 2.337-.607.583-.41.875-.911.875-1.5a1.56 1.56 0 00-.537-1.204c-.351-.325-.892-.57-1.621-.736l-2.585-.567c-1.425-.324-2.479-.841-3.162-1.55-.676-.71-1.014-1.608-1.014-2.695 0-.902.252-1.69.755-2.367.504-.676 1.2-1.203 2.088-1.58.889-.385 1.906-.577 3.053-.577 1.651 0 2.95.357 3.898 1.073.948.71 1.574 1.66 1.879 2.854z"})]})},{height:20}),logoLink:"/",docsRepositoryBase:"https://github.com/goes-funky/y42-website-monorepo",footer:{component:(0,n.jsx)(n.Fragment,{})},primaryHue:269,sidebar:{defaultMenuCollapseLevel:1,autoCollapse:!0,toggleButton:!0},darkMode:!1,nextThemes:{defaultTheme:"dark",forcedTheme:"dark"},feedback:{content:null},editLink:{component:null},chat:{link:"https://discord.gg/bHkQVe9hrY",icon:(0,n.jsx)(s.D7,{width:22,height:22,className:"hover:fill-typography-primary"})}}},56788:function(e,t,a){"use strict";a.d(t,{D7:function(){return o},dv:function(){return s},LK:function(){return i}});var n=a(52322);let o=e=>(0,n.jsx)("svg",{width:16,height:16,viewBox:"0 0 127.14 96.36",fill:"#BEBDBF",xmlns:"http://www.w3.org/2000/svg",...e,children:(0,n.jsx)("path",{d:"M107.7 8.07A105.15 105.15 0 0 0 81.47 0a72.06 72.06 0 0 0-3.36 6.83 97.68 97.68 0 0 0-29.11 0A72.37 72.37 0 0 0 45.64 0a105.89 105.89 0 0 0-26.25 8.09C2.79 32.65-1.71 56.6.54 80.21a105.73 105.73 0 0 0 32.17 16.15 77.7 77.7 0 0 0 6.89-11.11 68.42 68.42 0 0 1-10.85-5.18c.91-.66 1.8-1.34 2.66-2a75.57 75.57 0 0 0 64.32 0c.87.71 1.76 1.39 2.66 2a68.68 68.68 0 0 1-10.87 5.19 77 77 0 0 0 6.89 11.1 105.25 105.25 0 0 0 32.19-16.14c2.64-27.38-4.51-51.11-18.9-72.15ZM42.45 65.69C36.18 65.69 31 60 31 53s5-12.74 11.43-12.74S54 46 53.89 53s-5.05 12.69-11.44 12.69Zm42.24 0C78.41 65.69 73.25 60 73.25 53s5-12.74 11.44-12.74S96.23 46 96.12 53s-5.04 12.69-11.43 12.69Z"})}),s=e=>(0,n.jsx)("svg",{width:"14",height:"16",viewBox:"0 0 14 16",fill:"#BEBDBF",...e,xmlns:"http://www.w3.org/2000/svg",children:(0,n.jsx)("path",{d:"M2.905 2.35377C2.905 3.19438 2.2575 3.87551 1.45833 3.87551C0.659167 3.87551 0.0116667 3.19438 0.0116667 2.35377C0.0116667 1.51377 0.659167 0.832031 1.45833 0.832031C2.2575 0.832031 2.905 1.51377 2.905 2.35377ZM2.91667 5.0929H0V14.832H2.91667V5.0929ZM7.57283 5.0929H4.67483V14.832H7.57342V9.7196C

17.57342 6.87699 11.0903 6.64447 11.0903 9.7196V14.832H14V8.66534C14 3.86881 8.7955 4.04351 7.57283 6.40464V5.0929Z",fill:"inherit"})}),i=e=>(0,n.jsx)("svg",{xmlns:"http://www.w3.org/2000/svg",width:24,height:24,viewBox:"0 0 24 24",...e,children:(0,n.jsx)("path",{d:"M19.615 3.184c-3.604-.246-11.631-.245-15.23 0-3.897.266-4.356 2.62-4.385 8.816.029 6.185.484 8.549 4.385 8.816 3.6.245 11.626.246 15.23 0 3.897-.266 4.356-2.62 4.385-8.816-.029-6.185-.484-8.549-4.385-8.816zm-10.615 12.816v-8l8 3.993-8 4.007z"})})}},function(e){e.O(0,[9006,2493,2888,9774,179],function(){return e(e.s=43769)}),_N_E=e.O()}]);