Use Case
Data Warehousing & Lakes
Centralizing analytical data in warehouses and lakes.
40 providers
128 APIs
28 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.
40 API providers on the APIs.io network offer data warehousing & lakes. The highest-rated are Oracle Cloud Infrastructure, Amazon S3, Airbyte, Azure Databricks, Google Cloud Storage.
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 ...Amazon S3Amazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data...AirbyteAirbyte is an open-source data integration platform that enables businesses to easily and efficiently move ...
Strong 10 Solid coverage with minor gaps
Azure DatabricksAzure Databricks is an Apache Spark-based analytics platform optimized for Microsoft Azure. It provides a c...Google Cloud StorageObject storage service offering high durability, availability, and scalability for storing and accessing da...Oracle GoldenGateOracle GoldenGate enables real-time data integration and replication in heterogeneous IT environments. Thes...RedoxRedox is a healthcare data interoperability platform, founded in 2014 and headquartered in Madison, Wiscons...Amazon GlueAmazon Glue is a serverless data integration service that makes it simple to discover, prepare, move, and i...Amazon Lake FormationAWS Lake Formation is a service that makes it easy to set up a secure data lake in days, providing centrali...Google Cloud PlatformGoogle Cloud Platform enables developers to build, test, and deploy applications on Google's highly-scalabl...DatabricksCollection of Databricks REST APIs for managing workspaces, clusters, jobs, and data operations.AmplitudeAmplitude is a digital analytics platform that helps product teams understand user behavior, run experiment...Amazon RedshiftAmazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to an...
Developing 13 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 ...Amazon Data PipelineAWS Data Pipeline is a web service that helps you reliably process and move data between different AWS comp...AWS RedshiftAmazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and co...Restaurant365Restaurant365 is a cloud-based restaurant accounting, inventory, and operations platform serving thousands ...Amazon AppFlowAmazon AppFlow is a fully managed integration service that enables you to securely transfer data between Sa...Apache AirflowApache Airflow is an open-source platform to programmatically author, schedule, and monitor workflows, deve...Apache IcebergApache Iceberg is an open table format for large analytic datasets that provides ACID transactions, schema ...InformaticaCollection of APIs for Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud ...SAP HANAAPIs for SAP HANA, an in-memory, column-oriented, relational database management system developed and marke...Apache DorisApache Doris is a high-performance, real-time analytical database based on MPP (Massively Parallel Processi...TeradataTeradata provides enterprise analytics and data management solutions. The Teradata VantageCloud platform de...Apache SparkApache Spark is a unified analytics engine for large-scale data processing. It provides high-level APIs in ...JeticJetic is the first and only cloud-native API & Integration Platform based on Apache Camel. An iPaaS solutio...
Thin 8 Limited public surface area
Amazon AthenaAmazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standar...SyndicaSyndica is a Solana-only infrastructure company building developer infrastructure for Web3. Its production ...Apache KylinApache Kylin is an open-source distributed analytics engine designed to provide a SQL interface and multi-d...Apache HiveApache Hive is a data warehouse software that facilitates reading, writing, and managing large datasets res...Apache HudiApache Hudi is a data lake platform that provides incremental data processing primitives including upserts ...Apache RangerApache Ranger is a framework to enable, monitor, and manage comprehensive data security across the Hadoop p...Apache SeaTunnelApache SeaTunnel is a high-performance, distributed data integration platform that supports real-time and b...Bloomberg IntelligenceBloomberg Intelligence provides research, data, and analytics on companies, industries, credit, government,...
Emerging 6 Early or largely undocumented
Bloomberg EnterpriseBloomberg Enterprise provides enterprise-grade financial data distribution, analytics, and connectivity sol...Apache ORCApache ORC is a self-describing, type-aware columnar file format designed for Hadoop workloads. It provides...Apache OzoneApache Ozone is a scalable, redundant, and distributed object store optimized for big data workloads. It pr...Apache AvroApache Avro is a data serialization system that provides rich data structures, a compact binary format, and...Apache SqoopApache Sqoop is a command-line tool designed for efficiently transferring bulk data between Apache Hadoop a...HR & PeopleAPI and integration profile for the HR and people-operations landscape. This topic repo catalogs the API su...
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 ETLData 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 28
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.