Softwr

Machine Learning & Data Science · head to head

Amazon Redshift ML vs Alteryx

Amazon Redshift ML logo

Amazon Redshift ML

Machine Learning & Data Science

Create machine learning models using SQL

From
Free
Rated
-
Alteryx logo

Alteryx

Machine Learning & Data Science

Analytics automation platform

From
Free
Rated
-

The short version

  • Each has a real cost: Amazon Redshift ML free tier covers only two CREATE MODEL requests per month for two months, capped at 100,000 cells per request; beyond that training is metered at $20 per million cells for the first 10 million, dropping in tiers to $7 per million cells over 100 million; Alteryx starter is $250 per user per month billed annually, and the Professional and Enterprise editions are quote-only
  • They diverge on capability: Amazon Redshift ML covers SQL-based ML, Alteryx covers Data preparation.

Where they differ

Only the attributes on which Amazon Redshift ML and Alteryx actually diverge.

Attributes where Amazon Redshift ML and Alteryx differ
AttributeAmazon Redshift MLAlteryx
Pricing modelusage-basedsubscription
PlatformsWebWindows, Web
Founded20061997

Identical on both: starting price (Free), free tier (Yes), user rating (Not yet rated), category (Machine Learning & Data Science).

What each one covers

Drawn from each product's published feature list. An absence here means we hold no record of it - not that the product lacks it.

Only in Amazon Redshift ML

  • SQL-based ML
  • AutoML
  • SageMaker integration
  • BYOM support
  • In-database predictions
  • Amazon Redshift
  • SageMaker
  • S3

Only in Alteryx

  • Data preparation
  • Data blending
  • Predictive analytics
  • Spatial analytics
  • Reporting
  • Python
  • R
  • Snowflake

Both cover

  • Web support

What people use each for

The jobs each tool is most often brought in to do.

Amazon Redshift ML

  • Training and running machine learning models directly from SQL inside Amazon Redshiftnot Alteryx

Alteryx

  • Data preparation and building AI-ready datasetsnot Amazon Redshift ML
  • Predictive analytics without writing codenot Amazon Redshift ML
  • Automating and orchestrating repeatable analytics workflowsnot Amazon Redshift ML
  • Enterprise reporting with governed, reusable logicnot Amazon Redshift ML
  • Connecting to Snowflake, Databricks and cloud warehouses alongside on-premises systemsnot Amazon Redshift ML

Where each one falls short

Documented limitations, not opinions. Every one is a constraint you would hit in normal use.

Amazon Redshift ML

  • Free tier covers only two CREATE MODEL requests per month for two months, capped at 100,000 cells per request; beyond that training is metered at $20 per million cells for the first 10 million, dropping in tiers to $7 per million cells over 100 million

Alteryx

  • Starter is $250 per user per month billed annually, and the Professional and Enterprise editions are quote-only
  • Automation runs are metered, with 50 included on Starter and 15,000 on Professional, and more must be bought
  • Cost depends on three separate dimensions at once: edition, user role and automation capacity
  • Advanced analytics, governance and orchestration are withheld from the entry edition

Pricing, plan by plan

Amazon Redshift ML

Free
  • Free TrialFree
    • 2-month trial
    • 750 DC2.Large hours
  • On-Demand$0.25/hour
    • Per-node pricing
    • SageMaker training

Alteryx

Free
  • TrialFree
    • 14-day trial
    • Full features
  • Designer Desktop$5195/year
    • Data prep
    • Blending
    • Analytics

Which should you pick?

Choose Amazon Redshift ML if

  • You need sql-based ml.
  • You want to start without paying.
  • You also want automl.

Choose Alteryx if

  • You need data preparation.
  • You want to start without paying.
  • You work on Windows, Web.
  • You also want data blending.

Questions people ask

Is Amazon Redshift ML or Alteryx better?
Neither clearly leads. Amazon Redshift ML starts at Free and Alteryx at Free, and user ratings are close enough to be indistinguishable. Choose on capability and platform support.
Which is cheaper, Amazon Redshift ML or Alteryx?
Amazon Redshift ML starts at Free and Alteryx at Free.
Does Amazon Redshift ML or Alteryx run on more platforms?
Amazon Redshift ML runs on Web. Alteryx runs on Windows, Web.
Can I use Amazon Redshift ML for free?
Both have a free tier, so you can try either at no cost before committing.
What is Amazon Redshift ML best used for?
Amazon Redshift ML is most often used for training and running machine learning models directly from sql inside amazon redshift. Of those, training and running machine learning models directly from sql inside amazon redshift is not what Alteryx is typically brought in for.
What can Amazon Redshift ML do that Alteryx cannot?
Amazon Redshift ML covers SQL-based ML, AutoML, SageMaker integration, BYOM support. Alteryx covers Data preparation, Data blending, Predictive analytics, Spatial analytics. Both handle Web support.

Related pages

Other head to heads