9:["$","html",null,{"lang":"en","className":"h-full","suppressHydrationWarning":true,"children":[["$","body",null,{"className":"flex min-h-full bg-white antialiased dark:bg-zinc-900","children":[["$","$La",null,{"children":["$","div",null,{"className":"w-full","children":["$","$Lb",null,{"allSections":{"/docs":[],"/docs/account":[],"/docs/bi-tools":[],"/docs/connectors":[],"/docs/applications":[],"/docs/custom-connector":[{"title":"Endpoints","id":"endpoints"},{"title":"Types","id":"types"},{"title":"Custom Connector examples and resources","id":"custom-connector-examples-and-resources"}],"/docs/databases":[],"/docs/dbt-cloud":[{"title":"Setup Guide","id":"setup-guide"}],"/docs/destinations":[],"/docs/faq":[{"title":"General","id":"general"},{"title":"Connectors","id":"connectors"},{"title":"Platform","id":"platform"},{"title":"Billing","id":"billing"}],"/docs/files":[],"/docs/glossary":[],"/docs/quickstart-guide":[{"title":"Overview","id":"overview"}],"/docs/requirements":[{"title":"Getting your account","id":"getting-your-account"}],"/docs/what-is-a-data-warehouse":[],"/docs/what-is-sql":[],"/docs/what-is-weld":[],"/docs/account/data-sources":[{"title":"Setting up a data source","id":"setting-up-a-data-source"},{"title":"Usage","id":"usage"},{"title":"Syncing data","id":"syncing-data"},{"title":"Initial syncs","id":"initial-syncs"},{"title":"Incremental syncs","id":"incremental-syncs"},{"title":"Protected tables","id":"protected-tables"},{"title":"Full syncs","id":"full-syncs"},{"title":"Sync modes and Active rows","id":"sync-modes-and-active-rows"}],"/docs/account/orchestration":[],"/docs/account/reverse-etl":[{"title":"Steps to set up a rETL sync","id":"steps-to-set-up-a-r-etl-sync"}],"/docs/account/transform":[],"/docs/account/workspace-settings":[],"/docs/bi-tools/looker":[{"title":"Connect Looker to BigQuery","id":"connect-looker-to-big-query"},{"title":"Connect Looker to Snowflake","id":"connect-looker-to-snowflake"}],"/docs/bi-tools/looker-studio":[{"title":"Connect Looker Studio to BigQuery","id":"connect-looker-studio-to-big-query"},{"title":"Connect Looker Studio to Snowflake","id":"connect-looker-studio-to-snowflake"}],"/docs/bi-tools/metabase":[{"title":"Connect Metabase to BigQuery","id":"connect-metabase-to-big-query"},{"title":"Connect Metabase to Snowflake","id":"connect-metabase-to-snowflake"}],"/docs/bi-tools/mode":[{"title":"Connect Mode to BigQuery","id":"connect-mode-to-big-query"},{"title":"Connect Mode to Snowflake","id":"connect-mode-to-snowflake"}],"/docs/bi-tools/power-bi":[{"title":"Connect BigQuery","id":"connect-big-query"},{"title":"Connect BigQuery (Service Account)","id":"connect-big-query-service-account"},{"title":"Connect Snowflake","id":"connect-snowflake"}],"/docs/bi-tools/tableau":[{"title":"Connect BigQuery","id":"connect-big-query"},{"title":"Connect BigQuery (Service Account)","id":"connect-big-query-service-account"},{"title":"Connect Snowflake","id":"connect-snowflake"}],"/docs/applications/active-campaign":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/adobe-commerce":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/airtable":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/amazon-advertising":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/amazon-selling-partner":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/apple-app-store-connect":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/asana":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/autopilot":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/bigcommerce":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/bing-microsoft-ads":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"📈 Marketing Core Metrics","id":"marketing-core-metrics"}],"/docs/applications/chargebee":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/chartmogul":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/clerk-io":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/clickup":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/contact-form-7":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/customer-io":[{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/daisycon":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/dandomain-webshop":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/drupal":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/e-conomic":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/esmiley":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/facebook-ads":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"📈 Data Modelling","id":"data-modelling"},{"title":"📂 Table Summary","id":"table-summary"},{"title":"Custom Report Builder","id":"custom-report-builder"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"📈 Marketing Core Metrics","id":"marketing-core-metrics"},{"title":"𝌭 Staging Models","id":"staging-models"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/facebook-conversions-api":[{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/facebook-pages":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/foreign-exchange":[{"title":"Setup Guide","id":"setup-guide"}],"/docs/applications/fortnox":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/freshdesk":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/google-ads":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"📈 Data Modelling","id":"data-modelling"},{"title":"📂 Table Summary","id":"table-summary"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"📈 Marketing Core Metrics","id":"marketing-core-metrics"},{"title":"𝌭 Staging Models","id":"staging-models"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/google-analytics-4":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/google-my-business-profile":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"}],"/docs/applications/google-search-console":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/gorgias":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/hubspot":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/instagram-business":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"🔧 Troubleshooting","id":"troubleshooting"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/intercom":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/invision-community":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/jetpack":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/joomla":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/klaviyo":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"},{"title":"Setup Instructions","id":"setup-instructions"}],"/docs/applications/linkedin-ads":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📈 Data Modelling","id":"data-modelling"},{"title":"📂 Table Summary","id":"table-summary"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"📈 Marketing Core Metrics","id":"marketing-core-metrics"},{"title":"𝌭 Staging Models","id":"staging-models"}],"/docs/applications/loaded-commerce":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/magento":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/magento-on-amazon-rds":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/mailchimp":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"}],"/docs/applications/memberpress":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/meteor-via-mongodb":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/microsoft-business-central":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/microsoft-dynamics-365-via-mssql":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/mixpanel":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/monday.com":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/monsterinsights":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/netsuite":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/netvisor":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"}],"/docs/applications/node-bb":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/openweather":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/oscommerce":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/pinterest-ads":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📈 Data Modelling","id":"data-modelling"},{"title":"📂 Table Summary","id":"table-summary"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"📈 Marketing Core Metrics","id":"marketing-core-metrics"},{"title":"𝌭 Staging Models","id":"staging-models"}],"/docs/applications/prestashop":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/qualtrics":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"}],"/docs/applications/quickbooks":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/recurly":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/salesforce":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/applications/salesforce-commerce-cloud":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/shopify":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/shopify-plus":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/snapchat-ads":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📈 Data Modelling","id":"data-modelling"},{"title":"📂 Table Summary","id":"table-summary"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"📈 Marketing Core Metrics","id":"marketing-core-metrics"},{"title":"𝌭 Staging Models","id":"staging-models"}],"/docs/applications/spree-commerce":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/stripe":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/tiktok-ads":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📈 Data Modelling","id":"data-modelling"},{"title":"📂 Table Summary","id":"table-summary"},{"title":"📊 SQL Templates","id":"sql-templates"},{"title":"📈 Marketing Core Metrics","id":"marketing-core-metrics"},{"title":"𝌭 Staging Models","id":"staging-models"}],"/docs/applications/tiktok-organic":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/tiktok-shop":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/typo3":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/vitally":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/woocommerce":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/wordfence-security":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/wordpress":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/xero":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"📊 SQL Templates","id":"sql-templates"}],"/docs/applications/yoast-seo":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/youtube-analytics":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"📊 Reporting Jobs","id":"reporting-jobs"}],"/docs/applications/zendesk":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/core-metrics/marketing":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"","id":""},{"title":"📁 account_report","id":"account-report"},{"title":"📁 ad_group_report","id":"ad-group-report"},{"title":"📁 ad_report","id":"ad-report"},{"title":"📁 campaign_report","id":"campaign-report"}],"/docs/core-metrics/overview":[],"/docs/custom-connector/example":[{"title":"Setup Guide","id":"setup-guide"}],"/docs/data-models/ad-reporting":[{"title":"Overview","id":"overview"},{"title":"Supported connectors","id":"supported-connectors"},{"title":"🔧 Schema","id":"schema"},{"title":"🔧 Set Up Guide","id":"set-up-guide"}],"/docs/databases/amazon-aurora-mysql":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/amazon-aurora-postgresql":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/dynamodb":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/heroku-postgres":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/mongodb":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/mongodb-sharded-cluster":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/mysql":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/mysql-on-azure-database":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/mysql-on-google-cloud-sql":[{"title":"Features","id":"features"},{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/mysql-on-maria-db":[{"title":"Features","id":"features"},{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/mysql-on-rds":[{"title":"Features","id":"features"},{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/phoenix-via-postgresql":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/postgresql":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"🔧 Troubleshooting","id":"troubleshooting"}],"/docs/databases/postgresql-on-azure-database":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/postgresql-on-google-cloud":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/postgresql-on-rds":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/sql-server":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/databases/sql-server-on-rds":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/destinations/amazon-s3":[],"/docs/destinations/azure-synapse":[],"/docs/destinations/databricks":[],"/docs/destinations/google-bigquery":[],"/docs/destinations/ms-sql":[],"/docs/destinations/mysql":[],"/docs/destinations/postgresql":[],"/docs/destinations/redshift":[],"/docs/destinations/snowflake":[{"title":"Setup Guide","id":"setup-guide"}],"/docs/destinations/weld-managed-bigquery":[],"/docs/destinations/weld-managed-fields":[{"title":"Overview","id":"overview"},{"title":"Integration with Weld","id":"integration-with-weld"}],"/docs/files/aws-s3":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/files/email-forward":[{"title":"Contact sales to setup","id":"contact-sales-to-setup"}],"/docs/files/excel":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/files/ftp":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/files/google-drive":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"}],"/docs/files/google-sheets":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/files/google-sheets-service-account":[{"title":"🔧 Setup Guide","id":"setup-guide"},{"title":"🔧 Setup Guide - Reverse ETL","id":"setup-guide-reverse-etl"}],"/docs/files/onedrive":[{"title":"🔧 Setup Guide - ELT","id":"setup-guide-elt"}],"/docs/files/sftp":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/files/sharepoint":[],"/docs/learn/learn-sql":[],"/docs/account/transform/ai-assistant":[],"/docs/account/transform/data-models":[{"title":"Create a draft","id":"create-a-draft"},{"title":"Delete a draft","id":"delete-a-draft"},{"title":"Publish model","id":"publish-model"},{"title":"Reference models","id":"reference-models"},{"title":"Auto-saving","id":"auto-saving"},{"title":"Format models","id":"format-models"}],"/docs/account/transform/lineage":[],"/docs/account/transform/schedule":[{"title":"Publish model as a view","id":"publish-model-as-a-view"},{"title":"Publish model as a table","id":"publish-model-as-a-table"},{"title":"Update schedule","id":"update-schedule"},{"title":"Recreate table now","id":"recreate-table-now"},{"title":"Data warehouse reference","id":"data-warehouse-reference"}],"/docs/account/transform/version-history":[],"/docs/applications/(postgress-shadow)/discourse":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/(postgress-shadow)/medusa":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/(postgress-shadow)/plausible-analytics":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/applications/(postgress-shadow)/supabase":[{"title":"🔧 Setup Guide","id":"setup-guide"}],"/docs/destinations/google-bigquery/enable-billing":[],"/docs/destinations/google-bigquery/setup-guide":[],"/docs/destinations/google-bigquery/troubleshooting":[],"/docs/destinations/google-bigquery/usage-insights":[{"title":"Permission error","id":"permission-error"}],"/docs/destinations/weld-managed-bigquery/migrate":[],"/docs/destinations/weld-managed-fields/weld_synced":[{"title":"Overview","id":"overview"},{"title":"Example","id":"example"}]},"children":["$","$L7",null,{"parallelRouterKey":"children","segmentPath":["children","docs","children"],"loading":"$undefined","loadingStyles":"$undefined","hasLoading":false,"error":"$undefined","errorStyles":"$undefined","template":["$","$L8",null,{}],"templateStyles":"$undefined","notFound":[["$","div",null,{"className":"absolute inset-0 -z-10 mx-0 max-w-none overflow-hidden","children":["$","div",null,{"className":"absolute left-1/2 top-0 ml-[-38rem] h-[25rem] w-[81.25rem] dark:[mask-image:linear-gradient(white,transparent)]","children":[["$","div",null,{"className":"absolute inset-0 bg-gradient-to-r from-[#3668b4] to-[#75caff] opacity-40 [mask-image:radial-gradient(farthest-side_at_top,white,transparent)] dark:from-[#3668b4]/30 dark:to-[#75caff]/30 dark:opacity-100","children":["$","svg",null,{"aria-hidden":"true","className":"absolute inset-x-0 inset-y-[-50%] h-[200%] w-full skew-y-[-18deg] fill-black/40 stroke-black/50 mix-blend-overlay dark:fill-white/2.5 dark:stroke-white/5","children":[["$","defs",null,{"children":["$","pattern",null,{"id":":S1:","width":72,"height":56,"patternUnits":"userSpaceOnUse","x":"-12","y":"4","children":["$","path",null,{"d":"M.5 56V.5H72","fill":"none"}]}]}],["$","rect",null,{"width":"100%","height":"100%","strokeWidth":0,"fill":"url(#:S1:)"}],["$","svg",null,{"x":"-12","y":"4","className":"overflow-visible","children":[["$","rect","4-3",{"strokeWidth":"0","width":73,"height":57,"x":288,"y":168}],["$","rect","2-1",{"strokeWidth":"0","width":73,"height":57,"x":144,"y":56}],["$","rect","7-3",{"strokeWidth":"0","width":73,"height":57,"x":504,"y":168}],["$","rect","10-6",{"strokeWidth":"0","width":73,"height":57,"x":720,"y":336}]]}]]}]}],["$","svg",null,{"viewBox":"0 0 1113 440","aria-hidden":"true","className":"absolute left-1/2 top-0 ml-[-19rem] w-[69.5625rem] fill-white blur-[26px] dark:hidden","children":["$","path",null,{"d":"M.016 439.5s-9.5-300 434-300S882.516 20 882.516 20V0h230.004v439.5H.016Z"}]}]]}]}],["$","div",null,{"className":"mx-auto flex h-full max-w-xl flex-col items-center justify-center py-16 text-center","children":[["$","p",null,{"className":"text-sm font-semibold text-zinc-900 dark:text-white","children":"404"}],["$","h1",null,{"className":"mt-2 text-2xl font-bold text-zinc-900 dark:text-white","children":"Page not found"}],["$","p",null,{"className":"mt-2 text-base text-zinc-600 dark:text-zinc-400","children":"Sorry, we couldn’t find the page you’re looking for."}],["$","$Lc",null,{"className":"inline-flex gap-0.5 justify-center overflow-hidden text-sm font-medium transition rounded-md bg-zinc-900 py-1 px-3 text-white hover:bg-zinc-700 dark:bg-blue-400/10 dark:text-blue-400 dark:ring-1 dark:ring-inset dark:ring-blue-400/20 dark:hover:bg-blue-400/10 dark:hover:text-blue-300 dark:hover:ring-blue-300 mt-8","href":"/","children":[false,"Back to docs",["$","svg",null,{"viewBox":"0 0 20 20","fill":"none","aria-hidden":"true","className":"mt-0.5 h-5 w-5 -mr-1","children":["$","path",null,{"stroke":"currentColor","strokeLinecap":"round","strokeLinejoin":"round","d":"m11.5 6.5 3 3.5m0 0-3 3.5m3-3.5h-9"}]}]]}]]}]],"notFoundStyles":[],"childProp":{"current":["$","$L7",null,{"parallelRouterKey":"children","segmentPath":["children","docs","children","applications","children"],"loading":"$undefined","loadingStyles":"$undefined","hasLoading":false,"error":"$undefined","errorStyles":"$undefined","template":["$","$L8",null,{}],"templateStyles":"$undefined","notFound":"$undefined","notFoundStyles":"$undefined","childProp":{"current":["$","$L7",null,{"parallelRouterKey":"children","segmentPath":["children","docs","children","applications","children","wordpress","children"],"loading":"$undefined","loadingStyles":"$undefined","hasLoading":false,"error":"$undefined","errorStyles":"$undefined","template":["$","$L8",null,{}],"templateStyles":"$undefined","notFound":"$undefined","notFoundStyles":"$undefined","childProp":{"current":["$Ld",["$","article",null,{"className":"flex h-full flex-col pb-10 pt-16","children":[["$","div",null,{"className":"flex-auto prose dark:prose-invert","children":[["$","h1",null,{"children":"Wordpress"}],"\n",["$","p",null,{"children":[["$","$Lc",null,{"href":"https://wordpress.org/","children":"Wordpress"}]," is an open source blog system and CMS written in PHP that powers 43% of the web. The system is the most widespread in the world and has been translated into many languages. It is possible to install plugins that dramatically change its functionality. Some state-of-the-art examples include ",["$","$Lc",null,{"href":"https://woocommerce.com/","children":"WooCommerce"}],", ",["$","$Lc",null,{"href":"https://yoast.com/","children":"Yoast SEO"}],", ",["$","$Lc",null,{"href":"https://www.wordfence.com/","children":"Wordfence"}],", ",["$","$Lc",null,{"href":"https://www.monsterinsights.com/","children":"MonsterInsights"}],", ",["$","$Lc",null,{"href":"https://contactform7.com/","children":"CF7"}],", ",["$","$Lc",null,{"href":"https://jetpack.com/","children":"Jetpack"}],", ",["$","$Lc",null,{"href":"https://memberpress.com/","children":"MemberPress"}],"."]}],"\n",["$","p",null,{"children":"We incorporate a deep integration with the system's raw data layer via a MySQL connection. This allows us to sync data from the underlying CMS as well as any plugins with persistent data."}],"\n",["$","$Le",null,{"anchor":false,"level":3,"id":"features","children":["Features ",["$","a",null,{"href":"#features","id":"features"}]]}],"\n",["$","$Lf",null,{"eltFeatures":{"hashing":"Column level","blocking":"Column level","incremental":"Merge, Append","customData":true,"history":false,"reSync":"Table level"},"hideToggle":true}],"\n",["$","$Le",null,{"anchor":false,"level":3,"id":"schema-information","children":"Schema information"}],"\n",["$","p",null,{"children":["Wordpress releases their database ERD diagrams for different versions of the system on their ",["$","$Lc",null,{"href":"https://codex.wordpress.org/Database_Description","children":"Database Description"}]," page."]}],"\n",["$","hr",null,{}],"\n",["$","$Le",null,{"level":2,"id":"setup-guide","children":"🔧 Setup Guide"}],"\n",["$","div",null,{"className":"my-6 flex gap-2.5 rounded-2xl border border-emerald-500/20 bg-emerald-50/50 p-4 leading-6 text-emerald-900 dark:border-emerald-500/30 dark:bg-emerald-500/5 dark:text-emerald-200 dark:[--tw-prose-links-hover:theme(colors.emerald.300)] dark:[--tw-prose-links:theme(colors.white)]","children":[["$","svg",null,{"viewBox":"0 0 16 16","aria-hidden":"true","className":"mt-1 h-4 w-4 flex-none fill-emerald-500 stroke-white dark:fill-emerald-200/20 dark:stroke-emerald-200","children":[["$","circle",null,{"cx":"8","cy":"8","r":"8","strokeWidth":"0"}],["$","path",null,{"fill":"none","strokeLinecap":"round","strokeLinejoin":"round","strokeWidth":"1.5","d":"M6.75 7.75h1.5v3.5"}],["$","circle",null,{"cx":"8","cy":"4","r":".5","fill":"none"}]]}],["$","div",null,{"className":"[&>:first-child]:mt-0 [&>:last-child]:mb-0","children":["$","p",null,{"children":["$","strong",null,{"children":["Due to the ",["$","$Lc",null,{"href":"https://wordpress.com/support/phpmyadmin-and-mysql/#database-access","children":"access limitations"}]," in place, we currently have support only for the self-hosted version of Wordpress."]}]}]}]]}],"\n",["$","div",null,{"className":"my-6 flex gap-2.5 rounded-2xl border border-emerald-500/20 bg-emerald-50/50 p-4 leading-6 text-emerald-900 dark:border-emerald-500/30 dark:bg-emerald-500/5 dark:text-emerald-200 dark:[--tw-prose-links-hover:theme(colors.emerald.300)] dark:[--tw-prose-links:theme(colors.white)]","children":[["$","svg",null,{"viewBox":"0 0 16 16","aria-hidden":"true","className":"mt-1 h-4 w-4 flex-none fill-emerald-500 stroke-white dark:fill-emerald-200/20 dark:stroke-emerald-200","children":[["$","circle",null,{"cx":"8","cy":"8","r":"8","strokeWidth":"0"}],["$","path",null,{"fill":"none","strokeLinecap":"round","strokeLinejoin":"round","strokeWidth":"1.5","d":"M6.75 7.75h1.5v3.5"}],["$","circle",null,{"cx":"8","cy":"4","r":".5","fill":"none"}]]}],["$","div",null,{"className":"[&>:first-child]:mt-0 [&>:last-child]:mb-0","children":[["$","$Le",null,{"anchor":false,"level":3,"id":"read-replicas","children":"Read replicas"}],["$","p",null,{"children":["With high throughput systems, running a high frequency sync with a production database can put unnecessary load onto the running services. One mitigation technique is to create a ",["$","strong",null,{"children":"read replica"}],"."]}]]}]]}],"\n",["$","div",null,{"className":"my-6 flex gap-2.5 rounded-2xl border border-emerald-500/20 bg-emerald-50/50 p-4 leading-6 text-emerald-900 dark:border-emerald-500/30 dark:bg-emerald-500/5 dark:text-emerald-200 dark:[--tw-prose-links-hover:theme(colors.emerald.300)] dark:[--tw-prose-links:theme(colors.white)]","children":[["$","svg",null,{"viewBox":"0 0 16 16","aria-hidden":"true","className":"mt-1 h-4 w-4 flex-none fill-emerald-500 stroke-white dark:fill-emerald-200/20 dark:stroke-emerald-200","children":[["$","circle",null,{"cx":"8","cy":"8","r":"8","strokeWidth":"0"}],["$","path",null,{"fill":"none","strokeLinecap":"round","strokeLinejoin":"round","strokeWidth":"1.5","d":"M6.75 7.75h1.5v3.5"}],["$","circle",null,{"cx":"8","cy":"4","r":".5","fill":"none"}]]}],["$","div",null,{"className":"[&>:first-child]:mt-0 [&>:last-child]:mb-0","children":[["$","$Le",null,{"anchor":false,"level":3,"id":"whitelist-welds-ip-pool","children":"Whitelist Weld's IP pool"}],["$","p",null,{"children":"Requests from Weld will always come from the following IP pool:"}],["$","ul",null,{"children":["\n",["$","li",null,{"children":["$","$L10",null,{"children":"3.64.84.139"}]}],"\n",["$","li",null,{"children":["$","$L10",null,{"children":"3.65.119.169"}]}],"\n",["$","li",null,{"children":["$","$L10",null,{"children":"35.156.133.78"}]}],"\n"]}],["$","p",null,{"children":"Make sure to whitelist all three of these IP's within your network policies, SSH gateway server or the DB itself. If any updates to the list are ever scheduled to happen, you will be contacted by Weld via email."}]]}]]}],"\n",["$","$Le",null,{"anchor":false,"level":3,"id":"step-1-get-credentials-to-setup-the-connection","children":"Step 1 - Get credentials to setup the connection"}],"\n",["$","p",null,{"children":"From your MySQL Database, access and paste the required fields:"}],"\n",["$","ul",null,{"children":["\n",["$","li",null,{"children":"Name (The name you want to refer to regarding this connection in the Weld app)"}],"\n",["$","li",null,{"children":"Host (IP Address of your server)"}],"\n",["$","li",null,{"children":"Database (Name of the database you want to connect to)"}],"\n"]}],"\n",["$","p",null,{"children":"The host can be found running the following SQL commands in your MySQL database:"}],"\n",["$","$L11",null,{"children":["$","$L12",null,{"language":"sql","code":"select @@hostname;\nshow variables where Variable_name like '%host%';\n","children":["$","$L10",null,{"className":"language-sql","children":"select @@hostname;\nshow variables where Variable_name like '%host%';\n"}],"title":"sql"}]}],"\n",["$","p",null,{"children":"Furthermore, add the port, name and your Weld username and password if desired. You can also connect through an SSH Tunnel."}],"\n",["$","$Le",null,{"anchor":false,"level":3,"id":"step-2-data-to-sync","children":"Step 2 - Data To Sync"}],"\n",["$","div",null,{"className":"my-6 flex gap-2.5 rounded-2xl border border-emerald-500/20 bg-emerald-50/50 p-4 leading-6 text-emerald-900 dark:border-emerald-500/30 dark:bg-emerald-500/5 dark:text-emerald-200 dark:[--tw-prose-links-hover:theme(colors.emerald.300)] dark:[--tw-prose-links:theme(colors.white)]","children":[["$","svg",null,{"viewBox":"0 0 16 16","aria-hidden":"true","className":"mt-1 h-4 w-4 flex-none fill-emerald-500 stroke-white dark:fill-emerald-200/20 dark:stroke-emerald-200","children":[["$","circle",null,{"cx":"8","cy":"8","r":"8","strokeWidth":"0"}],["$","path",null,{"fill":"none","strokeLinecap":"round","strokeLinejoin":"round","strokeWidth":"1.5","d":"M6.75 7.75h1.5v3.5"}],["$","circle",null,{"cx":"8","cy":"4","r":".5","fill":"none"}]]}],["$","div",null,{"className":"[&>:first-child]:mt-0 [&>:last-child]:mb-0","children":["$","p",null,{"children":"Tables can always be updated in the configuration settings of the sync."}]}]]}],"\n",["$","ol",null,{"children":["\n",["$","li",null,{"children":["Select the tables you wish to include in the sync. ",["$","br",null,{}],"\n","You can view the schema, remove columns or hash sensitive information."]}],"\n",["$","li",null,{"children":["Update Sync mode: ",["$","br",null,{}],"\n","By default the MySQL connector is set to run always full syncs. To optimize the sync time and reduce processing overhead on your MySQL server we recommend for you to set up the syncs to run incrementally."]}],"\n"]}],"\n",["$","p",null,{"children":["We currently support both ",["$","strong",null,{"children":"Merge"}]," and ",["$","strong",null,{"children":"Append"}]," mode for incremental syncs."]}],"\n",["$","h4",null,{"children":"Merge"}],"\n",["$","p",null,{"children":["To have your table running incrementally using the merge configuration you need a table ",["$","strong",null,{"children":"primary key"}]," and a ",["$","strong",null,{"children":"cursor"}]," timestamp (",["$","$L10",null,{"children":"updated_at"}]," is preferred)."]}],"\n",["$","p",null,{"children":"When a sync is run, Weld will select only the new or changed rows since the last update."}],"\n",["$","h4",null,{"children":"Append"}],"\n",["$","p",null,{"children":["If a row ",["$","$L10",null,{"children":"updated_at"}]," timestamp is not available on the table then another option is to run an incremental sync using append mode. Append mode uses cursor to keep track of how far the sync got on the last run. It will use that cursor to append new entries at the end of the table on the next run."]}],"\n",["$","p",null,{"children":"Append is not widely used as it does not capture updates in the previous rows."}],"\n",["$","h4",null,{"children":"Full Sync at Midnight"}],"\n",["$","p",null,{"children":["A limitation of both ",["$","strong",null,{"children":"Merge"}]," and ",["$","strong",null,{"children":"Append"}]," modes is that they do not capture deleted rows. If you expect rows to be deleted often from your tables then you can set a table to run a full sync at midnight which will remove those deleted rows."]}],"\n",["$","$Le",null,{"anchor":false,"level":3,"id":"step-3-configure-sync","children":"Step 3 - Configure Sync"}],"\n",["$","ol",null,{"children":["\n",["$","li",null,{"children":"Select how often you would like the data to sync."}],"\n",["$","li",null,{"children":"Provide a unique destination table name."}],"\n"]}],"\n",["$","p",null,{"children":"Weld will take over from here and commence syncing data from your MySQL database."}]]}],["$","footer",null,{"className":"mx-auto mt-16 w-full max-w-2xl lg:max-w-5xl","children":["$","$L13",null,{}]}]]}],null],"segment":"__PAGE__"},"styles":[]}],"segment":"wordpress"},"styles":[]}],"segment":"applications"},"styles":[]}]}]}]}],[["$","$L14",null,{}],["$","$L15",null,{}]]]}],["$","$L16",null,{}],["$","$L17",null,{"id":"Intercom","type":"text/javascript","children":"\n window.intercomSettings = {\n api_base: \"https://api-iam.intercom.io\",\n app_id: \"g5ykt7c2\"\n };\n (function(){var w=window;var ic=w.Intercom;if(typeof ic===\"function\"){ic('reattach_activator');ic('update',w.intercomSettings);}else{var d=document;var i=function(){i.c(arguments);};i.q=[];i.c=function(args){i.q.push(args);};w.Intercom=i;var l=function(){var s=d.createElement('script');s.type='text/javascript';s.async=true;s.src='https://widget.intercom.io/widget/g5ykt7c2';var x=d.getElementsByTagName('script')[0];x.parentNode.insertBefore(s,x);};if(document.readyState==='complete'){l();}else if(w.attachEvent){w.attachEvent('onload',l);}else{w.addEventListener('load',l,false);}}})();\n "}],["$","$L17",null,{"id":"Cookiebot","src":"https://consent.cookiebot.com/uc.js","data-cbid":"2af317f6-f83a-4d3b-a132-121055b56fc4","type":"text/javascript","async":true,"strategy":"lazyOnload"}]]}]