# Integration directory

Choose a technology to find its connection, ingestion, and query guides. The task-based guides remain available in the lakehouse navigation.

## Technologies with multiple workflows

- [DuckDB integration](/docs/lakehouse/integrations/duckdb.md): Choose how DuckDB works with Altertable: query managed tables, ingest local results, connect an existing database, or write DuckDB SQL.
- [Amazon S3 integration](/docs/lakehouse/integrations/amazon-s3.md): Choose how to use Amazon S3 with Altertable: query existing files, import files, connect S3 Tables or Glue, or store managed catalog data.
- [Cloudflare R2 integration](/docs/lakehouse/integrations/cloudflare-r2.md): Choose how Cloudflare R2 works with Altertable: connect its Iceberg catalog, query or import files, or provide storage for managed catalogs.

For other object storage, compare [querying files](/docs/lakehouse/query/object-storage.md), [importing files](/docs/lakehouse/ingest/object-storage.md), and [managed catalog storage](/docs/lakehouse/storage/buckets.md). For other Iceberg catalogs, see [Iceberg tables](/docs/lakehouse/external-catalogs/iceberg-tables.md) and [Apache Polaris](/docs/lakehouse/external-catalogs/apache-polaris.md).

## Databases and warehouses

Use [the external catalog directory](/docs/lakehouse/external-catalogs.md) for Snowflake, BigQuery, Postgres, MySQL, MariaDB, MongoDB, Redshift, Supabase, and other sources. Each guide lists the connection fields and source-specific prerequisites.

## Application code and dataframes

- [SDK installation and availability](/docs/api-references/sdks.md#lakehouse-sdks).
- [Query from application code](/docs/lakehouse/query/http-api.md) and [load records or files](/docs/lakehouse/ingest/http-api.md).
- [Query with Pandas, Polars, or Ibis](/docs/lakehouse/query/pandas-polars-ibis.md) and [ingest from dataframes](/docs/lakehouse/ingest/pandas-polars-ibis.md).

## SQL clients, BI, and pipelines

- [SQL and BI clients](/docs/lakehouse/clients.md): CLI, Postgres, Arrow Flight SQL, Metabase, and Hex.
- [Pipeline integrations](/docs/lakehouse/ingest/integrations.md): Airbyte, dlt, Fivetran, PostHog, and Segment.
- [dbt transformations](/docs/lakehouse/modeling/dbt.md).