Pricing calculator

Presto Training & Learning Center

The Ahana™ Learning Center covers beginner to advanced level Presto topics, questions, and answers to help you learn Presto.

Topics

How to Query Parquet Files using Amazon Athena | Ahana

Mar 9, 20225 min read

Querying Parquet Files using Amazon Athena Parquet is one of the latest file formats with many advantages over some of the more commonly used formats like CSV and JSON. Specifically, … Continue reading How to Query Parquet Files using Amazon Athena | Ahana

Configuring RaptorX – a multi-level caching with Presto

Mar 8, 202211 min read

RaptorX Background and Context Meta introduced a multi-level cache at PrestoCon 2021. Code-named the “RaptorX Project,” it aims to make Presto 10x faster on Meta- scale petabyte workloads. Here at … Continue reading Configuring RaptorX – a multi-level caching with Presto

AWS Lake Formation Blueprints | Amazon Blueprint Types

Mar 7, 20222 min read

This article is focused on the first step and how AWS Lake Formation Blueprints can make that easy and automated. Before you can run analytics to get insights, you need your data continuously pooling into your lake!

Presto Equivalent Of mysql group_concat | group_concat Presto

Mar 3, 20225 min read

Curious about the Presto equivalent of mysql group_concat? Check out this article to learn about different SQL dialetcs

How To Query Data in AWS S3 Using Athena | Ahana

Mar 1, 20224 min read

Learn how to use Athena to query Amazon S3 and start running queries on your S3 data lake. Query JSON, Apache Parquet, Apache ORC, CSV, and more.

Ahana Announces New Security Capabilities to Bring Next Level of Security to the Data Lake

Feb 23, 20226 min read

Ahana, the only SaaS for Presto, today announced significant new security features added to its Ahana Cloud for Presto managed service. They include multi-user support for Presto and Ahana, fine-grained access control for data lakes with deep Apache Ranger integration, and audit support for all access.

Difference Between AWS Lake Formation vs AWS Glue

Feb 22, 20226 min read

AWS Lake Formation vs AWS Glue – What are the differences? Last updated: October 2022 As you start building your analytics stack in AWS, there are several AWS technologies to … Continue reading Difference Between AWS Lake Formation vs AWS Glue

Presto Platform Overview: Interactive Analytic Queries

Feb 14, 20224 min read

the Presto platform is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes.

Limitations of Amazon S3 Select | AWS Select Capabilities

Feb 2, 20226 min read

Amazon S3 Select Limitations What is Amazon S3 Select? Amazon S3 Select allows you to use simple structured query language (SQL) statements to filter the contents of an Amazon S3 … Continue reading Limitations of Amazon S3 Select | AWS Select Capabilities

What is AWS Lake Formation? | Amazon S3 Lake formation

Jan 31, 20222 min read

What is AWS Lake Formation? For AWS users who want to get governance on their data lake, AWS Lake Formation is a service that makes it easy to set up … Continue reading What is AWS Lake Formation? | Amazon S3 Lake formation

How does Presto work with LDAP | Presto LDAP Authentication

Jan 28, 20223 min read

LDAP is an industry standard application used for directory services authentication. Learn how does Presto work with LDAP

What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Jan 28, 20223 min read

What is Apache Ranger? What is Apache Ranger? In a Nutshell Apache Ranger is a framework to enable, monitor and manage comprehensive data security across the data platform. It is … Continue reading What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Benchmark Presto | Benchmarking Warehouse Workloads

Jan 12, 20222 min read

For businesses looking to understand how to evaluate Presto performance, this document will help to learn how to benchmark Presto. 

Build and Query Secure S3 Data Lakes with Ahana Cloud and AWS Lake Formation

Jan 11, 202239 min read

In this webinar, we’ll share more on the recently announced AWS Lake Formation and Ahana integration.

Ahana Responds to Growing Demand for its SaaS for Presto on AWS with Appointment of Chief Revenue Officer

Jan 11, 20224 min read

With over 20 years of enterprise experience, Andy brings expertise in developing significant direct and indirect routes to market across both pre and post sales organizations.

Ahana Cofounders Make Data Predictions for 2022

Jan 5, 20224 min read

Ahana’s Cofounder and Chief Product Officer, Dipti Borkar, and Cofounder and Chief Executive Officer, Steven Mih predict major developments in cloud, data analytics, databases and data warehousing in 2022.

Ahana and Presto Praised for Technology Innovation and Leadership in Open Source, Big Data and Data Analytics with Recent Industry Awards

Dec 15, 20215 min read

Ahana, the only SaaS for Presto, today announced the addition of many new industry accolades in 2H 2021. Presto, originally created by Meta (Facebook) who open sourced and donated the project to Linux Foundation’s Presto Foundation, is the SQL query engine for the data lake. Ahana Cloud for Presto is the only SaaS for Presto on AWS, a cloud-native managed service that gives customers complete control and visibility of Presto clusters and their data. 

Ahana Cloud for Presto Delivers Deep Integration with AWS Lake Formation Through Participation in Launch Program

Dec 9, 20215 min read

Ahana, the only SaaS for Presto, today announced Ahana Cloud for Presto’s deep integration with AWS Lake Formation, an Amazon Web Services, Inc. (AWS) service that makes it easy to set up a secure data lake, manage security, and provide self-service access to data with Amazon Simple Storage Service (Amazon S3).

Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Dec 9, 20212 min read

