Presto Training & Learning Center

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

Topics

Ahana Announces New Presto Query Analyzer to Bring Instant Insights into Presto Clusters

May 18, 20223 min read

With the Presto Query Analyzer, data platform teams can get instant insights into their Presto clusters including query performance, bandwidth bottlenecks, and much more. The Presto Query Analyzer was built for the Presto community and is free to use.

What Is AWS Redshift Used For | Redshift Use Cases

May 13, 20226 min read

What is Amazon Redshift Used For? Introduction Amazon Redshift is one of the most widely-used services in the AWS ecosystem and is a familiar component in many cloud architectures. In … Continue reading What Is AWS Redshift Used For | Redshift Use Cases

Differences Between ETL and ELT in Data Warehousing | Ahana

May 12, 20224 min read

ETL vs ELT in Data Warehousing Introduction ETL, or Extract Transform Load, is when an ETL tool or series of homegrown programs extracts data from a data source(s), often a … Continue reading Differences Between ETL and ELT in Data Warehousing | Ahana

How Much Does Amazon Athena Cost? | Ahana

Apr 25, 20223 min read

Understanding AWS Athena Costs with Examples What Is Amazon Athena?  Since you’re reading this to understand Athena costs, you likely already know, so we’ll just very briefly touch on what … Continue reading How Much Does Amazon Athena Cost? | Ahana

5 Components of Data Warehouse Architecture | Ahana

Apr 25, 20225 min read

5 Components of Data Warehouse Architecture | Ahana The Data Warehouse has been around for decades. Born in the 1980s, it addressed the need for optimized analytics on data. As … Continue reading 5 Components of Data Warehouse Architecture | Ahana

An introduction to Ahana Cloud for Presto on AWS

Apr 14, 20222 min read

During this webinar we will share how to build an open data lakehouse with Presto and AWS S3 using Ahana Cloud.

AWS Lake Formation for Enterprise Data Lakes | Ahana Cloud

Apr 6, 20223 min read

AWS Lake Formation is a service that makes it easy to set up a secure data lake very quickly (in a matter of days), providing a governance layer for data lakes on AWS S3. 

How to build an Open Data Lakehouse Analytics stack

Mar 31, 20222 min read

During this webinar we’ll show you how you can build an open data lakehouse stack. At the heart of this stack is Presto, the open source SQL query engine for the data lake, and the transaction manager / governance layer, which includes technologies like Apache Hudi, Delta Lake, and AWS Lake Formation.

How to Use AWS Athena to Query JSON Data | Ahana

Mar 30, 20224 min read

A popular use case is to use Athena to query Parquet, ORC, CSV and JSON files that are typically used for querying directly, or transformed and loaded into a data warehouse.

Unlocking the Business Value of the Data Lake

Mar 17, 20223 min read

During this webinar we’ll discuss how nearly three-fifths of organizations have gained competitive advantage from their data lake initiatives. That includes unleashing the intelligence-generating potential of a data lake that enables ad hoc data discovery and analytics in an open and flexible manner. We’ll cover:

What is an Open Data Lake in the Cloud?

Mar 16, 20223 min read

Data-driven insights can help business and product leaders hone in on customer needs and/or find untapped opportunities. Also, analytics dashboards can be presented to customers for added value.

The Differences Between AWS Athena and AWS Glue | Ahana

Mar 16, 20224 min read

Here, we are going to talk about AWS Athena vs Glue, which is an interesting pairing as they are both complementary and competitive. So, what are they exactly?

Best Practices for Resource Management in PrestoDB

Mar 11, 20229 min read

Resource management in databases allows administrators to have control over resources and assign a priority to sessions, ensuring the most important transactions get the major share of system resources. Resource management in a distributed environment makes accessibility of data easier and manages resources over the network of autonomous computers (i.e. Distributed System). The basis of resource management in the distributed system is also resource sharing.

How to Query Parquet Files using Amazon Athena | Ahana

Mar 9, 20224 min read

