Use Case

Data Warehousing & Lakes

Centralizing analytical data in warehouses and lakes.

43 providers 302 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 Google Cloud Platform, Databricks, Oracle Cloud Infrastructure, Airbyte, Amazon S3.

Providers

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

Exemplar 6 Complete, well-documented, and agent-ready
Google Cloud Platform Google Cloud Platform enables developers to build, test, and deploy applications on Google's highly-scalabl... 36 APIs 75.8 Databricks Collection of Databricks REST APIs for managing workspaces, clusters, jobs, and data operations. 57 APIs 73.3 Oracle Cloud Infrastructure Collection of Oracle Cloud Infrastructure (OCI) REST APIs for managing cloud resources and services. 8 APIs 71.4 Airbyte Airbyte is an open-source data integration platform that enables businesses to easily and efficiently move ... 1 API 71.2 Amazon S3 Amazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data... 3 APIs 71.2 Amplitude Amplitude is a digital analytics platform that helps product teams understand user behavior, run experiment... 20 APIs 70.2
Strong 11 Solid coverage with minor gaps
Oracle GoldenGate Oracle GoldenGate enables real-time data integration and replication in heterogeneous IT environments. Thes... 6 APIs 68.1 Teradata Teradata provides enterprise analytics and data management solutions. The Teradata VantageCloud platform de... 2 APIs 66.9 Amazon Lake Formation AWS Lake Formation is a service that makes it easy to set up a secure data lake in days, providing centrali... 1 API 66.3 Amazon Data Pipeline AWS Data Pipeline is a web service that helps you reliably process and move data between different AWS comp... 1 API 65.1 AWS Lake Formation AWS Lake Formation is a fully managed service that makes it easy to build, secure, and manage data lakes. I... 1 API 63.2 AWS Redshift Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and co... 3 APIs 63.2 Amazon Redshift Amazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to an... 3 APIs 62.0 Amazon AppFlow Amazon AppFlow is a fully managed integration service that enables you to securely transfer data between Sa... 1 API 61.5 Apache Airflow Apache Airflow is an open-source platform to programmatically author, schedule, and monitor workflows, deve... 2 APIs 61.3 Amazon Glue Amazon Glue is a serverless data integration service that makes it simple to discover, prepare, move, and i... 1 API 60.7 Azure Databricks Azure Databricks is an Apache Spark-based analytics platform optimized for Microsoft Azure. It provides a c... 39 APIs 60.7
Developing 17 Usable, with meaningful gaps to close
Workday Report Writer APIs for Workday Report Writer - a tool for creating custom reports and data extracts from Workday HCM and ... 4 APIs 58.2 Apache Kylin Apache Kylin is an open-source distributed analytics engine designed to provide a SQL interface and multi-d... 2 APIs 57.7 Amazon S3 API Amazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data... 1 API 57.4 Apache Iceberg Apache Iceberg is an open table format for large analytic datasets that provides ACID transactions, schema ... 3 APIs 55.0 SAP HANA APIs for SAP HANA, an in-memory, column-oriented, relational database management system developed and marke... 13 APIs 55.0 Google Cloud Storage Object storage service offering high durability, availability, and scalability for storing and accessing da... 2 APIs 54.7 Jetic Jetic is the first and only cloud-native API & Integration Platform based on Apache Camel. An iPaaS solutio... 1 API 53.0 Restaurant365 Restaurant365 is a cloud-based restaurant accounting, inventory, and operations platform serving thousands ... 2 APIs 52.6 Microsoft SQL Server APIs A collection of APIs and interfaces for interacting with Microsoft SQL Server. 21 APIs 51.4 Apache Ranger Apache Ranger is a framework to enable, monitor, and manage comprehensive data security across the Hadoop p... 1 API 51.2 Informatica Collection of APIs for Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud ... 7 APIs 49.9 Apache ORC Apache ORC is a self-describing, type-aware columnar file format designed for Hadoop workloads. It provides... 1 API 48.8 Apache Ozone Apache Ozone is a scalable, redundant, and distributed object store optimized for big data workloads. It pr... 1 API 48.8 Apache Hudi Apache Hudi is a data lake platform that provides incremental data processing primitives including upserts ... 2 APIs 48.5 Apache SeaTunnel Apache SeaTunnel is a high-performance, distributed data integration platform that supports real-time and b... 1 API 47.9 Apache Hive Apache Hive is a data warehouse software that facilitates reading, writing, and managing large datasets res... 2 APIs 47.2 Apache Doris Apache Doris is a high-performance, real-time analytical database based on MPP (Massively Parallel Processi... 1 API 45.7
Thin 7 Limited public surface area
Bloomberg Intelligence Bloomberg Intelligence provides research, data, and analytics on companies, industries, credit, government,... 5 APIs 37.6 Amazon Athena Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standar... 1 API 37.5 Apache Spark Apache Spark is a unified analytics engine for large-scale data processing. It provides high-level APIs in ... 5 APIs 37.1 Apache Avro Apache Avro is a data serialization system that provides rich data structures, a compact binary format, and... 1 API 35.7 Syndica Syndica is a Solana-only infrastructure company building developer infrastructure for Web3. Its production ... 4 APIs 31.3 Redox Redox is a healthcare interoperability platform that lets digital health vendors, providers, and payers sen... 4 APIs 30.3 Bloomberg Enterprise Bloomberg Enterprise provides enterprise-grade financial data distribution, analytics, and connectivity sol... 4 APIs 30.0
Emerging 2 Early or largely undocumented
HR & People API and integration profile for the HR and people-operations landscape. This topic repo catalogs the API su... 27 APIs 25.9 Apache Sqoop Apache Sqoop is a command-line tool designed for efficiently transferring bulk data between Apache Hadoop a... 1 API 25.6

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