We’re excited to announce that Ahana Cloud for Presto now integrates with AWS Lake Formation, including support for the recent general availability of row-level security. AWS Lake Formation is a … Continue reading Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Advanced SQL Tutorial & SQL Queries Support

Dec 4, 20214 min read

Presto has a wide-range of JSON functions supporting advanced SQL queries. Learn more about advancing your skill when it comes to SQL

Ahana Joins Leading Members of the Presto® Community at PrestoCon as Platinum Sponsor, Will Share Use Cases and Technology Innovations

Dec 1, 20215 min read

Ahana, the only SaaS for Presto, announced today their participation at PrestoCon, a day dedicated to the open source Presto project taking place on Thursday, December 9, 2021.

What is Presto on Spark?

Nov 15, 20219 min read

Overview Presto was originally designed to run interactive queries against data warehouses. However, now it has evolved into a unified SQL engine on top of open data lake analytics for … Continue reading What is Presto on Spark?

Ahana Achieves AWS Data & Analytics ISV Competency Status

Nov 10, 20213 min read

Ahana, the Presto company, today announced that it has achieved Amazon Web Services (AWS) Data & Analytics ISV Competency status.

Tutorial: How to define SQL functions with Presto across all connectors

Nov 3, 20215 min read

Presto supports many native functions, which are usually sufficient for most use cases. To simplify this, Presto allows users to define expressions as SQL functions.

Ahana Cofounder Will Present Session At Next Gen Big Data Platforms Meetup hosted by LinkedIn About Open Data Lake Analytics

Nov 2, 20213 min read

Ahana Cofounder and Chief Product Officer Dipti Borkar will present a session at Next Gen Big Data Platforms Meetup hosted by LinkedIn about open data lake analytics.

Presto Queries Running Slow | Slow Queries & Presto Tuning | Ahana

Oct 23, 20217 min read

Running Presto queries on large scale data in a data lake? If your queries are slow learn how to troubleshoot in 10 steps

Presto 105: Running Presto with AWS Glue as catalog on your Laptop

Oct 21, 202110 min read

Introduction This is the 5th tutorial in our Getting Started with Presto series. To recap, here are the first 4 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 105: Running Presto with AWS Glue as catalog on your Laptop

0 to Presto with AWS Oct 2021

Oct 20, 20212 min read

Data lakes are widely used and have become extremely affordable, especially with the advent of technologies like AWS S3. During this webinar, Gary Stafford, Solutions Architect at AWS, and Dipti Borkar, Cofounder & CPO at Ahana, will share how to build an open data lake stack with Presto and AWS S3.

How to Build an Open Data Lake Analytics Stack

Oct 12, 20212 min read

In this webinar, we’ll discuss how to build an Open Data Lake Analytics stack using 4 key components: open source technologies, open formats, open interfaces & open cloud.

Presto 104: Running Presto with Hive Metastore on your Laptop

Oct 8, 202110 min read

Introduction This is the 4th tutorial in our Getting Started with Presto series. To recap, here are the first 3 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 104: Running Presto with Hive Metastore on your Laptop

Unlocking the Value of Your Data Lake

Oct 6, 20212 min read

During this webinar Ahana co-founder and Chief Product Officer Dipti Borkar will discuss how to unlock the value of your data lake with the emerging Open Data Lake analytics architecture.

Connect Superset to Presto

Oct 5, 20218 min read

Curious how to connect Superset to Presto? This article will break down the steps needed to use Presto with Superset.

Presto Tutorial 103: PrestoDB cluster on GCP

Sep 21, 202126 min read

Introduction This tutorial is Part III of our Getting started with PrestoDB series. As a reminder, Prestodb is an open source distributed SQL query engine. In tutorial 102 we covered … Continue reading Presto Tutorial 103: PrestoDB cluster on GCP

Presto functions: mathematical, operators and aggregate

Sep 21, 20216 min read

Presto functions. Presto offers several classes of functions and operators. Learn more about them and their use.

Ahana Cofounder Will Co-lead Session At OSPOCon 2021 About Presto SQL Query Engine

Sep 21, 20213 min read

San Mateo, Calif. – September 21, 2021 — Ahana, the SaaS for Presto company, today announced that its Cofounder and Chief Product Officer Dipti Borkar will co-lead a session with … Continue reading Ahana Cofounder Will Co-lead Session At OSPOCon 2021 About Presto SQL Query Engine

Announcing the workload profile feature in Ahana Cloud

Sep 20, 20213 min read

Ahana Cloud for Presto is the first fully integrated, cloud native managed service that simplifies the ability of cloud and data platform teams. With the managed Presto service, we provide … Continue reading Announcing the workload profile feature in Ahana Cloud

Presto on AWS: Exploring different Presto services

Sep 16, 20212 min read

In this webinar we will discuss why companies are using Ahana Cloud for their Presto deployments and give an overview of Ahana including the Ahana SaaS console, how easy it is to add data sources like AWS S3 and integrate catalogs like Hive, and features like Data Lake Caching for 5x performance and autoscaling.

Ahana Joins AWS ISV Accelerate Program to Expand Access to Its Presto Managed Service for Fast SQL on Amazon S3 Data Lakes

Sep 14, 20214 min read

Ahana also selected into the invite-only AWS Global Startup Program San Mateo, Calif. – September 14, 2021 — Ahana, the Presto company, today announced it has been accepted into the … Continue reading Ahana Joins AWS ISV Accelerate Program to Expand Access to Its Presto Managed Service for Fast SQL on Amazon S3 Data Lakes

