Use Case
Data Warehousing & Lakes
Centralizing analytical data in warehouses and lakes.
43 providers
151 APIs
29 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.
43 API providers on the APIs.io network offer data warehousing & lakes. The highest-rated are Oracle Cloud Infrastructure, Airbyte, Amazon S3, Azure Databricks, Redox.
Providers
Ranked by API Evangelist rating — Exemplar and Strong are expanded by default.
Exemplar 2 Complete, well-documented, and agent-ready
Strong 11 Solid coverage with minor gaps
Amazon S3Amazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data...Azure DatabricksAzure Databricks is an Apache Spark-based analytics platform optimized for Microsoft Azure. It provides a c...RedoxRedox is a healthcare data interoperability platform, founded in 2014 and headquartered in Madison, Wiscons...Google Cloud PlatformGoogle Cloud Platform enables developers to build, test, and deploy applications on Google's highly-scalabl...Amazon Lake FormationAWS Lake Formation is a service that makes it easy to set up a secure data lake in days, providing centrali...DatabricksCollection of Databricks REST APIs for managing workspaces, clusters, jobs, and data operations.Oracle GoldenGateOracle GoldenGate enables real-time data integration and replication in heterogeneous IT environments. Thes...AmplitudeAmplitude is a digital analytics platform that helps product teams understand user behavior, run experiment...Amazon GlueAmazon Glue is a serverless data integration service that makes it simple to discover, prepare, move, and i...Amazon RedshiftAmazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to an...Google Cloud StorageObject storage service offering high durability, availability, and scalability for storing and accessing da...
Developing 15 Usable, with meaningful gaps to close
Amazon Data PipelineAWS Data Pipeline is a web service that helps you reliably process and move data between different AWS comp...AWS Lake FormationAWS Lake Formation is a fully managed service that makes it easy to build, secure, and manage data lakes. I...Workday Report WriterAPIs for Workday Report Writer - a tool for creating custom reports and data extracts from Workday HCM and ...Microsoft SQL Server APIsA collection of APIs and interfaces for interacting with Microsoft SQL Server.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 S3 APIAmazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data...Amazon AppFlowAmazon AppFlow is a fully managed integration service that enables you to securely transfer data between Sa...SAP HANAAPIs for SAP HANA, an in-memory, column-oriented, relational database management system developed and marke...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 ...TeradataTeradata provides enterprise analytics and data management solutions. The Teradata VantageCloud platform de...InformaticaCollection of APIs for Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud ...Apache DorisApache Doris is a high-performance, real-time analytical database based on MPP (Massively Parallel Processi...JeticJetic is the first and only cloud-native API & Integration Platform based on Apache Camel. An iPaaS solutio...
Thin 9 Limited public surface area
Apache SparkApache Spark is a unified analytics engine for large-scale data processing. It provides high-level APIs in ...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 LakeEnterprise 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 29
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.