New Feature: Recursive Transforms

At Ascend we see all sorts of different pipelines. One pattern we see quite often is that of change data capture (“CDC”) from databases and data warehouses, followed by data set reconstitution. Doing this data set reconstitution usually requires a full reduction — a transform in which you iterate over all records to find those representative of the latest state. This can become inefficient over time, however, as greater and greater percentages of any given data set become “stale”.

Data Lake ETL Tutorial: Transforming Data

Now that you’ve learned to Extract data with Ascend, this tutorial will give you an overview of the “T” in ETL, namely, how to start transforming your data before you load it into the final destination. We will use SQL in this example, but Ascend also supports...

New: support for 75 more SQL functions

SQL is one of the most well established, and powerful languages for working with data. It first emerged in the 1970s as a powerful domain-specific language (DSL) for managing data in relational database management systems (RDBMS), and has become one of the longest...

New Research Reveals 97% of Data Teams Are at or Over Capacity

To Increase Bandwidth and Support Overburdened Teams, 89% of Data Scientists, Data Engineers, and Enterprise Architects Currently Use or Plan to Adopt Automation, Low-Code, or No-Code Technologies PALO ALTO, Calif. – July 23, 2020 – Ascend.io, the data engineering...

How We’re Helping Drive Efficiency & Reduce Spend

“A penny saved is a penny invested” — invested in the longevity of our companies, of our customers, and of our employees. Today we’re rolling out a number of initiatives to help our customers do more while spending less.

Why Data Pipelines Desperately Need Orchestration

Despite technological innovations in business intelligence (BI), data processing, data warehousing, and other applications, there is still a huge gap in connecting and orchestrating the movement of data between these systems in data pipeline development…

Data Engineering Podcast | Replatforming Your Dataflows

Reposted from: Building a reliable data platform is a neverending task. Even if you have a process that works for you and your business there can be unexpected events that require a change in your platform architecture. In this episode the head of data for Mayvenn...

TDWI Best Practices Report | Faster Insights from Faster Data

This TDWI Best Practices Report examines experiences, practices, and technology trends that focus on identifying bottlenecks and latencies in the data’s life cycle, from sourcing and collection to delivery to users, applications, and AI programs for analysis,...

Pin It on Pinterest