Ahana 101: An introduction to Ahana Cloud for Presto on AWS, SaaS for Presto on AWS

Sep 9, 20212 min read

In this webinar we will discuss why companies are using Ahana Cloud for their Presto deployments and give an overview of Ahana including the Ahana SaaS console, how easy it is to add data sources like AWS S3 and integrate catalogs like Hive, and features like Data Lake Caching for 5x performance and autoscaling.

Presto 101: An introduction to open source Presto

Sep 2, 20212 min read

In this session, Dipti will introduce the Presto technology and share why it’s becoming so popular – in fact, companies like Facebook, Uber, Twitter, Alibaba, and much more use Presto for interactive ad hoc queries, reporting & dashboarding data lake analytics, and much more. We’ll also show a quick demo on getting Presto running in AWS.

What is a Presto lag example?

Aug 31, 20212 min read

The Presto lag function a window function that returns the value of an offset before the current row in a window. One common use case for the lag function is … Continue reading What is a Presto lag example?

SQL on the Data Lake, Using open source Presto to unlock the value of your data lake

Aug 26, 20212 min read

In this webinar, Dipti will discuss why open source Presto has quickly become the de-facto query engine for the data lake. Presto enables ad hoc data discovery where you can use SQL to run queries whenever you want, wherever your data resides. With Presto, you can unlock the value of your data lake.

How do I get the date_diff from previous rows?

Aug 24, 20211 min read

To find the difference in time between consecutive dates in a result set, Presto offers window functions. Take the example table below which contains sample data of users who watched … Continue reading How do I get the date_diff from previous rows?

Data Warehouse or Data Lake, which one do I use?

Aug 19, 202143 min read

In this webinar, you’ll hear from industry analyst John Santaferraro and Ahana cofounder and CPO Dipti Borkar who will discuss the data landscape and how many companies are thinking about their data warehouse/data lake strategy.

How do I use the approx_percentile function in Presto?

Aug 9, 20216 min read

The Presto approx percentile returns an approximate percentile for values. We’ll explain how to use the function

Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Aug 3, 20216 min read

I’m very excited to announce that Ahana, the SaaS for Presto company, has raised a jumbo $20M Series A round from lead investor Third Point Ventures. Our SaaS managed service … Continue reading Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Presto Company Ahana Raises $20M Series A Led By Third Point Ventures To Redefine Open Data Lake Analytics

Aug 3, 20214 min read

Funding comes on heels of major momentum in customer and community adoption for Presto San Mateo, Calif. – August 3, 2021 — Ahana, the SaaS for Presto company, today announced … Continue reading Presto Company Ahana Raises $20M Series A Led By Third Point Ventures To Redefine Open Data Lake Analytics

Autoscale your Presto cluster in Ahana Cloud

Jul 29, 20215 min read

One of the challenges of running a Presto cluster is to make the right decision in terms of the number of worker nodes. Learn here how to autoscale

Community Roundtable: Open Data Lakes with Presto, Apache Hudi & AWS Glue and S3

Jul 28, 202152 min read

Join us for this roundtable discussion where experts from each layer in this stack – Presto, AWS, and Apache Hudi – will discuss why we’re seeing a pronounced adoption to this next generation of cloud data lake analytics and how these technologies enable open, flexible, and highly performant analytics in the cloud.

Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why

Jul 20, 20217 min read

Since COVID, every business has pivoted and moved everything online, accelerating digital transformation with data and AI. Self-service, accelerated analytics has become more and more critical for businesses and Snowflake … Continue reading Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why

How to Query Parquet Files using Amazon Athena | Ahana

Mar 9, 20225 min read

Querying Parquet Files using Amazon Athena Parquet is one of the latest file formats with many advantages over some of the more commonly used formats like CSV and JSON. Specifically, … Continue reading How to Query Parquet Files using Amazon Athena | Ahana

Configuring RaptorX – a multi-level caching with Presto

Mar 8, 202211 min read

RaptorX Background and Context Meta introduced a multi-level cache at PrestoCon 2021. Code-named the “RaptorX Project,” it aims to make Presto 10x faster on Meta- scale petabyte workloads. Here at … Continue reading Configuring RaptorX – a multi-level caching with Presto

AWS Lake Formation Blueprints | Amazon Blueprint Types

Mar 7, 20222 min read

This article is focused on the first step and how AWS Lake Formation Blueprints can make that easy and automated. Before you can run analytics to get insights, you need your data continuously pooling into your lake!

Presto Equivalent Of mysql group_concat | group_concat Presto

Mar 3, 20225 min read

Curious about the Presto equivalent of mysql group_concat? Check out this article to learn about different SQL dialetcs

How To Query Data in AWS S3 Using Athena | Ahana

Mar 1, 20224 min read

Learn how to use Athena to query Amazon S3 and start running queries on your S3 data lake. Query JSON, Apache Parquet, Apache ORC, CSV, and more.

Ahana Announces New Security Capabilities to Bring Next Level of Security to the Data Lake

Feb 23, 20226 min read

Ahana, the only SaaS for Presto, today announced significant new security features added to its Ahana Cloud for Presto managed service. They include multi-user support for Presto and Ahana, fine-grained access control for data lakes with deep Apache Ranger integration, and audit support for all access.

Difference Between AWS Lake Formation vs AWS Glue

Feb 22, 20226 min read

