Database and Data Lake Connections

Database and Data Lake connections vary by service. Each connector will have specific security and access requirements in order for PlaidCloud to connect.

PlaidCloud enables connection directly to databases, data lakes, query engines, and lakehouses. Connections can also utilize a PlaidLink agent if services are behind a firewall.

Since the terms of database, lakehouse, query engine, and potentially others are used to refer to data that can be queried using a connection, we generally treat all of these as "Databases" despite a wide variety of underlying technology that performs the underlying query.


Amazon Athena

Configure an Amazon Athena connection in PlaidCloud to run serverless queries against data stored in Amazon S3 buckets.

Amazon Redshift

Set up an Amazon Redshift database connection in PlaidCloud to query, import, and export data with your Redshift warehouse.

Apache Doris

Configure an Apache Doris database connection in PlaidCloud to run real-time analytical queries on large-scale data sets.

Apache Hive

Set up an Apache Hive data lake connection in PlaidCloud to query and integrate large-scale data stored in Hadoop ecosystems.

Apache Spark

Set up an Apache Spark database connection in PlaidCloud to run distributed queries and integrate big data into workflows.

Azure Databricks

Configure an Azure Databricks connection in PlaidCloud to integrate Spark-based analytics and lakehouse data into workflows.

Databend

Set up a Databend database connection in PlaidCloud to run cloud-native analytical queries with cost-effective data storage.

Exasol

Configure an Exasol database connection in PlaidCloud to run high-performance analytical queries and integrate your data.

Greenplum

Set up a Greenplum database connection in PlaidCloud to query, import, and export data with your Greenplum data warehouse.

IBM DB2

Configure an IBM DB2 database connection in PlaidCloud to query, import, and export data with your DB2 database instances.

IBM Informix

Set up an IBM Informix database connection in PlaidCloud to query, import, and export data with your Informix instances.

Microsoft Fabric

Configure a Microsoft Fabric connection in PlaidCloud to integrate analytics, data warehousing, and lakehouse capabilities.

Microsoft SQL Server

Configure a Microsoft SQL Server connection in PlaidCloud to query, import, and export data with your SQL Server databases.

MySQL

Configure a MySQL database connection in PlaidCloud to query, import, and export data with your MySQL database instances.

ODBC

Set up an ODBC database connection in PlaidCloud to connect to any database system that provides an ODBC driver interface.

Oracle

Set up an Oracle database connection in PlaidCloud to query, import, and export data with your Oracle database instances.

PlaidCloud Lakehouse

Configure the PlaidCloud Lakehouse database connection for high-performance querying and analytics on your lakehouse data.

PostgreSQL

Configure a PostgreSQL database connection in PlaidCloud to query, import, and export data with your Postgres instances.

Presto

Set up a Presto distributed query engine connection in PlaidCloud to run federated queries across multiple data sources.

SAP HANA

Set up an SAP HANA database connection in PlaidCloud to query, import, and export data with your HANA in-memory database.

Snowflake

Set up a Snowflake database connection in PlaidCloud to query, import, and export data with your Snowflake data warehouse.

StarRocks

Configure a StarRocks database connection in PlaidCloud to run high-performance analytical queries on large-scale data sets.

Trino

Set up a Trino distributed query engine connection in PlaidCloud to run federated queries across multiple data sources.