Overview

The platform queries Apache Iceberg tables in place across clouds, so teams can work with lake data without moving it. It combines that access with enterprise data warehouse capabilities, SQL analytics, transactions, streaming ingestion, and support for structured, semi-structured, and unstructured data. Storage and compute can be separated, and the deployment model is hybrid.

Oracle offers the service on OCI, AWS, Azure, Google Cloud, and Exadata Cloud@Customer. That range is useful for organizations with data and infrastructure spread across providers, while the Oracle database foundation makes it a more natural fit for teams already investing in Oracle than for buyers seeking a narrowly focused lake query service.

Key features

Lake access and integration

Catalog connections include OCI Data Catalog, AWS Glue, and Apache Iceberg catalogs in Databricks and Snowflake. Data Studio adds drag-and-drop workflows for integrating data from more than 100 application, cloud service, and database sources. Together, these features address both lake discovery and ingestion; organizations with simpler pipelines may not need such a broad integration layer.

Data Studio also supports bidirectional sharing with services such as Power BI and Tableau through Delta Sharing. That can help teams exchange data with analytics users without relying on a one-way export path.

AI, analytics, and operations

Select AI can use models from Cohere, Azure OpenAI, OpenAI, OCI Generative AI, Google, Anthropic, Hugging Face, AWS, and others. Machine learning, graph analytics, spatial features, and AI Vector Search support workloads ranging from semantic search to retrieval-augmented generation. This is a substantial toolkit for teams that want analytics and AI close to managed database infrastructure; it may be more platform than a team needs if its priority is only querying lake tables.

Oracle says autonomous management handles provisioning, configuration, security, tuning, and scaling. Data is encrypted at rest and in transit by default, and security patches and updates are applied automatically. Oracle also states that Autonomous AI Database meets a broad set of international and industry-specific compliance standards. These managed controls reduce operational work, though they do not remove the need to assess a deployment against an organization’s own requirements.

Pricing

Free and trial options

Always Free Autonomous AI Lakehouse: 0.00 USD per free, billed Free for an unlimited time, subject to capacity limits. It includes two Autonomous AI Database instances through Oracle Cloud Free Tier. The uncapped duration is useful for ongoing evaluation or small experiments, but capacity limits make it a poor basis for assuming production-scale availability.

Trial: Oracle offers US$300 in cloud credits for up to 30 days. Credits expire when spent or after 30 days, whichever comes first, so this is a time- and budget-limited way to explore beyond the Always Free offer.

For offline local development, Oracle offers an unlimited-time container image with Database Actions, ORDS, APEX, and the Database API for MongoDB. It is suited to development in a local environment, rather than a substitute for cloud capacity.

Usage-based deployments

Oracle Autonomous AI Lakehouse Serverless has custom pricing, billed by ECPU per hour and storage and backup storage per gigabyte per month. The pricing page lists ECPU, storage, backup storage, and a developer instance. This model gives teams usage-based deployment options, but variable compute and storage charges call for monitoring consumption.

Oracle Autonomous AI Lakehouse on Exadata Cloud@Customer has custom pricing, billed by ECPU per hour and developer instance per hour. It fits organizations choosing that deployment environment, but costs depend on hourly usage.

Oracle Autonomous AI Lakehouse on Dedicated Infrastructure has custom pricing, billed by ECPU per hour and developer instance per hour. The Database Exadata Infrastructure subscription has a 48-hour minimum term, a commitment to account for when planning short-lived workloads.

Bring Your Own License has custom pricing and is billed by ECPU per hour. It is listed for Serverless, Dedicated, and Exadata Cloud@Customer deployments, making it relevant to buyers considering those deployment options with their own license.

Platforms

The service supports API, Linux, self-hosted, and web environments. Its cross-cloud availability and Exadata Cloud@Customer option give organizations more deployment flexibility than a cloud-only choice, while the container image provides a separate route for local offline development.

Document support includes JSON and OSON, with a maximum document size of 32 MB. That is relevant for teams using database document capabilities, but the stated limit should be considered when workloads involve larger individual documents.

Who it's for

Oracle Autonomous AI Lakehouse is best suited to organizations that need lakehouse access across clouds and want data integration, SQL, analytics, and AI capabilities in a managed Oracle platform. It is a strong candidate when querying Iceberg data in place, connecting varied catalogs, or sharing data with Power BI and Tableau matters.

It is less compelling for buyers who need only a lightweight query engine, want predictable flat-rate pricing, or cannot work within capacity-limited free use and usage-based billing. Teams considering Exadata Cloud@Customer or Dedicated Infrastructure should also account for those deployment-specific hourly charges and, for Dedicated Infrastructure, the 48-hour minimum subscription term.

Pros and cons

Pro: Queries Apache Iceberg tables across clouds without moving data, which can simplify access to distributed lake data.
Pro: Combines broad ingestion, catalog, sharing, analytics, and AI capabilities, making it suitable for teams consolidating multiple data workflows.
Pro: Autonomous management and default encryption reduce routine operational and security work.
Pro: Always Free use has no time limit and includes two database instances, giving teams a continuing entry point subject to capacity.
Con: Always Free is capacity-limited, so it cannot be treated as a guaranteed production-scale tier.
Con: Paid offerings use ECPU-hour and, depending on deployment, storage or developer-instance charges, which makes ongoing costs usage-dependent.
Con: Dedicated Infrastructure carries a 48-hour minimum subscription term, limiting its suitability for very short deployments.
Con: The 32 MB maximum document size can constrain workloads that require larger individual documents.

Alternatives

Consider Starburst Galaxy if a forever-free tier with up to three clusters for ad hoc queries is a better starting point than Oracle’s capacity-limited free instances.

Starburst Data Platform is another option for teams seeking a forever-free tier with up to three clusters and standard ad hoc query execution.

Bauplan may suit a public-dataset or upload-based sandbox workflow with CLI, SDK, and API access, provided public data and community support meet the need.

Consider Databricks Notebooks for a free edition centered on one serverless workspace, with limited compute size and usage.

IOMETE is worth considering when a self-hosted, on-premises deployment with a stated 100-vCPU maximum and community support better matches the infrastructure plan.

Dremio may fit buyers looking for a forever-free tier with three projects, while accounting for customer cloud infrastructure costs.

LavaLake is another freemium option to compare.

AetherLake is a free web-based alternative to consider.

For broader comparisons, browse Data Lakehouse Platforms, Data Warehouse Software, Document Databases, OLAP Databases, and OLAP Software.

Verdict

Choose Oracle Autonomous AI Lakehouse if your organization needs cross-cloud Iceberg access alongside integrated data engineering, analytics, and AI in a managed platform. Its strongest reason to choose is that breadth, reinforced by autonomous operations and flexible deployment options. Look elsewhere if you need a predictable flat-rate bill, a free tier without capacity constraints, or only a focused lake query service.

	Oracle Autonomous AI Lakehouse	Trino
Free plan	Yes	Yes
Free trial	Yes	No
Paid from	Free	Free
Open source	No	No
Platforms	api, Linux, self-hosted, Web	api, Linux, self-hosted, Web
Free plan	Yes	Yes

Oracle Autonomous AI Lakehouse vs Trino

Oracle Autonomous AI Lakehouse

Trino