AWS Lake Formation vs AWS Glue – What are the differences? Last updated: October 2022 As you start building your analytics stack in AWS, there are several AWS technologies to … Continue reading Difference Between AWS Lake Formation vs AWS Glue

Presto Platform Overview: Interactive Analytic Queries

Feb 14, 20224 min read

the Presto platform is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes.

Limitations of Amazon S3 Select | AWS Select Capabilities

Feb 2, 20226 min read

Amazon S3 Select Limitations What is Amazon S3 Select? Amazon S3 Select allows you to use simple structured query language (SQL) statements to filter the contents of an Amazon S3 … Continue reading Limitations of Amazon S3 Select | AWS Select Capabilities

What is AWS Lake Formation? | Amazon S3 Lake formation

Jan 31, 20222 min read

What is AWS Lake Formation? For AWS users who want to get governance on their data lake, AWS Lake Formation is a service that makes it easy to set up … Continue reading What is AWS Lake Formation? | Amazon S3 Lake formation

How does Presto work with LDAP | Presto LDAP Authentication

Jan 28, 20223 min read

LDAP is an industry standard application used for directory services authentication. Learn how does Presto work with LDAP

What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Jan 28, 20223 min read

What is Apache Ranger? What is Apache Ranger? In a Nutshell Apache Ranger is a framework to enable, monitor and manage comprehensive data security across the data platform. It is … Continue reading What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Benchmark Presto | Benchmarking Warehouse Workloads

Jan 12, 20222 min read

For businesses looking to understand how to evaluate Presto performance, this document will help to learn how to benchmark Presto. 

Build and Query Secure S3 Data Lakes with Ahana Cloud and AWS Lake Formation

Jan 11, 202239 min read

In this webinar, we’ll share more on the recently announced AWS Lake Formation and Ahana integration.

Ahana Responds to Growing Demand for its SaaS for Presto on AWS with Appointment of Chief Revenue Officer

Jan 11, 20224 min read

With over 20 years of enterprise experience, Andy brings expertise in developing significant direct and indirect routes to market across both pre and post sales organizations.

Ahana Cofounders Make Data Predictions for 2022

Jan 5, 20224 min read

Ahana’s Cofounder and Chief Product Officer, Dipti Borkar, and Cofounder and Chief Executive Officer, Steven Mih predict major developments in cloud, data analytics, databases and data warehousing in 2022.

Ahana and Presto Praised for Technology Innovation and Leadership in Open Source, Big Data and Data Analytics with Recent Industry Awards

Dec 15, 20215 min read

Ahana, the only SaaS for Presto, today announced the addition of many new industry accolades in 2H 2021. Presto, originally created by Meta (Facebook) who open sourced and donated the project to Linux Foundation’s Presto Foundation, is the SQL query engine for the data lake. Ahana Cloud for Presto is the only SaaS for Presto on AWS, a cloud-native managed service that gives customers complete control and visibility of Presto clusters and their data. 

Ahana Cloud for Presto Delivers Deep Integration with AWS Lake Formation Through Participation in Launch Program

Dec 9, 20215 min read

Ahana, the only SaaS for Presto, today announced Ahana Cloud for Presto’s deep integration with AWS Lake Formation, an Amazon Web Services, Inc. (AWS) service that makes it easy to set up a secure data lake, manage security, and provide self-service access to data with Amazon Simple Storage Service (Amazon S3).

Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Dec 9, 20212 min read

We’re excited to announce that Ahana Cloud for Presto now integrates with AWS Lake Formation, including support for the recent general availability of row-level security. AWS Lake Formation is a … Continue reading Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Advanced SQL Tutorial & SQL Queries Support

Dec 4, 20214 min read

Presto has a wide-range of JSON functions supporting advanced SQL queries. Learn more about advancing your skill when it comes to SQL

Ahana Joins Leading Members of the Presto® Community at PrestoCon as Platinum Sponsor, Will Share Use Cases and Technology Innovations

Dec 1, 20215 min read

Ahana, the only SaaS for Presto, announced today their participation at PrestoCon, a day dedicated to the open source Presto project taking place on Thursday, December 9, 2021.

What is Presto on Spark?

Nov 15, 20219 min read

Overview Presto was originally designed to run interactive queries against data warehouses. However, now it has evolved into a unified SQL engine on top of open data lake analytics for … Continue reading What is Presto on Spark?

Ahana Achieves AWS Data & Analytics ISV Competency Status

Nov 10, 20213 min read

Ahana, the Presto company, today announced that it has achieved Amazon Web Services (AWS) Data & Analytics ISV Competency status.

Tutorial: How to define SQL functions with Presto across all connectors

Nov 3, 20215 min read

Presto supports many native functions, which are usually sufficient for most use cases. To simplify this, Presto allows users to define expressions as SQL functions.

Ahana Cofounder Will Present Session At Next Gen Big Data Platforms Meetup hosted by LinkedIn About Open Data Lake Analytics

Nov 2, 20213 min read

Ahana Cofounder and Chief Product Officer Dipti Borkar will present a session at Next Gen Big Data Platforms Meetup hosted by LinkedIn about open data lake analytics.

Presto Queries Running Slow | Slow Queries & Presto Tuning | Ahana

Oct 23, 20217 min read

Running Presto queries on large scale data in a data lake? If your queries are slow learn how to troubleshoot in 10 steps

Presto 105: Running Presto with AWS Glue as catalog on your Laptop

