Use Case

Data Warehousing & Lakes

Centralizing analytical data in warehouses and lakes.

43 providers 808 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, Amazon S3, Airbyte, Amazon Lake Formation, Databricks.

Providers

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

Exemplar 9 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... 7 APIs 81.1 Amazon S3 Amazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data... 17 APIs 78.1 Airbyte Airbyte is an open-source data integration platform that enables businesses to easily and efficiently move ... 44 APIs 75.7 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 73.1 Databricks Collection of Databricks REST APIs for managing workspaces, clusters, jobs, and data operations. 57 APIs 72.2 Amplitude Amplitude is a digital analytics platform that helps product teams understand user behavior, run experiment... 33 APIs 68.0 Amazon Data Pipeline AWS Data Pipeline is a web service that helps you reliably process and move data between different AWS comp... 4 APIs 67.3 Oracle GoldenGate Oracle GoldenGate enables real-time data integration and replication in heterogeneous IT environments. Thes... 37 APIs 67.0 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 66.0
Strong 10 Solid coverage with minor gaps
AWS Redshift Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service that makes it simple and co... 130 APIs 63.5 Google Cloud Storage Object storage service offering high durability, availability, and scalability for storing and accessing da... 6 APIs 63.3 Amazon Redshift Amazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to an... 5 APIs 62.2 Apache Airflow Apache Airflow is an open-source platform to programmatically author, schedule, and monitor workflows, deve... 19 APIs 62.0 Amazon Glue Amazon Glue is a serverless data integration service that makes it simple to discover, prepare, move, and i... 202 APIs 61.7 Oracle Cloud Infrastructure Collection of Oracle Cloud Infrastructure (OCI) REST APIs for managing cloud resources and services. 25 APIs 61.0 Amazon S3 API Amazon Simple Storage Service (S3) is an object storage service offering industry-leading scalability, data... 2 APIs 60.6 Workday Report Writer APIs for Workday Report Writer - a tool for creating custom reports and data extracts from Workday HCM and ... 9 APIs 59.5 SAP HANA APIs for SAP HANA, an in-memory, column-oriented, relational database management system developed and marke... 17 APIs 58.1 Azure Databricks Azure Databricks is an Apache Spark-based analytics platform optimized for Microsoft Azure. It provides a c... 39 APIs 56.5
Developing 13 Usable, with meaningful gaps to close
Teradata Teradata provides enterprise analytics and data management solutions. The Teradata VantageCloud platform de... 11 APIs 55.5 Jetic Jetic is the first and only cloud-native API & Integration Platform based on Apache Camel. An iPaaS solutio... 5 APIs 55.0 Restaurant365 Restaurant365 is a cloud-based restaurant accounting, inventory, and operations platform serving thousands ... 9 APIs 54.6 Apache Kylin Apache Kylin is an open-source distributed analytics engine designed to provide a SQL interface and multi-d... 7 APIs 54.4 Informatica Collection of APIs for Informatica Intelligent Cloud Services (IICS) and Intelligent Data Management Cloud ... 12 APIs 54.0 Apache Iceberg Apache Iceberg is an open table format for large analytic datasets that provides ACID transactions, schema ... 5 APIs 53.1 Microsoft SQL Server APIs A collection of APIs and interfaces for interacting with Microsoft SQL Server. 21 APIs 51.0 Amazon AppFlow Amazon AppFlow is a fully managed integration service that enables you to securely transfer data between Sa... 3 APIs 48.7 Apache Ranger Apache Ranger is a framework to enable, monitor, and manage comprehensive data security across the Hadoop p... 5 APIs 47.6 Apache Hive Apache Hive is a data warehouse software that facilitates reading, writing, and managing large datasets res... 4 APIs 46.8 Apache Hudi Apache Hudi is a data lake platform that provides incremental data processing primitives including upserts ... 3 APIs 46.3 Amazon Athena Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standar... 8 APIs 44.0 Apache SeaTunnel Apache SeaTunnel is a high-performance, distributed data integration platform that supports real-time and b... 2 APIs 44.0
Thin 8 Limited public surface area
Apache Doris Apache Doris is a high-performance, real-time analytical database based on MPP (Massively Parallel Processi... 1 API 40.2 Apache Spark Apache Spark is a unified analytics engine for large-scale data processing. It provides high-level APIs in ... 6 APIs 38.7 Apache ORC Apache ORC is a self-describing, type-aware columnar file format designed for Hadoop workloads. It provides... 3 APIs 34.9 Apache Ozone Apache Ozone is a scalable, redundant, and distributed object store optimized for big data workloads. It pr... 2 APIs 34.5 Syndica Syndica is a Solana-only infrastructure company building developer infrastructure for Web3. Its production ... 4 APIs 34.5 Bloomberg Intelligence Bloomberg Intelligence provides research, data, and analytics on companies, industries, credit, government,... 5 APIs 34.3 Apache Avro Apache Avro is a data serialization system that provides rich data structures, a compact binary format, and... 1 API 31.0 Bloomberg Enterprise Bloomberg Enterprise provides enterprise-grade financial data distribution, analytics, and connectivity sol... 4 APIs 28.5
Emerging 3 Early or largely undocumented
Redox Redox is a healthcare interoperability platform that lets digital health vendors, providers, and payers sen... 4 APIs 27.0 Apache Sqoop Apache Sqoop is a command-line tool designed for efficiently transferring bulk data between Apache Hadoop a... 1 API 23.5 HR & People API and integration profile for the HR and people-operations landscape. This topic repo catalogs the API su... 27 APIs 20.7

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