{"id":8841,"date":"2022-10-20T18:34:00","date_gmt":"2022-10-20T16:34:00","guid":{"rendered":"https:\/\/wearekemb.com\/?p=8841"},"modified":"2025-03-03T17:33:00","modified_gmt":"2025-03-03T16:33:00","slug":"fivetran-mar-optimization-full","status":"publish","type":"post","link":"https:\/\/wearekemb.com\/en\/fivetran-mar-optimization-full\/","title":{"rendered":"Fivetran MAR Optimization"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; custom_padding_last_edited=&#8221;on|phone&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#FFFFFF&#8221; custom_padding=&#8221;30px||30px||true|false&#8221; custom_padding_tablet=&#8221;||30px||false|false&#8221; custom_padding_phone=&#8221;&#8221; hover_enabled=&#8221;0&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_row _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.19.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; text_font=&#8221;||||||||&#8221; custom_margin=&#8221;0px||||false|false&#8221; custom_margin_tablet=&#8221;0px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Many potential components of the modern data stack have consumption based pricing. As most of these tools offer free trials, you should make sure to make the most of the trial and determine the cost of your infrastructure. However once you are on a running setup there might be ways to save several hundred Euros or more by optimizing what data you consume and how you set up the whole infrastructure you use for ingestion. In this case we want to look at fivetran in conjunction with a snowflake warehouse.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>The Pricing Model of Fivetran: Consumption based<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Fivetran Pricing is based on the user\u2019s actual monthly data consumption. Therefore, whatever possibilities you have to control or optimize this amount has an immediate impact on your costs, let alone efficiency as one should always question what is really needed or not. Given that next to direct cost for fivetran itself you will pay for compute resources (in this case snowflake warehouses) you might be able to also reduce secondary cost associated with fivetran.<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How is consumption measured?<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>In the case of fivetran, pricing is based on a metric called MAR (monthly active rows). It might be initially tricky to grasp that concept but let\u2019s give it a try (a good resource is of course <a href=\"https:\/\/fivetran.com\/docs\/pricing#monthlyactiverows\"><span style=\"color: #0000ff;\">Fivetran&#8217;s website as well<\/span>):<\/a><\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ul>\n<li>\n<p style=\"text-align: left;\">You have a table with one million rows. Now this table gets synced when you completely set up your connector with a historical sync<\/p>\n<\/li>\n<li style=\"text-align: left;\">\n<p>Basically, this table grows by 10.000 rows daily, all of these new rows are counted as MAR, so will all newly added rows that get synced<\/p>\n<\/li>\n<li style=\"text-align: left;\">\n<p>Within the whole table, there are some rows that get updated during the month. Any row that gets updated once or more in a month will get counted once as a MAR. A row that has been created on the 2nd of a month and that gets updated 5 times within that same month, will be counted as one MAR for that month<\/p>\n<\/li>\n<li style=\"text-align: left;\">\n<p>There are some notable exceptions to this, the biggest being file connectors (file folders, SFTP\/FTP,&#8230;). Here you will pay for the maximum amount of rows in each file that fivetran syncs in a month and you will get charged for the full table each month. Using lots of files in your account as sources can bloat the cost (see <span style=\"color: #0000ff;\"><a href=\"https:\/\/fivetran.com\/docs\/pricing#fileconnectors\" style=\"color: #0000ff;\">https:\/\/fivetran.com\/docs\/pricing#fileconnectors<\/a><\/span>)<\/p>\n<\/li>\n<li>\n<p style=\"text-align: left;\">Some specific connectors have sync strategies, where they regularly need to sync an entire table as there is no tracking mechanism for fivetran in place to understand which rows are new or have changed. An overview of edge cases is summarized here (<span style=\"color: #0000ff;\"><a href=\"https:\/\/fivetran.com\/docs\/pricing#connectorspecificfunctionaldifferences\" style=\"color: #0000ff;\">https:\/\/fivetran.com\/docs\/pricing#connectorspecificfunctionaldifferences<\/a><\/span>)<\/p>\n<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>If you use fivetran, you are most often aware how to track your MAR. When you open your account and have the right permissions, you can go on a per connector and per table level by clicking on \u201cAccount settings\u201d -&gt; \u201cBilling and Usage\u201d and selecting the usage tab. Another option is to use the fivetran log connector to write information on all connectors to your data warehouse \/ data lake and then build a custom reporting. We regularly support our clients in setting up a cost reporting on their whole infrastructure<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Optimizing MAR<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Several approaches can lead to a more cost-efficient setup with fivetran:<\/p>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<ul>\n<li>\n<p>On the connector level, understand which tables within a connector account for the most MAR and whether they are actually used downstream for reporting. An example that regularly saves lots of MAR is switching off hourly reports from the Google Ads connector, which generate most of the MAR in this connector, but most companies only evaluate their ad performance on a daily level. Go through the statistics connector by connector and take the time to talk to users involved in downstream processes, to see if the \u201cbig spenders\u201d are actually in use. If you are using tools like dbt or coalesce, you might understand from their data lineage features if these tables are implemented in your data modeling at all<\/p>\n<\/li>\n<li>\n<p>MAR do not depend on whether a row is actually updated in the sources, but rather whether fivetran sees a change or not. Let me elaborate: a concrete example out of our consulting work was a table that held all the product information in our client\u2019s ERP system. This table was needed downstream in multiple instances to join in product information. However,within this table there was a column that was updated every 5 minutes as a ping against the stock. Stock levels however were not of interest at that time. Fivetran offers an option to individually select or deselect most columns(which can also help exclude PII from getting to your destination). Removing that \u201cping-column\u201d helped to massively reduce the MAR for that table as the remaining columns rarely changed during a month<\/p>\n<\/li>\n<li>\n<p>Specific connectors require the composition of custom datasets you extract with fivetran. You will have to configure fivetran to generate tables with columns that you need from the sources data model. Let\u2019s take Google Analytics as an example: there is a tradeoff between building very specific custom reports for each reporting use case vs building broader tables in custom reports that cover more dimensions and metrics than needed for each individual report, but then you only need that one table. Your free trial for each connector can help estimate which setup is more efficient. However, adding a not needed dimension to a custom report will directly multiply your MAR. Say you have a table with 200 rows daily for pageviews per source and medium. Adding the campaign dimension, those can easily become several thousand rows. If you do not report on a campaign level however, this is just additional cost with no value<\/p>\n<\/li>\n<li>\n<p>Another issue we regularly encounter is that synchronization frequencies in fivetran are not aligned with the downstream use cases. You can technically have fivetran sync every minute (depending on your plan the minimum might be every hour). The impact on your MAR is actually negligible, because if a row is active in a month whether you get it at high or low frequency does not matter. There are use cases where high frequency syncs are required though: you need a (near-)realtime dashboard for inventory, you have no historization in your source and use dbt to build an incremental table where you want all status changes to be covered\u2026 However, if you do not need data every other minute, you may want to dial down the frequency, as this will raise the cost for your data warehouse infrastructure. If you go for a daily sync (given that use cases and amount of data allow for that) you even have the possibility to set the hour at which data gets synced. If feasible, set the hour to be the same for all sources so that your warehouse compute resource on snowflake only starts for just one and not multiple timeframes. Make sure to have your warehouse connected to fivetran auto-suspend in snowflake<\/p>\n<\/li>\n<li>\n<p>The sizing of snowflake warehouses can also have a major impact on synchronization costs. In most use cases, we see that an XS warehouse is absolutely sufficient for running connector syncs. Make your way up from there, if it should not suffice<\/p>\n<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion: Many MAR optimization options, mostly depending on individual setups<\/h2>\n<p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.20.4&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>As you can see there is multiple ways to optimize your MAR and associated cost with fivetran to improve your cost-value relation in this setup. However, there might be even more optimizations that can be found when evaluating your account. It all starts with a good analysis of what data is actually used and which tables incur the most MAR. Bringing this together can be challenging, as it might require multiple alignments with business users and other data teams, but we have regularly seen significant savings in company\u2019s stacks. If you want to challenge your current setup with a trusted fivetran partner, feel free to reach out to use and we are happy to jump on a call with you.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Fivetran&#8217; uses a consumption based pricing model based on monthly active rows (MAR): We&#8217;ll show how to optimize for a most cost-efficient setup! <\/p>\n","protected":false},"author":7,"featured_media":8770,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","content-type":"","inline_featured_image":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-8841","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fivetran MAR Optimization - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation<\/title>\n<meta name=\"description\" content=\"Fivetran uses a consumption based pricing model with monthly active rows (MAR): We&#039;ll show how to optimize for a cost-efficient setup!\" \/>\n<meta name=\"robots\" content=\"noindex, nofollow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fivetran MAR Optimization - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\" \/>\n<meta property=\"og:description\" content=\"Fivetran uses a consumption based pricing model with monthly active rows (MAR): We&#039;ll show how to optimize for a cost-efficient setup!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wearekemb.com\/fivetran-mar-optimization\" \/>\n<meta property=\"og:site_name\" content=\"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-20T16:34:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-03T16:33:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"545\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Konstantin Wemhoener\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Konstantin Wemhoener\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization#article\",\"isPartOf\":{\"@id\":\"https:\/\/wearekemb.com\/en\/fivetran-mar-optimization-full\/\"},\"author\":{\"name\":\"Konstantin Wemhoener\",\"@id\":\"https:\/\/wearekemb.com\/en\/#\/schema\/person\/6b7a1293653d367efabd5f3ded0adb5f\"},\"headline\":\"Fivetran MAR Optimization\",\"datePublished\":\"2022-10-20T16:34:00+00:00\",\"dateModified\":\"2025-03-03T16:33:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/wearekemb.com\/en\/fivetran-mar-optimization-full\/\"},\"wordCount\":1688,\"publisher\":{\"@id\":\"https:\/\/wearekemb.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp\",\"articleSection\":[\"Business Intelligence\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wearekemb.com\/en\/fivetran-mar-optimization-full\/\",\"url\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization\",\"name\":\"Fivetran MAR Optimization - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\",\"isPartOf\":{\"@id\":\"https:\/\/wearekemb.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp\",\"datePublished\":\"2022-10-20T16:34:00+00:00\",\"dateModified\":\"2025-03-03T16:33:00+00:00\",\"description\":\"Fivetran uses a consumption based pricing model with monthly active rows (MAR): We'll show how to optimize for a cost-efficient setup!\",\"breadcrumb\":{\"@id\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wearekemb.com\/fivetran-mar-optimization\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage\",\"url\":\"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp\",\"contentUrl\":\"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp\",\"width\":800,\"height\":545},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wearekemb.com\/fivetran-mar-optimization#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wearekemb.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fivetran MAR Optimization\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wearekemb.com\/en\/#website\",\"url\":\"https:\/\/wearekemb.com\/en\/\",\"name\":\"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation\",\"description\":\"We help you bring your business to the next level\",\"publisher\":{\"@id\":\"https:\/\/wearekemb.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wearekemb.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/wearekemb.com\/en\/#organization\",\"name\":\"kemb GmbH\",\"url\":\"https:\/\/wearekemb.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png\",\"contentUrl\":\"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png\",\"width\":512,\"height\":512,\"caption\":\"kemb GmbH\"},\"image\":{\"@id\":\"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/kemb-gmbh\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/wearekemb.com\/en\/#\/schema\/person\/6b7a1293653d367efabd5f3ded0adb5f\",\"name\":\"Konstantin Wemhoener\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/9c2af8bbae6d0f7b457ac2728508d8df89fabe4aedfc4252bc565116aa59d996?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9c2af8bbae6d0f7b457ac2728508d8df89fabe4aedfc4252bc565116aa59d996?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9c2af8bbae6d0f7b457ac2728508d8df89fabe4aedfc4252bc565116aa59d996?s=96&d=mm&r=g\",\"caption\":\"Konstantin Wemhoener\"},\"description\":\"CDO and founder of kemb, a boutique agency combining business intelligence with digitalization knowledge\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fivetran MAR Optimization - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","description":"Fivetran uses a consumption based pricing model with monthly active rows (MAR): We'll show how to optimize for a cost-efficient setup!","robots":{"index":"noindex","follow":"nofollow"},"og_locale":"en_US","og_type":"article","og_title":"Fivetran MAR Optimization - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","og_description":"Fivetran uses a consumption based pricing model with monthly active rows (MAR): We'll show how to optimize for a cost-efficient setup!","og_url":"https:\/\/wearekemb.com\/fivetran-mar-optimization","og_site_name":"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","article_published_time":"2022-10-20T16:34:00+00:00","article_modified_time":"2025-03-03T16:33:00+00:00","og_image":[{"width":800,"height":545,"url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp","type":"image\/webp"}],"author":"Konstantin Wemhoener","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Konstantin Wemhoener","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wearekemb.com\/fivetran-mar-optimization#article","isPartOf":{"@id":"https:\/\/wearekemb.com\/en\/fivetran-mar-optimization-full\/"},"author":{"name":"Konstantin Wemhoener","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/person\/6b7a1293653d367efabd5f3ded0adb5f"},"headline":"Fivetran MAR Optimization","datePublished":"2022-10-20T16:34:00+00:00","dateModified":"2025-03-03T16:33:00+00:00","mainEntityOfPage":{"@id":"https:\/\/wearekemb.com\/en\/fivetran-mar-optimization-full\/"},"wordCount":1688,"publisher":{"@id":"https:\/\/wearekemb.com\/en\/#organization"},"image":{"@id":"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage"},"thumbnailUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp","articleSection":["Business Intelligence"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/wearekemb.com\/en\/fivetran-mar-optimization-full\/","url":"https:\/\/wearekemb.com\/fivetran-mar-optimization","name":"Fivetran MAR Optimization - kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","isPartOf":{"@id":"https:\/\/wearekemb.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage"},"image":{"@id":"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage"},"thumbnailUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp","datePublished":"2022-10-20T16:34:00+00:00","dateModified":"2025-03-03T16:33:00+00:00","description":"Fivetran uses a consumption based pricing model with monthly active rows (MAR): We'll show how to optimize for a cost-efficient setup!","breadcrumb":{"@id":"https:\/\/wearekemb.com\/fivetran-mar-optimization#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wearekemb.com\/fivetran-mar-optimization"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/wearekemb.com\/fivetran-mar-optimization#primaryimage","url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp","contentUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/10\/fivetran-mar-optimization-thumbnail.webp","width":800,"height":545},{"@type":"BreadcrumbList","@id":"https:\/\/wearekemb.com\/fivetran-mar-optimization#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wearekemb.com\/en\/"},{"@type":"ListItem","position":2,"name":"Fivetran MAR Optimization"}]},{"@type":"WebSite","@id":"https:\/\/wearekemb.com\/en\/#website","url":"https:\/\/wearekemb.com\/en\/","name":"kemb GmbH - Your Partners in Business Intelligence, Marketing Digital Transformation","description":"We help you bring your business to the next level","publisher":{"@id":"https:\/\/wearekemb.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wearekemb.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/wearekemb.com\/en\/#organization","name":"kemb GmbH","url":"https:\/\/wearekemb.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png","contentUrl":"https:\/\/wearekemb.com\/wp-content\/uploads\/2023\/02\/kemb-logo-512x512-1.png","width":512,"height":512,"caption":"kemb GmbH"},"image":{"@id":"https:\/\/wearekemb.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/kemb-gmbh\/"]},{"@type":"Person","@id":"https:\/\/wearekemb.com\/en\/#\/schema\/person\/6b7a1293653d367efabd5f3ded0adb5f","name":"Konstantin Wemhoener","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/secure.gravatar.com\/avatar\/9c2af8bbae6d0f7b457ac2728508d8df89fabe4aedfc4252bc565116aa59d996?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9c2af8bbae6d0f7b457ac2728508d8df89fabe4aedfc4252bc565116aa59d996?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9c2af8bbae6d0f7b457ac2728508d8df89fabe4aedfc4252bc565116aa59d996?s=96&d=mm&r=g","caption":"Konstantin Wemhoener"},"description":"CDO and founder of kemb, a boutique agency combining business intelligence with digitalization knowledge"}]}},"_links":{"self":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts\/8841","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/comments?post=8841"}],"version-history":[{"count":0,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/posts\/8841\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/media\/8770"}],"wp:attachment":[{"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/media?parent=8841"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/categories?post=8841"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wearekemb.com\/en\/wp-json\/wp\/v2\/tags?post=8841"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}