Querying Parquet Files using AWS 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. … Continue reading How to Query Parquet Files using Amazon Athena | Ahana

Configuring RaptorX – a multi-level caching with Presto

Mar 8, 202211 min read

Configuring RaptorX – a multi-level caching with Presto RaptorX Background and Context Meta introduced a multi-level cache at PrestoCon 2021. Code-named the “RaptorX Project,” it aims to make Presto 10x … 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!

The Differences Between AWS RedShift Spectrum vs Athena

Mar 4, 20225 min read

While the thrust of this article is an AWS Redshift Spectrum vs Athena comparison, there can be some confusion with the difference between AWS Redshift Spectrum and AWS Redshift. Very briefly, Redshift is the storage layer/data warehouse, and Redshift Spectrum is an extension to Redshift that is a query engine.

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, 20223 min read

AWS Lake Formation vs AWS Glue – What are the differences? As you start building your analytics stack in AWS, there are several AWS technologies to understand as you begin. … Continue reading Difference Between AWS Lake Formation vs AWS Glue

Building an Open Data Lakehouse with Presto, Hudi and AWS S3

Feb 16, 20228 min read

The Open Data Lakehouse – a quick intro Data warehouses have been considered a standard to perform analytics on structured data but cannot handle unstructured data such as text, images, … Continue reading Building an Open Data Lakehouse with Presto, Hudi and AWS S3

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

How To Query Data in Amazon S3 Using Athena | Ahana

Feb 1, 20223 min read

Querying Amazon S3 Data Using AWS Athena The data lake is becoming increasingly popular for more than just data storage. Now we see much more flexibility with what you can … Continue reading How To Query Data in Amazon S3 Using Athena | Ahana

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 Presto Works with LDAP | Presto LDAP Authentication

Jan 28, 20222 min read

How does Presto Work With LDAP? What is LDAP? The Lightweight Directory Access Protocol (LDAP) is an open, vendor-neutral, industry standard application protocol used for directory services authentication. In LDAP … Continue reading How Presto Works with LDAP | Presto LDAP Authentication

What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Jan 28, 20222 min read

What is Apache Ranger? Apache Ranger™ is a framework to enable, monitor and manage comprehensive data security across the data platform. It is an open-source authorization solution that provides access … Continue reading What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Benchmarking Warehouse Workloads on the Data Lake using Presto

Jan 12, 20222 min read

Benchmarking Warehouse Workloads on the Data Lake using Presto How to run a TPC-H Benchmark on Presto Presto is an open source MPP Query engine designed from the ground up … Continue reading Benchmarking Warehouse Workloads on the Data Lake using Presto

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

Jan 11, 20222 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

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 a Data Lakehouse Architecture?

Nov 16, 20214 min read

The term Data Lakehouse has become very popular over the last year or so, especially as more customers are migrating their workloads to the cloud. This article will help to … Continue reading What is a Data Lakehouse Architecture?

Presto on Spark

Nov 15, 20219 min read

Presto on Spark Overview Presto was originally designed to run interactive queries against data warehouses, but now it has evolved into a unified SQL engine on top of open data … Continue reading 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.

How do you 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 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.

Connecting to Presto with Superset

Oct 5, 20218 min read

This blog post will provide you with an understanding of how to connect Superset to Presto. TL;DR Superset refers to a connection to a distinct data source as a database. … Continue reading Connecting to Presto with Superset

Presto Tutorial | Run PrestoDB on Google Cloud Platform

Sep 21, 202126 min read

Presto Tutorial 103: Prestodb cluster on GCP Introduction This tutorial is Part III of our Getting started with PrestoDB series. As a reminder, Prestodb is an open source distributed SQL … Continue reading Presto Tutorial | Run PrestoDB on Google Cloud Platform

How to use mathematical functions and operators and aggregate functions for Presto?

Sep 21, 20216 min read

Presto offers several classes of mathematical functions that operate on single values and mathematical operators that allow for operations on values across columns. In addition, aggregate functions can operator on … Continue reading How to use mathematical functions and operators and aggregate functions for Presto?

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 Announces New Presto Query Analyzer to Bring Instant Insights into Presto Clusters