Oct 21, 202110 min read

Introduction This is the 5th tutorial in our Getting Started with Presto series. To recap, here are the first 4 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 105: Running Presto with AWS Glue as catalog on your Laptop

0 to Presto with AWS Oct 2021

Oct 20, 20212 min read

Data lakes are widely used and have become extremely affordable, especially with the advent of technologies like AWS S3. During this webinar, Gary Stafford, Solutions Architect at AWS, and Dipti Borkar, Cofounder & CPO at Ahana, will share how to build an open data lake stack with Presto and AWS S3.

How to Build an Open Data Lake Analytics Stack

Oct 12, 20212 min read

In this webinar, we’ll discuss how to build an Open Data Lake Analytics stack using 4 key components: open source technologies, open formats, open interfaces & open cloud.

Presto 104: Running Presto with Hive Metastore on your Laptop

Oct 8, 202110 min read

Introduction This is the 4th tutorial in our Getting Started with Presto series. To recap, here are the first 3 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 104: Running Presto with Hive Metastore on your Laptop

Unlocking the Value of Your Data Lake

Oct 6, 20212 min read

During this webinar Ahana co-founder and Chief Product Officer Dipti Borkar will discuss how to unlock the value of your data lake with the emerging Open Data Lake analytics architecture.

Connect Superset to Presto

Oct 5, 20218 min read

Curious how to connect Superset to Presto? This article will break down the steps needed to use Presto with Superset.

Presto Tutorial 103: PrestoDB cluster on GCP

Sep 21, 202126 min read

Introduction This tutorial is Part III of our Getting started with PrestoDB series. As a reminder, Prestodb is an open source distributed SQL query engine. In tutorial 102 we covered … Continue reading Presto Tutorial 103: PrestoDB cluster on GCP

Presto functions: mathematical, operators and aggregate

Sep 21, 20216 min read

Presto functions. Presto offers several classes of functions and operators. Learn more about them and their use.

Ahana Cofounder Will Co-lead Session At OSPOCon 2021 About Presto SQL Query Engine

Sep 21, 20213 min read

San Mateo, Calif. – September 21, 2021 — Ahana, the SaaS for Presto company, today announced that its Cofounder and Chief Product Officer Dipti Borkar will co-lead a session with … Continue reading Ahana Cofounder Will Co-lead Session At OSPOCon 2021 About Presto SQL Query Engine

Announcing the workload profile feature in Ahana Cloud

Sep 20, 20213 min read

Ahana Cloud for Presto is the first fully integrated, cloud native managed service that simplifies the ability of cloud and data platform teams. With the managed Presto service, we provide … Continue reading Announcing the workload profile feature in Ahana Cloud

Presto on AWS: Exploring different Presto services

Sep 16, 20212 min read

In this webinar we will discuss why companies are using Ahana Cloud for their Presto deployments and give an overview of Ahana including the Ahana SaaS console, how easy it is to add data sources like AWS S3 and integrate catalogs like Hive, and features like Data Lake Caching for 5x performance and autoscaling.

Ahana Joins AWS ISV Accelerate Program to Expand Access to Its Presto Managed Service for Fast SQL on Amazon S3 Data Lakes

Sep 14, 20214 min read

Ahana also selected into the invite-only AWS Global Startup Program San Mateo, Calif. – September 14, 2021 — Ahana, the Presto company, today announced it has been accepted into the … Continue reading Ahana Joins AWS ISV Accelerate Program to Expand Access to Its Presto Managed Service for Fast SQL on Amazon S3 Data Lakes

Ahana 101: An introduction to Ahana Cloud for Presto on AWS, SaaS for Presto on AWS

Sep 9, 20212 min read

In this webinar we will discuss why companies are using Ahana Cloud for their Presto deployments and give an overview of Ahana including the Ahana SaaS console, how easy it is to add data sources like AWS S3 and integrate catalogs like Hive, and features like Data Lake Caching for 5x performance and autoscaling.

Presto 101: An introduction to open source Presto

Sep 2, 20212 min read

In this session, Dipti will introduce the Presto technology and share why it’s becoming so popular – in fact, companies like Facebook, Uber, Twitter, Alibaba, and much more use Presto for interactive ad hoc queries, reporting & dashboarding data lake analytics, and much more. We’ll also show a quick demo on getting Presto running in AWS.

What is a Presto lag example?

Aug 31, 20212 min read

The Presto lag function a window function that returns the value of an offset before the current row in a window. One common use case for the lag function is … Continue reading What is a Presto lag example?

SQL on the Data Lake, Using open source Presto to unlock the value of your data lake

Aug 26, 20212 min read

In this webinar, Dipti will discuss why open source Presto has quickly become the de-facto query engine for the data lake. Presto enables ad hoc data discovery where you can use SQL to run queries whenever you want, wherever your data resides. With Presto, you can unlock the value of your data lake.

How do I get the date_diff from previous rows?

Aug 24, 20211 min read

To find the difference in time between consecutive dates in a result set, Presto offers window functions. Take the example table below which contains sample data of users who watched … Continue reading How do I get the date_diff from previous rows?

Data Warehouse or Data Lake, which one do I use?

Aug 19, 202143 min read

In this webinar, you’ll hear from industry analyst John Santaferraro and Ahana cofounder and CPO Dipti Borkar who will discuss the data landscape and how many companies are thinking about their data warehouse/data lake strategy.

How do I use the approx_percentile function in Presto?

