March 2020 Summaries

Fivetran ranked #4 on the 2020 list of Ireland's Best Small Workplaces, as announced at the Great Place to Work event held in February. The company was awarded a 'best small workplace' certificate along with other entrants in its category. Fivetran is proud of its achievements in only three years in Ireland and continues to grow, currently hiring for new positions.

The article discusses the challenges faced by traditional data warehouse architectures and how cloud platforms can overcome them. It highlights the difficulties in managing conflicting requirements such as maximizing query performance, throughput, and machine usage. The author also explores potential solutions like limiting resource usage, database and application tuning, and improving hardware. However, these methods have their limitations, including capped maximum usage, built-in inefficiency, and the need for constant upgrades. The ideal cloud data warehouse platform should allow independent scaling of compute and storage resources, offer fast deployment, complete flexibility, separate payment for storage, zero contention, and absolute simplicity. Modern cloud data warehouses can automatically scale up or down to cope with increased demands and provide automatic scale-out options during peak periods. These platforms charge for compute resources on a per-second basis, making them both compelling and potentially cost-effective solutions.

Fivetran has introduced a consumption-based pricing model based on monthly active rows (MAR). This model allows customers to maximize the value of Fivetran by efficiently capturing changes in data sources and performing incremental upserts. MAR is calculated as Rows at Rest multiplied by Update Rate, which is typically 10-20%. The new pricing model reduces waste caused by multiple row updates and snapshot waste, resulting in a significant reduction in the cost of managing cloud destinations. By understanding the difference between MAR and total synced rows, customers can more accurately predict their Fivetran usage and costs.

Fivetran has been recognized as an Amazon Redshift Ready Partner within the Amazon Web Services (AWS) Ready Program, adding to its previous designation as an Advanced Technology Company in the AWS Advanced Partner Network (APN). This recognition highlights Fivetran's seamless integration with Amazon Redshift, a fast and fully managed petabyte-scale data warehouse. As a partner, Fivetran extracts, loads, centralizes, and transforms data within Redshift for analysis and sharing. The company differentiates itself from manual data pipeline assembly and ETL tools through its cloud-native design, ELT architecture, and connectors that adapt to changes in source APIs and schemas. Fivetran's customers span various industries, including advertising, finance, hospitality, online retail, publishing, real estate, sales, marketing, and software.

Fivetran has been awarded the Amazon Redshift Ready designation for its seamless integration with Amazon Redshift, a fast, fully managed, petabyte-scale data warehouse. As an Amazon Redshift Ready Partner, Fivetran extracts and loads source data into Redshift, transforming it within the platform to enable insights analysis and sharing. The company's ELT architecture enables better performance and less time and cost moving data back and forth. Customers across various industries use Fivetran with Amazon Redshift for efficient data integration and analysis.