Having access to data is great, but actually using that data can be slow and expensive.
Egress can be expensive and slow when accessing data from diverse data sources, or when moving data from different databases to use with an analytics tool or platform. In fact, for many organizations, egress costs are one of the largest operational expenses across their entire data and analytics stack. Common problems associated with data movement can include:
- Increased costs
- Data latency and data transfer delays
- Network congestion
- Inefficient utilization of database capabilities
A more efficient way to do things is by utilizing pushdown processing – or, pushing the job to run directly with the processing power of your cloud data warehouse, rather than moving data in and out each time it’s needed. With the Alteryx Analytics Cloud Platform, you can use pushdown processing for every step of the analytics journey.
Optimize Your Analytics with Alteryx’s Pushdown Processing
Pushdown processing performs the data transformation process inside the cloud data warehouse, removing the need to egress data that’s already been loaded, and allowing for nearly infinite scalability of processing resources.
With Alteryx, you can do all this automatically without any code, special tools, or extra steps. All you have to do is connect the Alteryx Analytics Cloud Platform to a database that supports pushdown processing, select that database as the processing engine, and Alteryx will take care of the rest.
Here are some of the engines we support. (For a full list, see our latest documentation)
- Snowflake
- Databricks
- Google BigQuery
- Amazon Redshift
- Oracle DB
- PostgreSQL
- MS SQL Server
- Azure Synapse
Performing data transformation inside your cloud data warehouse can greatly accelerate the analytics process while significantly reducing expenses for the business. Here are a few of the main benefits.
Efficiency
You can save on the large amount of data that needs to pass between your databases and the Alteryx Analytics Platform, leading to noticeable performance gains.
Faster Processing
Using the native scalability of your cloud data warehouse can enable extremely fast processing speeds, leading to faster and more accurate decision-making.
Reduced Costs
Pushdown processing can reduce or eliminate egress costs, which are one of the top expenses for many IT departments related to their analytics stack.
How to Get Started
You can scale your processing resources up and down as needed for your business by using the Alteryx Analytics Cloud Platform with any of your current or future workflows.
If you haven’t used the Alteryx Analytics Cloud, you can start a trial or take a product tour.
Any data you move from your databases to Alteryx can be analyzed through automation to uncover root cause explanations, build advanced machine learning models, and deliver spatial analysis.