Aug 9, 20216 min read

The Presto approx percentile returns an approximate percentile for values. We’ll explain how to use the function

Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Aug 3, 20216 min read

I’m very excited to announce that Ahana, the SaaS for Presto company, has raised a jumbo $20M Series A round from lead investor Third Point Ventures. Our SaaS managed service … Continue reading Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Presto Company Ahana Raises $20M Series A Led By Third Point Ventures To Redefine Open Data Lake Analytics

Aug 3, 20214 min read

Funding comes on heels of major momentum in customer and community adoption for Presto San Mateo, Calif. – August 3, 2021 — Ahana, the SaaS for Presto company, today announced … Continue reading Presto Company Ahana Raises $20M Series A Led By Third Point Ventures To Redefine Open Data Lake Analytics

Autoscale your Presto cluster in Ahana Cloud

Jul 29, 20215 min read

One of the challenges of running a Presto cluster is to make the right decision in terms of the number of worker nodes. Learn here how to autoscale

Community Roundtable: Open Data Lakes with Presto, Apache Hudi & AWS Glue and S3

Jul 28, 202152 min read

Join us for this roundtable discussion where experts from each layer in this stack – Presto, AWS, and Apache Hudi – will discuss why we’re seeing a pronounced adoption to this next generation of cloud data lake analytics and how these technologies enable open, flexible, and highly performant analytics in the cloud.

Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why

Jul 20, 20217 min read

Since COVID, every business has pivoted and moved everything online, accelerating digital transformation with data and AI. Self-service, accelerated analytics has become more and more critical for businesses and Snowflake … Continue reading Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why

How to Query Parquet Files using Amazon Athena | Ahana

Mar 9, 20225 min read

Querying Parquet Files using Amazon Athena Parquet is one of the latest file formats with many advantages over some of the more commonly used formats like CSV and JSON. Specifically, … Continue reading How to Query Parquet Files using Amazon Athena | Ahana

Configuring RaptorX – a multi-level caching with Presto

Mar 8, 202211 min read

RaptorX Background and Context Meta introduced a multi-level cache at PrestoCon 2021. Code-named the “RaptorX Project,” it aims to make Presto 10x faster on Meta- scale petabyte workloads. Here at … Continue reading Configuring RaptorX – a multi-level caching with Presto

AWS Lake Formation Blueprints | Amazon Blueprint Types

Mar 7, 20222 min read

This article is focused on the first step and how AWS Lake Formation Blueprints can make that easy and automated. Before you can run analytics to get insights, you need your data continuously pooling into your lake!

Presto Equivalent Of mysql group_concat | group_concat Presto

Mar 3, 20225 min read

Curious about the Presto equivalent of mysql group_concat? Check out this article to learn about different SQL dialetcs

How To Query Data in AWS S3 Using Athena | Ahana

Mar 1, 20224 min read

Learn how to use Athena to query Amazon S3 and start running queries on your S3 data lake. Query JSON, Apache Parquet, Apache ORC, CSV, and more.

Ahana Announces New Security Capabilities to Bring Next Level of Security to the Data Lake

Feb 23, 20226 min read

Ahana, the only SaaS for Presto, today announced significant new security features added to its Ahana Cloud for Presto managed service. They include multi-user support for Presto and Ahana, fine-grained access control for data lakes with deep Apache Ranger integration, and audit support for all access.

Difference Between AWS Lake Formation vs AWS Glue

Feb 22, 20226 min read

AWS Lake Formation vs AWS Glue – What are the differences? Last updated: October 2022 As you start building your analytics stack in AWS, there are several AWS technologies to … Continue reading Difference Between AWS Lake Formation vs AWS Glue

Presto Platform Overview: Interactive Analytic Queries

Feb 14, 20224 min read

the Presto platform is an open source distributed SQL query engine for running interactive analytic queries against data sources of all sizes.

Limitations of Amazon S3 Select | AWS Select Capabilities

Feb 2, 20226 min read

Amazon S3 Select Limitations What is Amazon S3 Select? Amazon S3 Select allows you to use simple structured query language (SQL) statements to filter the contents of an Amazon S3 … Continue reading Limitations of Amazon S3 Select | AWS Select Capabilities

What is AWS Lake Formation? | Amazon S3 Lake formation

Jan 31, 20222 min read

What is AWS Lake Formation? For AWS users who want to get governance on their data lake, AWS Lake Formation is a service that makes it easy to set up … Continue reading What is AWS Lake Formation? | Amazon S3 Lake formation

How does Presto work with LDAP | Presto LDAP Authentication

Jan 28, 20223 min read

LDAP is an industry standard application used for directory services authentication. Learn how does Presto work with LDAP

What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Jan 28, 20223 min read

What is Apache Ranger? What is Apache Ranger? In a Nutshell Apache Ranger is a framework to enable, monitor and manage comprehensive data security across the data platform. It is … Continue reading What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Benchmark Presto | Benchmarking Warehouse Workloads

Jan 12, 20222 min read

For businesses looking to understand how to evaluate Presto performance, this document will help to learn how to benchmark Presto. 

Build and Query Secure S3 Data Lakes with Ahana Cloud and AWS Lake Formation

Jan 11, 202239 min read

In this webinar, we’ll share more on the recently announced AWS Lake Formation and Ahana integration.

Ahana Responds to Growing Demand for its SaaS for Presto on AWS with Appointment of Chief Revenue Officer

Jan 11, 20224 min read

