Use Case

Data Warehousing & Lakes

Centralizing analytical data in warehouses and lakes.

38 providers 142 APIs 27 declared variants

Landing modelled and raw data in warehouses, lakes, and object stores, then cataloging, securing, and querying it for reporting, exploration, and model training.

38 API providers on the APIs.io network offer data warehousing & lakes. The highest-rated are Oracle Cloud Infrastructure, Airbyte, Amazon S3, Google Cloud Storage, Google Cloud Platform.

Providers

Ranked by API Evangelist rating — Exemplar and Strong are expanded by default.

Exemplar 3 Complete, well-documented, and agent-ready
Oracle Cloud InfrastructureOracle Cloud Infrastructure (OCI) is Oracle's public cloud, exposed as a REST control plane of 159 service ...9 published contracts76.9AirbyteAirbyte is an open-source data integration platform that enables businesses to easily and efficiently move ...1 published contract70.3Amazon S3Amazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data...2 published contracts70.2
Strong 10 Solid coverage with minor gaps
Google Cloud StorageObject storage service offering high durability, availability, and scalability for storing and accessing da...1 published contract65.0Google Cloud PlatformGoogle Cloud Platform enables developers to build, test, and deploy applications on Google's highly-scalabl...1 published contract63.4Azure DatabricksAzure Databricks is an Apache Spark-based analytics platform optimized for Microsoft Azure. It provides a c...1 published contract63.1Oracle GoldenGateOracle GoldenGate enables real-time data integration and replication in heterogeneous IT environments. Thes...6 published contracts62.4Amazon Lake FormationAWS Lake Formation is a service that makes it easy to set up a secure data lake in days, providing centrali...1 published contract60.4DatabricksCollection of Databricks REST APIs for managing workspaces, clusters, jobs, and data operations.1 published contract59.7Amazon RedshiftAmazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to an...2 published contracts58.8AmplitudeAmplitude is a digital analytics platform that helps product teams understand user behavior, run experiment...10 published contracts57.8RedoxRedox is a healthcare data interoperability platform, founded in 2014 and headquartered in Madison, Wiscons...5 APIs57.7TeradataTeradata provides enterprise analytics and data management solutions. The Teradata VantageCloud platform de...1 published contract55.0
Developing 9 Usable, with meaningful gaps to close
Workday Report WriterAPIs for Workday Report Writer - a tool for creating custom reports and data extracts from Workday HCM and ...4 published contracts52.7InformaticaCollection of APIs for Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud ...1 published contract52.6Amazon Data PipelineAWS Data Pipeline is a web service that helps you reliably process and move data between different AWS comp...1 published contract52.2Amazon AppFlowAmazon AppFlow is a fully managed integration service that enables you to securely transfer data between Sa...3 APIs49.2Apache AirflowApache Airflow is an open-source platform to programmatically author, schedule, and monitor workflows, deve...27 published contracts48.1Apache IcebergApache Iceberg is an open table format for large analytic datasets that provides ACID transactions, schema ...1 published contract46.8SAP HANAAPIs for SAP HANA, an in-memory, column-oriented, relational database management system developed and marke...1 published contract45.3Restaurant365Restaurant365 is a cloud-based restaurant accounting, inventory, and operations platform serving thousands ...2 published contracts44.9Apache DorisApache Doris is a high-performance, real-time analytical database based on MPP (Massively Parallel Processi...1 API41.0
Thin 10 Limited public surface area
Apache SparkApache Spark is a unified analytics engine for large-scale data processing. It provides high-level APIs in ...6 APIs38.3JeticJetic is the first and only cloud-native API & Integration Platform based on Apache Camel. An iPaaS solutio...1 published contract38.3Apache KylinApache Kylin is an open-source distributed analytics engine designed to provide a SQL interface and multi-d...1 published contract36.7Amazon AthenaAmazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standar...1 published contract36.4SyndicaSyndica is a Solana-only infrastructure company building developer infrastructure for Web3. Its production ...4 APIs36.4Apache HiveApache Hive is a data warehouse software that facilitates reading, writing, and managing large datasets res...1 published contract34.1Apache HudiApache Hudi is a data lake platform that provides incremental data processing primitives including upserts ...1 published contract33.5Apache RangerApache Ranger is a framework to enable, monitor, and manage comprehensive data security across the Hadoop p...1 published contract32.1Apache SeaTunnelApache SeaTunnel is a high-performance, distributed data integration platform that supports real-time and b...1 published contract27.6Bloomberg IntelligenceBloomberg Intelligence provides research, data, and analytics on companies, industries, credit, government,...5 APIs27.5
Emerging 6 Early or largely undocumented
Bloomberg EnterpriseBloomberg Enterprise provides enterprise-grade financial data distribution, analytics, and connectivity sol...4 APIs20.8Apache ORCApache ORC is a self-describing, type-aware columnar file format designed for Hadoop workloads. It provides...3 APIs20.7Apache OzoneApache Ozone is a scalable, redundant, and distributed object store optimized for big data workloads. It pr...2 APIs20.3Apache AvroApache Avro is a data serialization system that provides rich data structures, a compact binary format, and...1 API16.9Apache SqoopApache Sqoop is a command-line tool designed for efficiently transferring bulk data between Apache Hadoop a...1 API16.5HR & PeopleAPI and integration profile for the HR and people-operations landscape. This topic repo catalogs the API su...27 APIs15.5

What Providers Actually Declared

This use case is a canonical term. These are the free-text strings providers wrote in their own apis.yml that map onto it.

Building and managing data lakehouse architecturesCloud Data Warehouse HydrationCloud Data Warehouse LoadingData Lake AnalyticsData Lake IngestionData Lake ProcessingData Lake SecurityData Lake StorageData Lake and AnalyticsData Lakehouse AnalyticsData LakesData Warehouse AnalyticsData Warehouse IntegrationData Warehouse LoadingData Warehouse Query AccelerationData Warehouse ReplicationData Warehouse and Lake HydrationData WarehousingData lake foundation for analytics workloadsEnterprise Data WarehousingHive Data WarehousingIndexers and data warehousesLakehouse AnalyticsPeople Data WarehouseReal-time data warehouse loading and synchronizationRun ad-hoc SQL queries on data lake without ETLStreaming Data Lake

Scroll for all 27

Work with this as data

Every use case here is available over the APIs.io API and to AI agents over MCP. Use Cases is not yet its own endpoint on the v1 API. Reach it through catalog search and the tag graph, or the MCP server.

MCP server

One button, every client — Claude, Cursor, VS Code and the rest.

https://apis.io/mcp

Tools for use cases

3 MCP tools reach this
  • apis_io_searchSTART HERE — APIs, providers and tags for one query, each with its total.
  • resolveTurn a domain, URL or GitHub org into the provider it belongs to.
  • find_cohortsEvery scored population of providers in the catalog.
All 92 tools →

Call it yourself

curl for this page
Search the catalog 
curl "https://apis.io/api/v1/search?q=data-warehousing&limit=10"
Everything under a tag 
curl "https://apis.io/api/v1/tags/data-warehousing"

Discovery needs no key. Ratings and market analysis are Pro.

Get an API key

Free tier, no form to fill in. Signing in shares your email address with us — we store it to create your key and to recognise you if you sign in with another provider. See our Privacy Policy and Terms.

GitHub Google LinkedIn

A second provider on the same verified email joins the account you already have.