May 18, 20223 min read

With the Presto Query Analyzer, data platform teams can get instant insights into their Presto clusters including query performance, bandwidth bottlenecks, and much more. The Presto Query Analyzer was built for the Presto community and is free to use.

What Is AWS Redshift Used For | Redshift Use Cases

May 13, 20226 min read

What is Amazon Redshift Used For? Introduction Amazon Redshift is one of the most widely-used services in the AWS ecosystem and is a familiar component in many cloud architectures. In … Continue reading What Is AWS Redshift Used For | Redshift Use Cases

Differences Between ETL and ELT in Data Warehousing | Ahana

May 12, 20224 min read

ETL vs ELT in Data Warehousing Introduction ETL, or Extract Transform Load, is when an ETL tool or series of homegrown programs extracts data from a data source(s), often a … Continue reading Differences Between ETL and ELT in Data Warehousing | Ahana

How Much Does Amazon Athena Cost? | Ahana

Apr 25, 20223 min read

Understanding AWS Athena Costs with Examples What Is Amazon Athena?  Since you’re reading this to understand Athena costs, you likely already know, so we’ll just very briefly touch on what … Continue reading How Much Does Amazon Athena Cost? | Ahana

5 Components of Data Warehouse Architecture | Ahana

Apr 25, 20225 min read

5 Components of Data Warehouse Architecture | Ahana The Data Warehouse has been around for decades. Born in the 1980s, it addressed the need for optimized analytics on data. As … Continue reading 5 Components of Data Warehouse Architecture | Ahana

An introduction to Ahana Cloud for Presto on AWS

Apr 14, 20222 min read

During this webinar we will share how to build an open data lakehouse with Presto and AWS S3 using Ahana Cloud.

AWS Lake Formation for Enterprise Data Lakes | Ahana Cloud

Apr 6, 20223 min read

AWS Lake Formation is a service that makes it easy to set up a secure data lake very quickly (in a matter of days), providing a governance layer for data lakes on AWS S3. 

How to build an Open Data Lakehouse Analytics stack

Mar 31, 20222 min read

During this webinar we’ll show you how you can build an open data lakehouse stack. At the heart of this stack is Presto, the open source SQL query engine for the data lake, and the transaction manager / governance layer, which includes technologies like Apache Hudi, Delta Lake, and AWS Lake Formation.

How to Use AWS Athena to Query JSON Data | Ahana

Mar 30, 20224 min read

A popular use case is to use Athena to query Parquet, ORC, CSV and JSON files that are typically used for querying directly, or transformed and loaded into a data warehouse.

Unlocking the Business Value of the Data Lake

Mar 17, 20223 min read

During this webinar we’ll discuss how nearly three-fifths of organizations have gained competitive advantage from their data lake initiatives. That includes unleashing the intelligence-generating potential of a data lake that enables ad hoc data discovery and analytics in an open and flexible manner. We’ll cover:

What is an Open Data Lake in the Cloud?

Mar 16, 20223 min read

Data-driven insights can help business and product leaders hone in on customer needs and/or find untapped opportunities. Also, analytics dashboards can be presented to customers for added value.

The Differences Between AWS Athena and AWS Glue | Ahana

Mar 16, 20224 min read

Here, we are going to talk about AWS Athena vs Glue, which is an interesting pairing as they are both complementary and competitive. So, what are they exactly?

Best Practices for Resource Management in PrestoDB

Mar 11, 20229 min read

Resource management in databases allows administrators to have control over resources and assign a priority to sessions, ensuring the most important transactions get the major share of system resources. Resource management in a distributed environment makes accessibility of data easier and manages resources over the network of autonomous computers (i.e. Distributed System). The basis of resource management in the distributed system is also resource sharing.

How to Query Parquet Files using Amazon Athena | Ahana

Mar 9, 20224 min read

Querying Parquet Files using AWS 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. … Continue reading How to Query Parquet Files using Amazon Athena | Ahana

