Ascend.io, Author at Ascend.io

How-to: Redshift Data Ingest & ETL with Ascend.io

This How-to will provide you with an overview of how to ingest data into Redshift by building a production pipeline that automatically keeps data up to date, retries failures, and notifies upon any irrecoverable issues.

New Feature: Scala & Java Transforms

Today we’re excited to formally announce support for Scala & Java transforms. Not only does this expand our support to two of the most popular languages amongst data engineers, but marries this capability with the advanced orchestration and optimizations provided by Ascend.

How-to: Snowflake Data Ingest & ETL with Ascend.io

This How-to will provide you with an overview of how to ingest data into Snowflake by building a production pipeline that automatically keeps data up to date, retries failures, and notifies upon any irrecoverable issues.

Data Lake ETL Tutorial: Transforming Data

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 Python/PySpark and Scala/Java transformations as well.

Data Lake ETL Tutorial: Using Ascend No- and Low-Code Connectors to Load Data

Now that we’ve extracted some data from S3, cleaned it up using a SQL transform, we can start on the “L” of ETL and write our data back out to our data lake. Follow this guide to learn how.

Azure Beta or: How I Learned to Stop Worrying and Love the Kube

We run everything on Kubernetes and manage system state in MySQL plus a large scale blob store (Google Storage/S3/Azure Blob Storage).

How HNI Drives Manufacturing Digital Transformation with Data Pipelines

HNI Corporation is a US$2.2B workplace furnishings and hearth provider, with 19 distinct brands and global manufacturing sites. HNI is driving digital transformation of their business with data. Read below on how their decision sciences team continually improves business operations with the use of data, analytics, and machine learning.

New: support for 75 more SQL functions

We’re announcing the addition of 75 new SQL functions that are now available in every customer environment by default. This includes powerful new functions like BOOL_AND, COUNT_IF, FIND_IN_SET, MAX_BY, WEEKDAY, and well, 70 more!!!

Queryable Dataflows: Combining the Interactivity of Warehouses with the Scale of Pipelines

Now in Ascend, all stages of all Dataflows are queryable without switching tools or disrupting your development process. As part of this capability, we’ve built an interactive query editor that lets you interact with Connectors and Transforms in Dataflows, as well as Data Feeds broadcasting from other Data Services, as though they are read-only tables in a SQL database.