With over 20 years of enterprise experience, Andy brings expertise in developing significant direct and indirect routes to market across both pre and post sales organizations.

Ahana Cofounders Make Data Predictions for 2022

Jan 5, 20224 min read

Ahana’s Cofounder and Chief Product Officer, Dipti Borkar, and Cofounder and Chief Executive Officer, Steven Mih predict major developments in cloud, data analytics, databases and data warehousing in 2022.

Ahana and Presto Praised for Technology Innovation and Leadership in Open Source, Big Data and Data Analytics with Recent Industry Awards

Dec 15, 20215 min read

Ahana, the only SaaS for Presto, today announced the addition of many new industry accolades in 2H 2021. Presto, originally created by Meta (Facebook) who open sourced and donated the project to Linux Foundation’s Presto Foundation, is the SQL query engine for the data lake. Ahana Cloud for Presto is the only SaaS for Presto on AWS, a cloud-native managed service that gives customers complete control and visibility of Presto clusters and their data. 

Ahana Cloud for Presto Delivers Deep Integration with AWS Lake Formation Through Participation in Launch Program

Dec 9, 20215 min read

Ahana, the only SaaS for Presto, today announced Ahana Cloud for Presto’s deep integration with AWS Lake Formation, an Amazon Web Services, Inc. (AWS) service that makes it easy to set up a secure data lake, manage security, and provide self-service access to data with Amazon Simple Storage Service (Amazon S3).

Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Dec 9, 20212 min read

We’re excited to announce that Ahana Cloud for Presto now integrates with AWS Lake Formation, including support for the recent general availability of row-level security. AWS Lake Formation is a … Continue reading Announcing the Ahana Cloud for Presto integration with AWS Lake Formation

Advanced SQL Tutorial & SQL Queries Support

Dec 4, 20214 min read

Presto has a wide-range of JSON functions supporting advanced SQL queries. Learn more about advancing your skill when it comes to SQL

Ahana Joins Leading Members of the Presto® Community at PrestoCon as Platinum Sponsor, Will Share Use Cases and Technology Innovations

Dec 1, 20215 min read

Ahana, the only SaaS for Presto, announced today their participation at PrestoCon, a day dedicated to the open source Presto project taking place on Thursday, December 9, 2021.

What is Presto on Spark?

Nov 15, 20219 min read

Overview Presto was originally designed to run interactive queries against data warehouses. However, now it has evolved into a unified SQL engine on top of open data lake analytics for … Continue reading What is Presto on Spark?

Ahana Achieves AWS Data & Analytics ISV Competency Status

Nov 10, 20213 min read

Ahana, the Presto company, today announced that it has achieved Amazon Web Services (AWS) Data & Analytics ISV Competency status.

Tutorial: How to define SQL functions with Presto across all connectors

Nov 3, 20215 min read

Presto supports many native functions, which are usually sufficient for most use cases. To simplify this, Presto allows users to define expressions as SQL functions.

Ahana Cofounder Will Present Session At Next Gen Big Data Platforms Meetup hosted by LinkedIn About Open Data Lake Analytics

Nov 2, 20213 min read

Ahana Cofounder and Chief Product Officer Dipti Borkar will present a session at Next Gen Big Data Platforms Meetup hosted by LinkedIn about open data lake analytics.

Presto Queries Running Slow | Slow Queries & Presto Tuning | Ahana

Oct 23, 20217 min read

Running Presto queries on large scale data in a data lake? If your queries are slow learn how to troubleshoot in 10 steps

Presto 105: Running Presto with AWS Glue as catalog on your Laptop

Oct 21, 202110 min read

Introduction This is the 5th tutorial in our Getting Started with Presto series. To recap, here are the first 4 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 105: Running Presto with AWS Glue as catalog on your Laptop

0 to Presto with AWS Oct 2021

Oct 20, 20212 min read

Data lakes are widely used and have become extremely affordable, especially with the advent of technologies like AWS S3. During this webinar, Gary Stafford, Solutions Architect at AWS, and Dipti Borkar, Cofounder & CPO at Ahana, will share how to build an open data lake stack with Presto and AWS S3.

How to Build an Open Data Lake Analytics Stack

Oct 12, 20212 min read

In this webinar, we’ll discuss how to build an Open Data Lake Analytics stack using 4 key components: open source technologies, open formats, open interfaces & open cloud.

Presto 104: Running Presto with Hive Metastore on your Laptop

Oct 8, 202110 min read

Introduction This is the 4th tutorial in our Getting Started with Presto series. To recap, here are the first 3 tutorials: Presto 101: Installing & Configuring Presto locally Presto 102: … Continue reading Presto 104: Running Presto with Hive Metastore on your Laptop

Unlocking the Value of Your Data Lake

Oct 6, 20212 min read

During this webinar Ahana co-founder and Chief Product Officer Dipti Borkar will discuss how to unlock the value of your data lake with the emerging Open Data Lake analytics architecture.

Connect Superset to Presto

Oct 5, 20218 min read

Curious how to connect Superset to Presto? This article will break down the steps needed to use Presto with Superset.

Presto Tutorial 103: PrestoDB cluster on GCP

Sep 21, 202126 min read

Introduction This tutorial is Part III of our Getting started with PrestoDB series. As a reminder, Prestodb is an open source distributed SQL query engine. In tutorial 102 we covered … Continue reading Presto Tutorial 103: PrestoDB cluster on GCP