Configuring RaptorX – a multi-level caching with Presto

Mar 8, 202211 min read

Configuring RaptorX – a multi-level caching with Presto RaptorX Background and Context Meta introduced a multi-level cache at PrestoCon 2021. Code-named the “RaptorX Project,” it aims to make Presto 10x … 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!

The Differences Between AWS RedShift Spectrum vs Athena

Mar 4, 20225 min read

While the thrust of this article is an AWS Redshift Spectrum vs Athena comparison, there can be some confusion with the difference between AWS Redshift Spectrum and AWS Redshift. Very briefly, Redshift is the storage layer/data warehouse, and Redshift Spectrum is an extension to Redshift that is a query engine.

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, 20223 min read

AWS Lake Formation vs AWS Glue – What are the differences? As you start building your analytics stack in AWS, there are several AWS technologies to understand as you begin. … Continue reading Difference Between AWS Lake Formation vs AWS Glue

Building an Open Data Lakehouse with Presto, Hudi and AWS S3

Feb 16, 20228 min read

The Open Data Lakehouse – a quick intro Data warehouses have been considered a standard to perform analytics on structured data but cannot handle unstructured data such as text, images, … Continue reading Building an Open Data Lakehouse with Presto, Hudi and AWS S3

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

How To Query Data in Amazon S3 Using Athena | Ahana

Feb 1, 20223 min read

Querying Amazon S3 Data Using AWS Athena The data lake is becoming increasingly popular for more than just data storage. Now we see much more flexibility with what you can … Continue reading How To Query Data in Amazon S3 Using Athena | Ahana

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 Presto Works with LDAP | Presto LDAP Authentication

Jan 28, 20222 min read

How does Presto Work With LDAP? What is LDAP? The Lightweight Directory Access Protocol (LDAP) is an open, vendor-neutral, industry standard application protocol used for directory services authentication. In LDAP … Continue reading How Presto Works with LDAP | Presto LDAP Authentication

What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Jan 28, 20222 min read

What is Apache Ranger? Apache Ranger™ is a framework to enable, monitor and manage comprehensive data security across the data platform. It is an open-source authorization solution that provides access … Continue reading What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Benchmarking Warehouse Workloads on the Data Lake using Presto

Jan 12, 20222 min read

Benchmarking Warehouse Workloads on the Data Lake using Presto How to run a TPC-H Benchmark on Presto Presto is an open source MPP Query engine designed from the ground up … Continue reading Benchmarking Warehouse Workloads on the Data Lake using Presto

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

Jan 11, 20222 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

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 a Data Lakehouse Architecture?

Nov 16, 20214 min read

The term Data Lakehouse has become very popular over the last year or so, especially as more customers are migrating their workloads to the cloud. This article will help to … Continue reading What is a Data Lakehouse Architecture?

Presto on Spark

Nov 15, 20219 min read

Presto on Spark Overview Presto was originally designed to run interactive queries against data warehouses, but now it has evolved into a unified SQL engine on top of open data … Continue reading 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.

How do you 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 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.

Connecting to Presto with Superset

Oct 5, 20218 min read

This blog post will provide you with an understanding of how to connect Superset to Presto. TL;DR Superset refers to a connection to a distinct data source as a database. … Continue reading Connecting to Presto with Superset

Presto Tutorial | Run PrestoDB on Google Cloud Platform

Sep 21, 202126 min read

Presto Tutorial 103: Prestodb cluster on GCP Introduction This tutorial is Part III of our Getting started with PrestoDB series. As a reminder, Prestodb is an open source distributed SQL … Continue reading Presto Tutorial | Run PrestoDB on Google Cloud Platform

How to use mathematical functions and operators and aggregate functions for Presto?

Sep 21, 20216 min read

Presto offers several classes of mathematical functions that operate on single values and mathematical operators that allow for operations on values across columns. In addition, aggregate functions can operator on … Continue reading How to use mathematical functions and operators and aggregate functions for Presto?

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 Announces New Presto Query Analyzer to Bring Instant Insights into Presto Clusters

