# elt

ELT (extract, load, transform) is a data integration process that moves raw data from a source system to a target system, then transforms it within the target.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## How to Build a Modern Data Stack From the Ground Up | Blog | Fivetran

DevFeed: [How to Build a Modern Data Stack From the Ground Up | Blog | Fivetran](<https://devfeed.tech/articles/how-to-build-a-modern-data-stack-from-the-ground-up-blog-fivetran-141324.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/how-to-build-a-modern-data-stack-from-the-ground-up>)

Author: Fivetran

Published: 2026-11-18T06:13:15Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [analytics stack](<https://devfeed.tech/topics/analytics-stack.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [elt](<https://devfeed.tech/topics/elt.md>), [DataOps](<https://devfeed.tech/topics/dataops.md>), [Data serialization](<https://devfeed.tech/topics/data-serialization.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [bi-tools](<https://devfeed.tech/tags/bi-tools.md>), [business-intelligence](<https://devfeed.tech/tags/business-intelligence.md>), [business-logic](<https://devfeed.tech/tags/business-logic.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [data-driven](<https://devfeed.tech/tags/data-driven.md>), [data-ingestion](<https://devfeed.tech/tags/data-ingestion.md>), [data-lake](<https://devfeed.tech/tags/data-lake.md>), [data-platforms](<https://devfeed.tech/tags/data-platforms.md>), [data-quality](<https://devfeed.tech/tags/data-quality.md>), [data-stack](<https://devfeed.tech/tags/data-stack.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [decision-making](<https://devfeed.tech/tags/decision-making.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [modern-data-stack](<https://devfeed.tech/tags/modern-data-stack.md>), [plan](<https://devfeed.tech/tags/plan.md>)

### AI overview

Build the stack around a defined analytics use case: identify the data needed, then choose an ingestion tool that connects to those sources. Centralize data in a warehouse and consider a data lake for historical data; use transformation tools such as dbt with connectors such as Fivetran to prepare data for reporting. Keep business logic consistent and models representative of the real world. Choose a BI tool based on the tradeoff that matters most, such as usability or scalability, and consult the technical team to maintain a cohesive strategy. The article emphasizes data quality throughout: validate at ingestion and transformation stages, test continuously, and promote to production only when confident the data will not mislead users.

### Source excerpt

A data architecture expert gives a crash course on moving analytics to the cloud -- including a step-by-step plan to ensure success.

## The Data Integration Revolution: A Solution Architect's Perspective | Blog | Fivetran

DevFeed: [The Data Integration Revolution: A Solution Architect's Perspective | Blog | Fivetran](<https://devfeed.tech/articles/the-data-integration-revolution-a-solution-architect-s-perspective-blog-fivetran-141341.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/the-data-integration-revolution-a-solution-architects-perspective>)

Author: Dom Orsini

Published: 2026-11-18T06:13:15Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>), [data migrations](<https://devfeed.tech/topics/data-migrations.md>), [data-processing](<https://devfeed.tech/topics/data-processing.md>), [Tool](<https://devfeed.tech/topics/tool.md>)

Tags: [architect](<https://devfeed.tech/tags/architect.md>), [batch](<https://devfeed.tech/tags/batch.md>), [big-data](<https://devfeed.tech/tags/big-data.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloudera](<https://devfeed.tech/tags/cloudera.md>), [coding](<https://devfeed.tech/tags/coding.md>), [collaboration](<https://devfeed.tech/tags/collaboration.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [data](<https://devfeed.tech/tags/data.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [data-migration](<https://devfeed.tech/tags/data-migration.md>), [data-pipelines](<https://devfeed.tech/tags/data-pipelines.md>), [data-teams](<https://devfeed.tech/tags/data-teams.md>), [databases](<https://devfeed.tech/tags/databases.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [elt](<https://devfeed.tech/tags/elt.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [etl](<https://devfeed.tech/tags/etl.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [solution-architect](<https://devfeed.tech/tags/solution-architect.md>)

### AI overview

The article's central finding is that managed SaaS data integration with ELT and cloud data warehouses has made data delivery faster and less engineering-intensive, freeing data teams to focus on business use. It contrasts this with on-premise ETL, which required manual coding, hardware tuning, and close operational support, and big data/IaaS systems, which sped delivery but added interdependent services, maintenance burdens, sync bottlenecks, and technology churn. In the modern approach described, fully managed pipelines need minimal configuration, while analysts build SQL transformations; dbt adds version control and collaboration practices. The author says this reduces coordination and schema-change work, though the piece presents a solution architect's perspective and specifically promotes Fivetran.

### Source excerpt

Life for data professionals keeps getting better -- and more interesting.

## From Months to Days: How Autodesk Reinvented Its Data Ingestion Strategy | Blog | Fivetran

DevFeed: [From Months to Days: How Autodesk Reinvented Its Data Ingestion Strategy | Blog | Fivetran](<https://devfeed.tech/articles/from-months-to-days-how-autodesk-reinvented-its-data-ingestion-strategy-blog-fivetran-141321.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/how-autodesk-reinvented-its-data-ingestion-strategy>)

Author: Fivetran

Published: 2026-11-18T06:13:15Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [data lake](<https://devfeed.tech/topics/data-lake.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [copy](<https://devfeed.tech/topics/copy.md>), [Machine learning](<https://devfeed.tech/topics/machine-learning.md>)

Tags: [analytics](<https://devfeed.tech/tags/analytics.md>), [autodesk](<https://devfeed.tech/tags/autodesk.md>), [aws](<https://devfeed.tech/tags/aws.md>), [data](<https://devfeed.tech/tags/data.md>), [data-ingestion](<https://devfeed.tech/tags/data-ingestion.md>), [data-lake](<https://devfeed.tech/tags/data-lake.md>), [data-pipelines](<https://devfeed.tech/tags/data-pipelines.md>), [data-platform](<https://devfeed.tech/tags/data-platform.md>), [data-stack](<https://devfeed.tech/tags/data-stack.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [join](<https://devfeed.tech/tags/join.md>), [keep](<https://devfeed.tech/tags/keep.md>), [kinesis](<https://devfeed.tech/tags/kinesis.md>), [learning](<https://devfeed.tech/tags/learning.md>), [looker](<https://devfeed.tech/tags/looker.md>), [process](<https://devfeed.tech/tags/process.md>), [strategy](<https://devfeed.tech/tags/strategy.md>)

### AI overview

Autodesk replaced a patchwork of ingestion tools and custom scripts with two defined routes: Fivetran ingests structured sources into Snowflake, while AWS Kinesis sends high-volume unstructured product usage data to S3. Data moves between the repositories when needed; usage data can be promoted to Snowflake for analytics subject to privacy controls, and Snowflake snapshots are stored in S3 for history and machine learning. Autodesk's stated goal was to cut onboarding a dataset, including requirements, vendor setup, and security and privacy controls, from six months to six business days. The change reportedly freed engineers to focus on business problems and reduced urgent pipeline-breakage emails. The account attributes the approach to Autodesk's buy-over-build, simplicity, speed-to-impact, and privacy principles.

### Source excerpt

By replacing homemade ETL with automated ELT, Autodesk cut its data ingestion process from six months to six days.

## How to Launch Fivetran Through the Amazon Redshift Console | Blog | Fivetran

DevFeed: [How to Launch Fivetran Through the Amazon Redshift Console | Blog | Fivetran](<https://devfeed.tech/articles/how-to-launch-fivetran-through-the-amazon-redshift-console-blog-fivetran-141327.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/how-to-launch-fivetran-through-the-amazon-redshift-console>)

Author: Raman Kaler

Published: 2026-11-18T06:13:15Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [elt](<https://devfeed.tech/topics/elt.md>), [Amazon Web Services](<https://devfeed.tech/topics/aws.md>), [amazon](<https://devfeed.tech/topics/amazon.md>)

Tags: [amazon](<https://devfeed.tech/tags/amazon.md>), [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [blog](<https://devfeed.tech/tags/blog.md>), [console](<https://devfeed.tech/tags/console.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [integration](<https://devfeed.tech/tags/integration.md>), [launch](<https://devfeed.tech/tags/launch.md>), [native](<https://devfeed.tech/tags/native.md>), [redshift](<https://devfeed.tech/tags/redshift.md>)

### AI overview

Redshift customers can start a 14-day Fivetran trial from the cluster console, with cluster details prefilled for the connection. The instructions cover creating a cluster if needed, selecting Add AWS Partner integration and Fivetran, completing signup and email verification, then entering the Redshift password and choosing Save & Test. The cluster must be publicly accessible, and Fivetran IPs must be whitelisted in its security group. After choosing a source, setting a destination schema, and validating the connector, start the initial sync; the example uses Fivetran Log and produces a fivetran_logs schema and related tables.

### Source excerpt

Amazon Redshift supports native integration with Fivetran. Here's how to set it up.

## Fivetran wins three major Partner of the Year awards | Blog | Fivetran

DevFeed: [Fivetran wins three major Partner of the Year awards | Blog | Fivetran](<https://devfeed.tech/articles/fivetran-wins-three-major-partner-of-the-year-awards-blog-fivetran-141318.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/fivetran-wins-three-major-partner-of-the-year-awards>)

Author: Logan Welley

Published: 2026-11-18T06:13:15Z

Content type: news

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [databricks](<https://devfeed.tech/topics/databricks.md>), [elt](<https://devfeed.tech/topics/elt.md>), [BigQuery](<https://devfeed.tech/topics/bigquery.md>)

Tags: [awards](<https://devfeed.tech/tags/awards.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data](<https://devfeed.tech/tags/data.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [databricks](<https://devfeed.tech/tags/databricks.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [google](<https://devfeed.tech/tags/google.md>), [partner](<https://devfeed.tech/tags/partner.md>), [snowflake](<https://devfeed.tech/tags/snowflake.md>), [technology](<https://devfeed.tech/tags/technology.md>)

### AI overview

Fivetran says Google Cloud, Snowflake and Databricks each named it Partner of the Year, citing integration work and joint customer outcomes. For Google Cloud, customers can buy and launch connectors through its Marketplace, and Fivetran describes SAP replication and data movement into BigQuery. Snowflake recognized Fivetran for integration innovation; the article reports more than 2,000 joint customers and says over 60% sync databases, up more than 80% year over year from 2021. Databricks recognized expanded availability and enhancements for unifying data on its lakehouse. Fivetran also says a managed high-volume replication service for Databricks on Azure, AWS and Google Cloud was planned for that summer, supporting real-time replication from Oracle, SQL Server and SAP. These are company-reported claims in the supplied article excerpt.

### Source excerpt

Google, Snowflake and Databricks recognize us for exceptional cloud data integration technology.

## Analysis: Fivetran Is the Fastest-Growing Cloud ELT Provider | Blog | Fivetran

DevFeed: [Analysis: Fivetran Is the Fastest-Growing Cloud ELT Provider | Blog | Fivetran](<https://devfeed.tech/articles/analysis-fivetran-is-the-fastest-growing-cloud-elt-provider-blog-fivetran-141312.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/fivetran-is-fastest-growing-cloud-elt-provider>)

Author: Fivetran

Published: 2026-11-18T06:13:15Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [data transformation](<https://devfeed.tech/topics/data-transformation.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>), [BigQuery](<https://devfeed.tech/topics/bigquery.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [automation](<https://devfeed.tech/tags/automation.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [data-ingestion](<https://devfeed.tech/tags/data-ingestion.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [data-movement](<https://devfeed.tech/tags/data-movement.md>), [data-pipelines](<https://devfeed.tech/tags/data-pipelines.md>), [data-teams](<https://devfeed.tech/tags/data-teams.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [elt](<https://devfeed.tech/tags/elt.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [gartner](<https://devfeed.tech/tags/gartner.md>)

### AI overview

The text attributes Fivetran's growth to managed cloud data ingestion and ease of use. It quotes Gartner's 2020 market-share report, which says Fivetran nearly doubled revenue from 2019 to 2020 and identifies it as a vendor of choice for moving data from popular SaaS applications and databases into cloud warehouses. The described service uses prebuilt connectors, self-healing pipelines, minimal infrastructure management, and automatic normalization. It also offers in-warehouse SQL transformations powered by dbt, with version control, testing, and documentation. Gartner is quoted as calling this a more complete offering that could support future enterprise adoption and revenue growth.

### Source excerpt

Gartner recognizes Fivetran as the "vendor of choice" for enterprises looking to modernize their data infrastructure.

## Trends that will dominate analytics & BI in 2022 | Blog | Fivetran

DevFeed: [Trends that will dominate analytics & BI in 2022 | Blog | Fivetran](<https://devfeed.tech/articles/trends-that-will-dominate-analytics-bi-in-2022-blog-fivetran-141345.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/trends-that-will-dominate-analytics-bi-2022>)

Author: Fivetran

Published: 2026-11-18T06:13:15Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [DataOps](<https://devfeed.tech/topics/dataops.md>), [elt](<https://devfeed.tech/topics/elt.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [streaming data analytics](<https://devfeed.tech/topics/streaming-data-analytics.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [etl](<https://devfeed.tech/topics/etl.md>), [databricks](<https://devfeed.tech/topics/databricks.md>)

Tags: [2022](<https://devfeed.tech/tags/2022.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [apache](<https://devfeed.tech/tags/apache.md>), [apache-spark](<https://devfeed.tech/tags/apache-spark.md>), [automation](<https://devfeed.tech/tags/automation.md>), [beam](<https://devfeed.tech/tags/beam.md>), [bi](<https://devfeed.tech/tags/bi.md>), [bi-tools](<https://devfeed.tech/tags/bi-tools.md>), [big-data](<https://devfeed.tech/tags/big-data.md>), [boost](<https://devfeed.tech/tags/boost.md>), [building](<https://devfeed.tech/tags/building.md>), [business](<https://devfeed.tech/tags/business.md>), [business-intelligence](<https://devfeed.tech/tags/business-intelligence.md>), [chaos](<https://devfeed.tech/tags/chaos.md>), [dataops](<https://devfeed.tech/tags/dataops.md>), [elt](<https://devfeed.tech/tags/elt.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [managed](<https://devfeed.tech/tags/managed.md>), [trends](<https://devfeed.tech/tags/trends.md>)

### AI overview

The article predicts five shifts in analytics and BI for 2022: ELT pipelines becoming more continuous and fully managed, reducing reliance on brittle batch ETL; DataOps practices and features becoming more central, with dbt Labs cited for SQL-based warehouse transformations, lineage tracking, and version control; operational analytics making data available in frontline tools to support day-to-day decisions; BI tools enabling more collaborative work between data and business teams; and wider use of distributed processing frameworks such as Apache Spark, Beam, Flink, and PySpark. These are presented as forecasts, not measured outcomes.

### Source excerpt

Fully managed ELT, DataOps and more trends that will change the way we use data this year.

## From "Fluff Metrics" to a 360-Degree Customer View | Blog | Fivetran

DevFeed: [From "Fluff Metrics" to a 360-Degree Customer View | Blog | Fivetran](<https://devfeed.tech/articles/from-fluff-metrics-to-a-360-degree-customer-view-blog-fivetran-141319.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/from-fluff-metrics-to-a-360-degree-customer-view>)

Author: Fivetran

Published: 2026-11-18T06:13:15Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [Data Science](<https://devfeed.tech/topics/data-science.md>), [Google Analytics](<https://devfeed.tech/topics/google-analytics.md>), [elt](<https://devfeed.tech/topics/elt.md>), [Grafana](<https://devfeed.tech/topics/grafana.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [3](<https://devfeed.tech/tags/3.md>), [about](<https://devfeed.tech/tags/about.md>), [account](<https://devfeed.tech/tags/account.md>), [actions](<https://devfeed.tech/tags/actions.md>), [addition](<https://devfeed.tech/tags/addition.md>), [adopting](<https://devfeed.tech/tags/adopting.md>), [blog](<https://devfeed.tech/tags/blog.md>), [customer](<https://devfeed.tech/tags/customer.md>), [data](<https://devfeed.tech/tags/data.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [fluff](<https://devfeed.tech/tags/fluff.md>), [insights](<https://devfeed.tech/tags/insights.md>), [key](<https://devfeed.tech/tags/key.md>), [marketing](<https://devfeed.tech/tags/marketing.md>), [metrics](<https://devfeed.tech/tags/metrics.md>), [query](<https://devfeed.tech/tags/query.md>), [rapid](<https://devfeed.tech/tags/rapid.md>), [rich](<https://devfeed.tech/tags/rich.md>), [view](<https://devfeed.tech/tags/view.md>)

### AI overview

The article's central finding is that clicks, opens and conversions alone show campaign activity but may not establish whether marketing drove intended actions or revenue. Fivetran describes joining refreshed warehouse data from Marketo, Google Analytics, Pendo, PostgreSQL and Salesforce, alongside ad and other sources, to connect campaign touchpoints with product usage and downstream business outcomes. Its suggested workflow is to identify relevant sources, choose decision-linked KPIs, understand how tables relate, and test the analysis with an ad hoc query before building a monitoring dashboard. The author says prebuilt entity relationship diagrams helped with data modeling and reports setting up a Pendo integration in about 10 minutes. These are the author's company experience and recommendations; no quantified campaign results are provided.

### Source excerpt

We use Fivetran ourselves for rapid access to rich, query-ready marketing data -- the key to transformative insights.

## Fivetran vs. Supermetrics | Blog | Fivetran

DevFeed: [Fivetran vs. Supermetrics | Blog | Fivetran](<https://devfeed.tech/articles/fivetran-vs-supermetrics-blog-fivetran-140232.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/fivetran-vs-supermetrics>)

Author: Zarmina Niazie

Published: 2026-11-18T05:58:59Z

Content type: comparison

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [etl](<https://devfeed.tech/topics/etl.md>), [elt](<https://devfeed.tech/topics/elt.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [Data visualization](<https://devfeed.tech/topics/data-visualization.md>)

Tags: [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [applications](<https://devfeed.tech/tags/applications.md>), [automated](<https://devfeed.tech/tags/automated.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [aws](<https://devfeed.tech/tags/aws.md>), [azure](<https://devfeed.tech/tags/azure.md>), [azure-synapse](<https://devfeed.tech/tags/azure-synapse.md>), [blog](<https://devfeed.tech/tags/blog.md>), [cloud-data-warehouse](<https://devfeed.tech/tags/cloud-data-warehouse.md>), [company](<https://devfeed.tech/tags/company.md>), [comparison](<https://devfeed.tech/tags/comparison.md>), [comparisons](<https://devfeed.tech/tags/comparisons.md>), [data](<https://devfeed.tech/tags/data.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [integrate](<https://devfeed.tech/tags/integrate.md>), [marketing](<https://devfeed.tech/tags/marketing.md>), [sources](<https://devfeed.tech/tags/sources.md>), [vs](<https://devfeed.tech/tags/vs.md>)

### AI overview

The article contrasts Supermetrics' emphasis on moving marketing data to Excel, Google Sheets, and CSV-based workflows with Fivetran's automated pipelines into data warehouses. It says Supermetrics also supports some warehouse and cloud storage destinations, but connector compatibility, warehouse pricing, and a limited warehouse selection may matter; premium connectors can add costs. Fivetran describes incremental loads designed around warehouse APIs, query-ready schemas, adjustable sync intervals, and a broader set of application, file, and database connectors for combining marketing data with finance, sales, or product data. The article also highlights Fivetran's connector documentation and support, while acknowledging both platforms serve different needs and recommending trialing a solution before buying. These are claims from Fivetran's comparison article.

### Source excerpt

Trying to integrate your marketing data sources? Here are the fundamental differences between Fivetran and Supermetrics.

## Understanding Enterprise Customer Engagement With the Modern Data Stack | Blog | Fivetran

DevFeed: [Understanding Enterprise Customer Engagement With the Modern Data Stack | Blog | Fivetran](<https://devfeed.tech/articles/understanding-enterprise-customer-engagement-with-the-modern-data-stack-blog-fivetran-140265.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/understanding-enterprise-customer-engagement-with-the-modern-data-stack>)

Author: Ross Katz

Published: 2026-11-18T05:58:59Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [analytics stack](<https://devfeed.tech/topics/analytics-stack.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [elt](<https://devfeed.tech/topics/elt.md>), [etl](<https://devfeed.tech/topics/etl.md>), [schema-evolution](<https://devfeed.tech/topics/schema-evolution.md>), [Data Management](<https://devfeed.tech/topics/data-management.md>)

Tags: [analytics-workloads](<https://devfeed.tech/tags/analytics-workloads.md>), [api](<https://devfeed.tech/tags/api.md>), [azure-synapse](<https://devfeed.tech/tags/azure-synapse.md>), [b2b](<https://devfeed.tech/tags/b2b.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [cloud-data-warehouse](<https://devfeed.tech/tags/cloud-data-warehouse.md>), [connectors](<https://devfeed.tech/tags/connectors.md>), [crm](<https://devfeed.tech/tags/crm.md>), [customer-engagement](<https://devfeed.tech/tags/customer-engagement.md>), [enterprise](<https://devfeed.tech/tags/enterprise.md>), [modern-data-stack](<https://devfeed.tech/tags/modern-data-stack.md>)

### AI overview

Companies serving both individual and enterprise customers need separate, evolving data models and processes to understand leads, customer journeys, renewals, and retention. The article argues that operational databases, CRMs, and ERPs are built to drive actions, so customizing them for changing analytics needs can increase overhead, maintenance, and performance problems. It recommends moving operational data into a cloud data warehouse, analyzing it there, and sending useful results back to business systems. Custom pipelines can require substantial setup and upkeep, with challenges including API limits, change data capture, source schema changes, and expanding access needs. The proposed Modern Data Stack uses Fivetran connectors to load source data into warehouses such as BigQuery, Snowflake, Redshift, or Azure Synapse, alongside analytics tools and reverse ETL. This can shift engineering effort from migration plumbing to analysis, though the article presents these benefits as its recommendation rather than quantified results.

### Source excerpt

Companies with B2B and B2C channels face complex management challenges that a modern data stack can solve.

## How To Build a Data Pipeline: A Step-by-Step Guide

DevFeed: [How To Build a Data Pipeline: A Step-by-Step Guide](<https://devfeed.tech/articles/how-to-build-a-data-pipeline-a-step-by-step-guide-140200.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/build-a-data-pipeline>)

Author: Fivetran

Published: 2026-11-18T04:57:01Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>), [elt](<https://devfeed.tech/topics/elt.md>), [etl](<https://devfeed.tech/topics/etl.md>), [Data Quality](<https://devfeed.tech/topics/data-quality.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [api](<https://devfeed.tech/tags/api.md>), [architecture](<https://devfeed.tech/tags/architecture.md>), [automation](<https://devfeed.tech/tags/automation.md>), [batch](<https://devfeed.tech/tags/batch.md>), [cdc](<https://devfeed.tech/tags/cdc.md>), [cloud-based](<https://devfeed.tech/tags/cloud-based.md>), [compliance](<https://devfeed.tech/tags/compliance.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [how-to](<https://devfeed.tech/tags/how-to.md>)

### AI overview

A data pipeline moves data from sources through ingestion, processing, storage and workflows, with monitoring to catch system and data quality problems. The guide recommends inventorying sources, choosing batch or streaming ingestion based on needs, validating and transforming data, selecting destinations such as a warehouse, lake or lakehouse, and monitoring health, anomalies, alerts and logs. It contrasts ETL, which transforms before storage and can support masking before loading but becomes harder to scale as sources grow, with ELT, which loads first for faster availability and easier cloud scaling but can analyze large volumes more slowly. It also highlights automation, performance, reliability, scalability and security; ELT can still protect sensitive data through isolation, encryption and blocking or hashing before storage. The excerpt concludes that many organizations buy managed pipelines because building and maintaining connectors and components is labor-intensive.

### Source excerpt

Learn what a data pipeline is and how to build one.

## Automated date integration for HL7 files

DevFeed: [Automated date integration for HL7 files](<https://devfeed.tech/articles/automated-date-integration-for-hl7-files-140194.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/automated-date-integration-for-hl7-files>)

Author: David Millman

Published: 2026-11-18T04:42:41Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [etl](<https://devfeed.tech/topics/etl.md>)

Tags: [adt](<https://devfeed.tech/tags/adt.md>), [advanced](<https://devfeed.tech/tags/advanced.md>), [ascii](<https://devfeed.tech/tags/ascii.md>), [asterisk](<https://devfeed.tech/tags/asterisk.md>), [automated](<https://devfeed.tech/tags/automated.md>), [bucket](<https://devfeed.tech/tags/bucket.md>), [cdp](<https://devfeed.tech/tags/cdp.md>), [column](<https://devfeed.tech/tags/column.md>), [components](<https://devfeed.tech/tags/components.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [connectors](<https://devfeed.tech/tags/connectors.md>), [continuation](<https://devfeed.tech/tags/continuation.md>), [data](<https://devfeed.tech/tags/data.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [data-stack](<https://devfeed.tech/tags/data-stack.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [database](<https://devfeed.tech/tags/database.md>), [files](<https://devfeed.tech/tags/files.md>), [integration](<https://devfeed.tech/tags/integration.md>), [series](<https://devfeed.tech/tags/series.md>)

### AI overview

HL7 ingestion requires two parsing levels because records are nested and, unlike the EDI example, lack a record delimiter. The described Fivetran S3 setup uses an asterisk delimiter absent from the file so each line lands intact in a single COLUMN_0, and enables Headerless Files. In Snowflake, a view splits that column on pipes into RECORD_NAME and up to 52 fields; segment views then select record types, and a further view splits the MSH MESSAGE_TYPE on the caret into main and subtypes. The SQL string functions need adjustment for other CDPs. The ELT approach retains all raw rows in INITIAL, allowing segments to be parsed as needed and load-time breakages to be investigated and corrected in the CDP; the excerpt does not provide the other-platform SQL adjustments.

### Source excerpt

A continuation of our series on ASCII files; how to ingest data from HL7 files

## Automated data integration for EDI files

DevFeed: [Automated data integration for EDI files](<https://devfeed.tech/articles/automated-data-integration-for-edi-files-140193.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/automated-data-integration-for-edi-files>)

Author: David Millman

Published: 2026-11-18T04:42:41Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [Electronic data interchange](<https://devfeed.tech/topics/edi.md>), [elt](<https://devfeed.tech/topics/elt.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [17](<https://devfeed.tech/tags/17.md>), [2](<https://devfeed.tech/tags/2.md>), [3](<https://devfeed.tech/tags/3.md>), [actions](<https://devfeed.tech/tags/actions.md>), [added](<https://devfeed.tech/tags/added.md>), [advanced](<https://devfeed.tech/tags/advanced.md>), [aggregation](<https://devfeed.tech/tags/aggregation.md>), [all](<https://devfeed.tech/tags/all.md>), [allows](<https://devfeed.tech/tags/allows.md>), [also](<https://devfeed.tech/tags/also.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [ascii](<https://devfeed.tech/tags/ascii.md>), [aspect](<https://devfeed.tech/tags/aspect.md>), [automated](<https://devfeed.tech/tags/automated.md>), [data](<https://devfeed.tech/tags/data.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [files](<https://devfeed.tech/tags/files.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [integration](<https://devfeed.tech/tags/integration.md>), [series](<https://devfeed.tech/tags/series.md>)

### AI overview

The article demonstrates late-binding EDI ingestion with Fivetran: configure its S3 connector to treat each tilde-delimited row as one field and import headerless data into a raw table, then split the asterisk-delimited values in SQL views. Create a parsed view with enough columns for the longest segment, followed by separate views filtered by record name (such as BEG). Parsing syntax varies by destination: Snowflake, Databricks, BigQuery, and Redshift use different split functions or indexing conventions; segment views are described as platform-independent. The approach keeps raw data, postpones schema interpretation, and can expose unhandled segments and malformed data for analytics. The example omits type conversions, which the article says should be added in production. It presents this as an analytics workflow that augments existing EDI infrastructure, not a replacement for transactional processing.

### Source excerpt

A continuation of our series on ASCII files; how to ingest data from EDI files

## Automated data integration for CSV files

DevFeed: [Automated data integration for CSV files](<https://devfeed.tech/articles/automated-data-integration-for-csv-files-140192.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/automated-data-integration-for-csv-files>)

Author: David Millman

Published: 2026-11-18T04:00:45Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [CSV](<https://devfeed.tech/topics/csv.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [elt](<https://devfeed.tech/topics/elt.md>), [Parquet files in Amazon S3](<https://devfeed.tech/topics/parquet-files-in-amazon-s3.md>)

Tags: [ascii](<https://devfeed.tech/tags/ascii.md>), [automated](<https://devfeed.tech/tags/automated.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [csv](<https://devfeed.tech/tags/csv.md>), [data](<https://devfeed.tech/tags/data.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [files](<https://devfeed.tech/tags/files.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [integration](<https://devfeed.tech/tags/integration.md>)

### AI overview

Fivetran can ingest standard CSV files from an Amazon S3 bucket into a destination such as BigQuery with limited setup: configure the destination schema and table, bucket and optional folder path, then validate and start an initial sync. With file type and compression set to "infer," the connector handles supported formats based on extensions. It creates destination tables and infers column types from the data; types may be revised on later syncs if values change. Headers supply column names and are required. Loaded rows also include Fivetran metadata fields such as file and line identifiers and sync timestamps. The example assumes a valid CSV with consistent field counts and a header row. Its bucket is public for demonstration, with the article noting production setups would likely use different security configuration. The excerpt says similar functionality is available for Google Drive and FTP(s), and describes equivalent results across several supported destinations.

### Source excerpt

Use Fivetran to rapidly and automatically ingest CSV and other ASCII files of unknown structure.

## Automatically replicate formula field values from Salesforce | Blog | Fivetran

DevFeed: [Automatically replicate formula field values from Salesforce | Blog | Fivetran](<https://devfeed.tech/articles/automatically-replicate-formula-field-values-from-salesforce-blog-fivetran-140196.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/automatically-sync-formula-field-values-in-salesforce>)

Author: Natalie Waller

Published: 2026-11-18T04:00:45Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [data transformation](<https://devfeed.tech/topics/data-transformation.md>), [elt](<https://devfeed.tech/topics/elt.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>)

Tags: [about](<https://devfeed.tech/tags/about.md>), [administrator](<https://devfeed.tech/tags/administrator.md>), [all](<https://devfeed.tech/tags/all.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [analysts](<https://devfeed.tech/tags/analysts.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [analyze](<https://devfeed.tech/tags/analyze.md>), [annual-recurring-revenue](<https://devfeed.tech/tags/annual-recurring-revenue.md>), [api](<https://devfeed.tech/tags/api.md>), [approach](<https://devfeed.tech/tags/approach.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [blog](<https://devfeed.tech/tags/blog.md>), [core](<https://devfeed.tech/tags/core.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [field](<https://devfeed.tech/tags/field.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [replicate](<https://devfeed.tech/tags/replicate.md>), [salesforce](<https://devfeed.tech/tags/salesforce.md>), [values](<https://devfeed.tech/tags/values.md>)

### AI overview

Salesforce formula field values can change without updating a record's modified_at timestamp, so Fivetran cannot reliably detect those changes during incremental syncs and excludes formula fields from sync. The described workaround pairs a free Fivetran_formula_model system table, which detects enabled custom formulas and provides SQL translations, with Salesforce formula utils dbt models that create warehouse views of the calculated values. The excerpt says translations use Standard SQL plus destination-specific SQL for Snowflake, BigQuery and Redshift. Users can deploy a Quickstart model without coding or a dbt project, or install the package in their own dbt Core project to organize and automate view creation and use current model definitions. The excerpt does not establish support for other destinations.

### Source excerpt

Learn how to use Fivetran Transformations for dbt Core* to automatically generate views in your destination of fresh, reliable formula field values from Salesforce.

## Benchmarked: A data pipeline throughput analysis

DevFeed: [Benchmarked: A data pipeline throughput analysis](<https://devfeed.tech/articles/benchmarked-a-data-pipeline-throughput-analysis-140199.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/benchmarked-a-data-pipeline-throughput-analysis>)

Author: Eric O'Connor

Published: 2026-11-18T04:00:44Z

Content type: news

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [performance-engineering](<https://devfeed.tech/topics/performance-engineering.md>), [elt](<https://devfeed.tech/topics/elt.md>), [rdbms](<https://devfeed.tech/topics/rdbms.md>), [big-data](<https://devfeed.tech/topics/big-data.md>), [Analytics Pipeline](<https://devfeed.tech/topics/analytics-pipeline.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [ai-ml](<https://devfeed.tech/tags/ai-ml.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [benchmark](<https://devfeed.tech/tags/benchmark.md>), [benchmarks](<https://devfeed.tech/tags/benchmarks.md>), [change-data-capture](<https://devfeed.tech/tags/change-data-capture.md>), [connectors](<https://devfeed.tech/tags/connectors.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [data-pipelines](<https://devfeed.tech/tags/data-pipelines.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [database](<https://devfeed.tech/tags/database.md>), [databases](<https://devfeed.tech/tags/databases.md>), [dataset](<https://devfeed.tech/tags/dataset.md>), [details](<https://devfeed.tech/tags/details.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [load-testing](<https://devfeed.tech/tags/load-testing.md>), [testing](<https://devfeed.tech/tags/testing.md>), [throughput](<https://devfeed.tech/tags/throughput.md>)

### AI overview

Fivetran's excerpt describes a HammerDB TPROC-C benchmark for historical database loads, using an approximately 1 TB dataset with rows widened to about 1 KB to approximate customer data. The test measures throughput as dataset size divided by elapsed sync time; the stated full sync to Snowflake took 1 hour 30 minutes to 1 hour 40 minutes, but the excerpt omits the numeric throughput results and detailed configuration. Fivetran says its sync process uses checkpoints to resume after interruptions and splits large tables into chunks to limit transaction duration. It attributes performance improvements to greater parallelism and optimized warehouse loading patterns.

### Source excerpt

Looking under the hood and load testing Fivetran's data pipelines.

## Get Started With the "T" in ELT | Blog | Fivetran

DevFeed: [Get Started With the "T" in ELT | Blog | Fivetran](<https://devfeed.tech/articles/get-started-with-the-t-in-elt-blog-fivetran-140259.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/start-with-t-elt>)

Author: Charles Wang

Published: 2026-11-18T03:38:23Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>)

Tags: [aggregate](<https://devfeed.tech/tags/aggregate.md>), [aggregate-functions](<https://devfeed.tech/tags/aggregate-functions.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [arithmetic](<https://devfeed.tech/tags/arithmetic.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [computing](<https://devfeed.tech/tags/computing.md>), [conversion](<https://devfeed.tech/tags/conversion.md>), [cost](<https://devfeed.tech/tags/cost.md>), [data](<https://devfeed.tech/tags/data.md>), [data-analysis](<https://devfeed.tech/tags/data-analysis.md>), [data-validation](<https://devfeed.tech/tags/data-validation.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [deduplication](<https://devfeed.tech/tags/deduplication.md>), [elt](<https://devfeed.tech/tags/elt.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [formatting](<https://devfeed.tech/tags/formatting.md>), [functions](<https://devfeed.tech/tags/functions.md>), [id](<https://devfeed.tech/tags/id.md>), [identifier](<https://devfeed.tech/tags/identifier.md>), [reporting](<https://devfeed.tech/tags/reporting.md>)

### AI overview

Fivetran Transformations applies scheduled, materialized SQL transformations that create or replace warehouse tables; each script names its destination schema and table. The article contrasts these stored results with views, which run queries on access and may perform poorly on large tables or complex queries. It groups transformations into revising data (cleaning, conversion, deduplication and validation), computing values (calculations, summaries and pivots), separating data (splitting and filtering), and combining sources (joins, unions and integration). Examples cover normalizing text and units, creating participant identifiers after excluding missing emails, calculating BMI and summary statistics, joining percentile results, pivoting enumerated activity values, and splitting comma-separated nicknames. The article says the nickname example works only in Snowflake at the time of writing; when a platform lacks PIVOT, it shows conditional aggregation as an alternative.

### Source excerpt

Use Fivetran Transformations to prepare your data for reporting.

## Introducing the Fivetran dbt Packages for GitHub | Blog | Fivetran

DevFeed: [Introducing the Fivetran dbt Packages for GitHub | Blog | Fivetran](<https://devfeed.tech/articles/introducing-the-fivetran-dbt-packages-for-github-blog-fivetran-140218.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/fivetran-dbt-github>)

Author: Fivetran

Published: 2026-11-18T03:07:10Z

Content type: release

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [GitHub](<https://devfeed.tech/topics/github.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [etl](<https://devfeed.tech/topics/etl.md>), [elt](<https://devfeed.tech/topics/elt.md>), [GitHub Issues](<https://devfeed.tech/topics/github-issues.md>)

Tags: [advanced](<https://devfeed.tech/tags/advanced.md>), [analytics](<https://devfeed.tech/tags/analytics.md>), [api](<https://devfeed.tech/tags/api.md>), [challenges](<https://devfeed.tech/tags/challenges.md>), [code](<https://devfeed.tech/tags/code.md>), [completion](<https://devfeed.tech/tags/completion.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [dependencies](<https://devfeed.tech/tags/dependencies.md>), [development](<https://devfeed.tech/tags/development.md>), [efficiency](<https://devfeed.tech/tags/efficiency.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [github](<https://devfeed.tech/tags/github.md>), [github-api](<https://devfeed.tech/tags/github-api.md>), [github-issues](<https://devfeed.tech/tags/github-issues.md>), [package](<https://devfeed.tech/tags/package.md>), [packages](<https://devfeed.tech/tags/packages.md>), [software](<https://devfeed.tech/tags/software.md>), [software-delivery](<https://devfeed.tech/tags/software-delivery.md>)

### AI overview

The Fivetran dbt package for GitHub joins API data about issues, pull requests, assignments, reviewers, and history to support engineering workflow metrics. Its outputs include enriched issue and pull request records plus daily, weekly, monthly, and quarterly counts of items opened and closed. The models expose measures such as time to completion and durations between review requests, reviews, and merges, which can help teams track workload balance, PR lifecycle, and completion trends. The package relies on Fivetran's GitHub connector and a separate dbt source package, which is downloaded with it; that source package lightly cleans data, defines tables and columns, and tests source data. GitHub data can also be combined with Jira or Asana for a broader software delivery view.

### Source excerpt

Transform your GitHub data integrated through Fivetran with this dbt package to gain insight into the state of code issues and the complete software delivery process.

## In uncertain markets, businesses invest in data | Blog | Fivetran

DevFeed: [In uncertain markets, businesses invest in data | Blog | Fivetran](<https://devfeed.tech/articles/in-uncertain-markets-businesses-invest-in-data-blog-fivetran-140240.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/in-uncertain-markets-businesses-invest-in-data>)

Author: Fivetran

Published: 2026-11-18T03:07:10Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [analytics stack](<https://devfeed.tech/topics/analytics-stack.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Data analysis](<https://devfeed.tech/topics/data-analysis.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [data](<https://devfeed.tech/topics/data.md>), [elt](<https://devfeed.tech/topics/elt.md>), [etl](<https://devfeed.tech/topics/etl.md>)

Tags: [agile](<https://devfeed.tech/tags/agile.md>), [andreessen-horowitz](<https://devfeed.tech/tags/andreessen-horowitz.md>), [aws](<https://devfeed.tech/tags/aws.md>), [business-operations](<https://devfeed.tech/tags/business-operations.md>), [c-suite](<https://devfeed.tech/tags/c-suite.md>), [career](<https://devfeed.tech/tags/career.md>), [cio](<https://devfeed.tech/tags/cio.md>), [cios](<https://devfeed.tech/tags/cios.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [cloud-data](<https://devfeed.tech/tags/cloud-data.md>), [construction](<https://devfeed.tech/tags/construction.md>), [customer](<https://devfeed.tech/tags/customer.md>), [customer-experience](<https://devfeed.tech/tags/customer-experience.md>), [customers](<https://devfeed.tech/tags/customers.md>), [data](<https://devfeed.tech/tags/data.md>), [data-stack](<https://devfeed.tech/tags/data-stack.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [invest](<https://devfeed.tech/tags/invest.md>), [markets](<https://devfeed.tech/tags/markets.md>), [modern-data-stack](<https://devfeed.tech/tags/modern-data-stack.md>)

### AI overview

The article argues that accurate, current data consolidated for holistic analysis can help businesses respond to volatile markets by improving efficiency, identifying growth opportunities and speeding decisions across an organization. It describes Schüttflix centralizing customer, supplier and partner data to improve supply chain coverage and efficiency; 1-800-Flowers combining internal and purchased data to personalize customer experiences and find cross-sell and upsell opportunities; and a sportswear brand joining apparel and fitness-app data to build customer profiles. A logistics customer used broad, rapid data access to involve more employees in decisions. These are company-reported examples; the excerpt does not quantify results or compare data platforms.

### Source excerpt

Fivetran and our modern data stack partners are poised to thrive.

## Why You Need Automated Schema Migration | Blog | Fivetran

DevFeed: [Why You Need Automated Schema Migration | Blog | Fivetran](<https://devfeed.tech/articles/why-you-need-automated-schema-migration-blog-fivetran-140195.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/automated-schema-migration>)

Author: Charles Wang

Published: 2026-11-18T03:07:10Z

Content type: article

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [schema design](<https://devfeed.tech/topics/schema-design.md>), [elt](<https://devfeed.tech/topics/elt.md>), [etl](<https://devfeed.tech/topics/etl.md>)

Tags: [automated](<https://devfeed.tech/tags/automated.md>), [data-integration](<https://devfeed.tech/tags/data-integration.md>), [data-pipeline](<https://devfeed.tech/tags/data-pipeline.md>), [downtime](<https://devfeed.tech/tags/downtime.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [migration](<https://devfeed.tech/tags/migration.md>), [schema](<https://devfeed.tech/tags/schema.md>)

### AI overview

Upstream SaaS schema changes can break traditional ETL scripts, interrupting loads and leaving analysts with stale data. The article contrasts raw ELT, which stores data without adapting to its schema, with outsourced automated ELT that understands source models and maintains pipelines. Fivetran says it propagates changes incrementally: it adds new columns and backfills when applicable; soft-deletes removed columns and sets future records to NULL while retaining history; handles datatype changes by retaining the old column and creating one able to accommodate both types; starts syncing new tables; and leaves deleted source tables in the warehouse. These practices aim to preserve data and avoid downtime, though datatype handling may require users to create views.

### Source excerpt

Schema changes can completely disrupt a data pipeline. Automated data integration offers a solution.

## Announcing Fivetran dbt for NetSuite | Blog | Fivetran

DevFeed: [Announcing Fivetran dbt for NetSuite | Blog | Fivetran](<https://devfeed.tech/articles/announcing-fivetran-dbt-for-netsuite-blog-fivetran-140219.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/fivetran-dbt-netsuite>)

Author: Fivetran

Published: 2026-11-18T03:07:10Z

Content type: release

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>)

Tags: [amazon-redshift](<https://devfeed.tech/tags/amazon-redshift.md>), [api](<https://devfeed.tech/tags/api.md>), [apis](<https://devfeed.tech/tags/apis.md>), [automated](<https://devfeed.tech/tags/automated.md>), [automatically](<https://devfeed.tech/tags/automatically.md>), [balance-sheet](<https://devfeed.tech/tags/balance-sheet.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [blog](<https://devfeed.tech/tags/blog.md>), [cloud-data-warehouse](<https://devfeed.tech/tags/cloud-data-warehouse.md>), [coding](<https://devfeed.tech/tags/coding.md>), [core](<https://devfeed.tech/tags/core.md>), [data-cleaning](<https://devfeed.tech/tags/data-cleaning.md>), [data-flow](<https://devfeed.tech/tags/data-flow.md>), [data-pipelines](<https://devfeed.tech/tags/data-pipelines.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [netsuite](<https://devfeed.tech/tags/netsuite.md>), [package](<https://devfeed.tech/tags/package.md>), [reports](<https://devfeed.tech/tags/reports.md>)

### AI overview

Fivetran's dbt package for NetSuite transforms warehouse data into balance sheets, income statements, and related reporting tables, joining the 17 tables needed for the income statement. Fivetran handles extraction from NetSuite's JDBC driver and loading, including API and schema changes; dbt applies editable SQL transformations in the warehouse. The package is described as compatible with Snowflake, Amazon Redshift, and Google BigQuery, and can be scheduled in dbt Cloud. Using the JDBC connector requires a NetSuite SuiteAnalytics Connect license for access to the full data set, along with Fivetran, the package, dbt Core or Cloud, and a visualization tool. The article contrasts this approach with NetSuite's constrained built-in reporting and describes inconsistencies and missing tables in its SOAP API experience; it does not provide comparative performance results.

### Source excerpt

Our first dbt package allows you to quickly create reports, add transformations, and connect more data sources.

## Fivetran gives analysts a new way to transform data | Blog | Fivetran

DevFeed: [Fivetran gives analysts a new way to transform data | Blog | Fivetran](<https://devfeed.tech/articles/fivetran-gives-analysts-a-new-way-to-transform-data-blog-fivetran-140224.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/fivetran-gives-analysts-a-new-way-to-transform-data>)

Author: Fivetran

Published: 2026-11-18T03:07:10Z

Content type: tutorial

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [DataOps](<https://devfeed.tech/topics/dataops.md>)

Tags: [analysts](<https://devfeed.tech/tags/analysts.md>), [best-practices](<https://devfeed.tech/tags/best-practices.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [cli](<https://devfeed.tech/tags/cli.md>), [code](<https://devfeed.tech/tags/code.md>), [command-line](<https://devfeed.tech/tags/command-line.md>), [compute-costs](<https://devfeed.tech/tags/compute-costs.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [connectors](<https://devfeed.tech/tags/connectors.md>), [data-freshness](<https://devfeed.tech/tags/data-freshness.md>), [data-integrity](<https://devfeed.tech/tags/data-integrity.md>), [data-orchestration](<https://devfeed.tech/tags/data-orchestration.md>), [data-teams](<https://devfeed.tech/tags/data-teams.md>), [data-warehouse](<https://devfeed.tech/tags/data-warehouse.md>), [databricks](<https://devfeed.tech/tags/databricks.md>), [dbt](<https://devfeed.tech/tags/dbt.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [orchestration](<https://devfeed.tech/tags/orchestration.md>), [platform](<https://devfeed.tech/tags/platform.md>), [scheduling](<https://devfeed.tech/tags/scheduling.md>)

### AI overview

Fivetran Transformations adds a UI orchestration layer for dbt Core, letting teams coordinate connector syncs and SQL model runs from the same platform. Its integrated schedule runs transformations after upstream connectors finish syncing and in dependency order; the article says this can improve freshness, avoid unnecessary runs, reduce compute costs, and help keep related tables consistent. Users can instead choose a custom time-based schedule. Initial setup still requires dbt Core, an IDE, version control, a supported destination (BigQuery, Snowflake, Redshift, Databricks, or PostgreSQL), command-line project creation, warehouse credentials, and a populated dbt project. The GUI simplifies ongoing scheduling and monitoring, while dbt development and setup remain code-based.

### Source excerpt

With integrated scheduling, Fivetran Transformations enables data orchestration from a single platform with minimal configuration and code.

## Press Release: Introducing Fivetran Transformations | Blog | Fivetran

DevFeed: [Press Release: Introducing Fivetran Transformations | Blog | Fivetran](<https://devfeed.tech/articles/press-release-introducing-fivetran-transformations-blog-fivetran-140264.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/transformations-press-release>)

Author: Fivetran

Published: 2026-11-18T02:47:08Z

Content type: release

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [elt](<https://devfeed.tech/topics/elt.md>), [etl](<https://devfeed.tech/topics/etl.md>), [Amazon Redshift](<https://devfeed.tech/topics/amazon-redshift.md>)

Tags: [2019](<https://devfeed.tech/tags/2019.md>), [automated](<https://devfeed.tech/tags/automated.md>), [data](<https://devfeed.tech/tags/data.md>), [enterprise](<https://devfeed.tech/tags/enterprise.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [press-release](<https://devfeed.tech/tags/press-release.md>), [tool](<https://devfeed.tech/tags/tool.md>), [transformation](<https://devfeed.tech/tags/transformation.md>), [warehouse](<https://devfeed.tech/tags/warehouse.md>)

### AI overview

Fivetran Transformations runs SQL inside the data warehouse when new data arrives or on a schedule, extending Fivetran's automated connector platform. The release says keeping transformations in the warehouse preserves original data for restoration and can aid scalability and recovery; integrated pipeline management, logging, and notifications help teams diagnose errors. Snowflake users could trial the feature at launch, while support for BigQuery, Redshift, and Azure was described as forthcoming. These are claims from the 2019 announcement.

### Source excerpt

Fivetran introduces new enterprise-ready automated transformation tool featuring in-warehouse data change.

## Fivetran Wins Key Snowflake Partner Award: Best Customer-Focused Integration | Blog | Fivetran

DevFeed: [Fivetran Wins Key Snowflake Partner Award: Best Customer-Focused Integration | Blog | Fivetran](<https://devfeed.tech/articles/fivetran-wins-key-snowflake-partner-award-best-customer-focused-integration-blog-fivetran-140256.md>)

Original publisher: [Read original article](<https://wf.fivetran.com/blog/snowflake-integration-award>)

Author: Fivetran

Published: 2026-11-18T02:47:08Z

Content type: news

Language: en

Sources: [Fivetran Blog](<https://devfeed.tech/sources/fivetran-blog.md>)

Topics: [data-engineering](<https://devfeed.tech/topics/data-engineering.md>), [elt](<https://devfeed.tech/topics/elt.md>)

Tags: [2019](<https://devfeed.tech/tags/2019.md>), [automation](<https://devfeed.tech/tags/automation.md>), [award](<https://devfeed.tech/tags/award.md>), [best](<https://devfeed.tech/tags/best.md>), [cloud](<https://devfeed.tech/tags/cloud.md>), [complete](<https://devfeed.tech/tags/complete.md>), [connect](<https://devfeed.tech/tags/connect.md>), [connectors](<https://devfeed.tech/tags/connectors.md>), [customer](<https://devfeed.tech/tags/customer.md>), [customers](<https://devfeed.tech/tags/customers.md>), [engineering](<https://devfeed.tech/tags/engineering.md>), [fivetran](<https://devfeed.tech/tags/fivetran.md>), [integration](<https://devfeed.tech/tags/integration.md>), [partner](<https://devfeed.tech/tags/partner.md>), [san-francisco](<https://devfeed.tech/tags/san-francisco.md>), [snowflake](<https://devfeed.tech/tags/snowflake.md>), [snowflake-partner](<https://devfeed.tech/tags/snowflake-partner.md>), [snowflake-summit](<https://devfeed.tech/tags/snowflake-summit.md>), [speed](<https://devfeed.tech/tags/speed.md>), [summit](<https://devfeed.tech/tags/summit.md>)

### AI overview

Snowflake awarded Fivetran Best Customer-Focused Integration at its 2019 Summit, recognizing Partner Connect, which lets customers set up Fivetran connectors in the Snowflake UI, and Fivetran's rapid delivery of a connector in response to a customer request. The companies cited shared goals of ease of use and rapid insights, and reported more than 180 joint customers at the time.

### Source excerpt

At Snowflake Summit 2019 in San Francisco, Snowflake honored Fivetran for its engineering speed and seamless integration with Snowflake via Partner Connect.

[Next page](<https://devfeed.tech/topics/elt.md?cursor=WyIyMDI2LTExLTE4VDAyOjQ3OjA4KzAwOjAwIiwgIjM3NTZlOWVjLWZjMWUtNGMxNi1iNWRhLWQxZTE0NGQ2MzhjMSJd>)