Presto functions: mathematical, operators and aggregate

Sep 21, 20216 min read

Presto functions. Presto offers several classes of functions and operators. Learn more about them and their use.

Ahana Cofounder Will Co-lead Session At OSPOCon 2021 About Presto SQL Query Engine

Sep 21, 20213 min read

San Mateo, Calif. – September 21, 2021 — Ahana, the SaaS for Presto company, today announced that its Cofounder and Chief Product Officer Dipti Borkar will co-lead a session with … Continue reading Ahana Cofounder Will Co-lead Session At OSPOCon 2021 About Presto SQL Query Engine

Announcing the workload profile feature in Ahana Cloud

Sep 20, 20213 min read

Ahana Cloud for Presto is the first fully integrated, cloud native managed service that simplifies the ability of cloud and data platform teams. With the managed Presto service, we provide … Continue reading Announcing the workload profile feature in Ahana Cloud

Presto on AWS: Exploring different Presto services

Sep 16, 20212 min read

In this webinar we will discuss why companies are using Ahana Cloud for their Presto deployments and give an overview of Ahana including the Ahana SaaS console, how easy it is to add data sources like AWS S3 and integrate catalogs like Hive, and features like Data Lake Caching for 5x performance and autoscaling.

Ahana Joins AWS ISV Accelerate Program to Expand Access to Its Presto Managed Service for Fast SQL on Amazon S3 Data Lakes

Sep 14, 20214 min read

Ahana also selected into the invite-only AWS Global Startup Program San Mateo, Calif. – September 14, 2021 — Ahana, the Presto company, today announced it has been accepted into the … Continue reading Ahana Joins AWS ISV Accelerate Program to Expand Access to Its Presto Managed Service for Fast SQL on Amazon S3 Data Lakes

Ahana 101: An introduction to Ahana Cloud for Presto on AWS, SaaS for Presto on AWS

Sep 9, 20212 min read

In this webinar we will discuss why companies are using Ahana Cloud for their Presto deployments and give an overview of Ahana including the Ahana SaaS console, how easy it is to add data sources like AWS S3 and integrate catalogs like Hive, and features like Data Lake Caching for 5x performance and autoscaling.

Presto 101: An introduction to open source Presto

Sep 2, 20212 min read

In this session, Dipti will introduce the Presto technology and share why it’s becoming so popular – in fact, companies like Facebook, Uber, Twitter, Alibaba, and much more use Presto for interactive ad hoc queries, reporting & dashboarding data lake analytics, and much more. We’ll also show a quick demo on getting Presto running in AWS.

What is a Presto lag example?

Aug 31, 20212 min read

The Presto lag function a window function that returns the value of an offset before the current row in a window. One common use case for the lag function is … Continue reading What is a Presto lag example?

SQL on the Data Lake, Using open source Presto to unlock the value of your data lake

Aug 26, 20212 min read

In this webinar, Dipti will discuss why open source Presto has quickly become the de-facto query engine for the data lake. Presto enables ad hoc data discovery where you can use SQL to run queries whenever you want, wherever your data resides. With Presto, you can unlock the value of your data lake.

How do I get the date_diff from previous rows?

Aug 24, 20211 min read

To find the difference in time between consecutive dates in a result set, Presto offers window functions. Take the example table below which contains sample data of users who watched … Continue reading How do I get the date_diff from previous rows?

Data Warehouse or Data Lake, which one do I use?

Aug 19, 202143 min read

In this webinar, you’ll hear from industry analyst John Santaferraro and Ahana cofounder and CPO Dipti Borkar who will discuss the data landscape and how many companies are thinking about their data warehouse/data lake strategy.

How do I use the approx_percentile function in Presto?

Aug 9, 20216 min read

The Presto approx percentile returns an approximate percentile for values. We’ll explain how to use the function

Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Aug 3, 20216 min read

I’m very excited to announce that Ahana, the SaaS for Presto company, has raised a jumbo $20M Series A round from lead investor Third Point Ventures. Our SaaS managed service … Continue reading Announcing the Ahana $20M Series A – Furthering our Vision of Open Data Lake Analytics with Presto

Presto Company Ahana Raises $20M Series A Led By Third Point Ventures To Redefine Open Data Lake Analytics

Aug 3, 20214 min read

Funding comes on heels of major momentum in customer and community adoption for Presto San Mateo, Calif. – August 3, 2021 — Ahana, the SaaS for Presto company, today announced … Continue reading Presto Company Ahana Raises $20M Series A Led By Third Point Ventures To Redefine Open Data Lake Analytics

Autoscale your Presto cluster in Ahana Cloud

Jul 29, 20215 min read

One of the challenges of running a Presto cluster is to make the right decision in terms of the number of worker nodes. Learn here how to autoscale

Community Roundtable: Open Data Lakes with Presto, Apache Hudi & AWS Glue and S3

Jul 28, 202152 min read

Join us for this roundtable discussion where experts from each layer in this stack – Presto, AWS, and Apache Hudi – will discuss why we’re seeing a pronounced adoption to this next generation of cloud data lake analytics and how these technologies enable open, flexible, and highly performant analytics in the cloud.

Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why

Jul 20, 20217 min read

Since COVID, every business has pivoted and moved everything online, accelerating digital transformation with data and AI. Self-service, accelerated analytics has become more and more critical for businesses and Snowflake … Continue reading Snowflake may not be the silver bullet you wanted for your long term data strategy… here’s why