May 18, 20223 min read

With the Presto Query Analyzer, data platform teams can get instant insights into their Presto clusters including query performance, bandwidth bottlenecks, and much more. The Presto Query Analyzer was built for the Presto community and is free to use.

What Is AWS Redshift Used For | Redshift Use Cases

May 13, 20226 min read

What is Amazon Redshift Used For? Introduction Amazon Redshift is one of the most widely-used services in the AWS ecosystem and is a familiar component in many cloud architectures. In … Continue reading What Is AWS Redshift Used For | Redshift Use Cases

Differences Between ETL and ELT in Data Warehousing | Ahana

May 12, 20224 min read

ETL vs ELT in Data Warehousing Introduction ETL, or Extract Transform Load, is when an ETL tool or series of homegrown programs extracts data from a data source(s), often a … Continue reading Differences Between ETL and ELT in Data Warehousing | Ahana

How Much Does Amazon Athena Cost? | Ahana

Apr 25, 20223 min read

Understanding AWS Athena Costs with Examples What Is Amazon Athena?  Since you’re reading this to understand Athena costs, you likely already know, so we’ll just very briefly touch on what … Continue reading How Much Does Amazon Athena Cost? | Ahana

5 Components of Data Warehouse Architecture | Ahana

Apr 25, 20225 min read

5 Components of Data Warehouse Architecture | Ahana The Data Warehouse has been around for decades. Born in the 1980s, it addressed the need for optimized analytics on data. As … Continue reading 5 Components of Data Warehouse Architecture | Ahana

An introduction to Ahana Cloud for Presto on AWS

Apr 14, 20222 min read

During this webinar we will share how to build an open data lakehouse with Presto and AWS S3 using Ahana Cloud.

AWS Lake Formation for Enterprise Data Lakes | Ahana Cloud

Apr 6, 20223 min read

AWS Lake Formation is a service that makes it easy to set up a secure data lake very quickly (in a matter of days), providing a governance layer for data lakes on AWS S3. 

How to build an Open Data Lakehouse Analytics stack

Mar 31, 20222 min read

During this webinar we’ll show you how you can build an open data lakehouse stack. At the heart of this stack is Presto, the open source SQL query engine for the data lake, and the transaction manager / governance layer, which includes technologies like Apache Hudi, Delta Lake, and AWS Lake Formation.

How to Use AWS Athena to Query JSON Data | Ahana

Mar 30, 20224 min read

A popular use case is to use Athena to query Parquet, ORC, CSV and JSON files that are typically used for querying directly, or transformed and loaded into a data warehouse.

Unlocking the Business Value of the Data Lake

Mar 17, 20223 min read

During this webinar we’ll discuss how nearly three-fifths of organizations have gained competitive advantage from their data lake initiatives. That includes unleashing the intelligence-generating potential of a data lake that enables ad hoc data discovery and analytics in an open and flexible manner. We’ll cover:

What is an Open Data Lake in the Cloud?

Mar 16, 20223 min read

Data-driven insights can help business and product leaders hone in on customer needs and/or find untapped opportunities. Also, analytics dashboards can be presented to customers for added value.

The Differences Between AWS Athena and AWS Glue | Ahana

Mar 16, 20224 min read

Here, we are going to talk about AWS Athena vs Glue, which is an interesting pairing as they are both complementary and competitive. So, what are they exactly?

Best Practices for Resource Management in PrestoDB

Mar 11, 20229 min read

Resource management in databases allows administrators to have control over resources and assign a priority to sessions, ensuring the most important transactions get the major share of system resources. Resource management in a distributed environment makes accessibility of data easier and manages resources over the network of autonomous computers (i.e. Distributed System). The basis of resource management in the distributed system is also resource sharing.

How to Query Parquet Files using Amazon Athena | Ahana

Mar 9, 20224 min read

Querying Parquet Files using AWS 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. … Continue reading How to Query Parquet Files using Amazon Athena | Ahana

Configuring RaptorX – a multi-level caching with Presto

Mar 8, 202211 min read

Configuring RaptorX – a multi-level caching with Presto RaptorX Background and Context Meta introduced a multi-level cache at PrestoCon 2021. Code-named the “RaptorX Project,” it aims to make Presto 10x … 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!

The Differences Between AWS RedShift Spectrum vs Athena

Mar 4, 20225 min read

While the thrust of this article is an AWS Redshift Spectrum vs Athena comparison, there can be some confusion with the difference between AWS Redshift Spectrum and AWS Redshift. Very briefly, Redshift is the storage layer/data warehouse, and Redshift Spectrum is an extension to Redshift that is a query engine.

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, 20223 min read

AWS Lake Formation vs AWS Glue – What are the differences? As you start building your analytics stack in AWS, there are several AWS technologies to understand as you begin. … Continue reading Difference Between AWS Lake Formation vs AWS Glue

Building an Open Data Lakehouse with Presto, Hudi and AWS S3

Feb 16, 20228 min read

The Open Data Lakehouse – a quick intro Data warehouses have been considered a standard to perform analytics on structured data but cannot handle unstructured data such as text, images, … Continue reading Building an Open Data Lakehouse with Presto, Hudi and AWS S3

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

How To Query Data in Amazon S3 Using Athena | Ahana

Feb 1, 20223 min read

Querying Amazon S3 Data Using AWS Athena The data lake is becoming increasingly popular for more than just data storage. Now we see much more flexibility with what you can … Continue reading How To Query Data in Amazon S3 Using Athena | Ahana

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 Presto Works with LDAP | Presto LDAP Authentication

Jan 28, 20222 min read

How does Presto Work With LDAP? What is LDAP? The Lightweight Directory Access Protocol (LDAP) is an open, vendor-neutral, industry standard application protocol used for directory services authentication. In LDAP … Continue reading How Presto Works with LDAP | Presto LDAP Authentication

What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Jan 28, 20222 min read

What is Apache Ranger? Apache Ranger™ is a framework to enable, monitor and manage comprehensive data security across the data platform. It is an open-source authorization solution that provides access … Continue reading What is Apache Ranger | Apache Ranger in Hadoop | Ahana

Benchmarking Warehouse Workloads on the Data Lake using Presto

Jan 12, 20222 min read

Benchmarking Warehouse Workloads on the Data Lake using Presto How to run a TPC-H Benchmark on Presto Presto is an open source MPP Query engine designed from the ground up … Continue reading Benchmarking Warehouse Workloads on the Data Lake using Presto

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

Jan 11, 20222 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

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 a Data Lakehouse Architecture?

Nov 16, 20214 min read

The term Data Lakehouse has become very popular over the last year or so, especially as more customers are migrating their workloads to the cloud. This article will help to … Continue reading What is a Data Lakehouse Architecture?

Presto on Spark

Nov 15, 20219 min read

Presto on Spark Overview Presto was originally designed to run interactive queries against data warehouses, but now it has evolved into a unified SQL engine on top of open data … Continue reading 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.

How do you 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 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.

Connecting to Presto with Superset

Oct 5, 20218 min read

This blog post will provide you with an understanding of how to connect Superset to Presto. TL;DR Superset refers to a connection to a distinct data source as a database. … Continue reading Connecting to Presto with Superset

Presto Tutorial | Run PrestoDB on Google Cloud Platform

Sep 21, 202126 min read

Presto Tutorial 103: Prestodb cluster on GCP Introduction This tutorial is Part III of our Getting started with PrestoDB series. As a reminder, Prestodb is an open source distributed SQL … Continue reading Presto Tutorial | Run PrestoDB on Google Cloud Platform

How to use mathematical functions and operators and aggregate functions for Presto?

Sep 21, 20216 min read

Presto offers several classes of mathematical functions that operate on single values and mathematical operators that allow for operations on values across columns. In addition, aggregate functions can operator on … Continue reading How to use mathematical functions and operators and aggregate functions for Presto?

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