Skip to main content

Storage options

Data warehouses and data lakes are primary destinations for Snowplow data. For other options, see the destinations overview page.

Data warehouse loadersโ€‹

Cloud

The cloud selection is for where your Snowplow pipeline runs. The warehouse itself can be deployed in any cloud.

DestinationTypeLoader applicationStatus
Redshift
(including Redshift serverless)
Batching (recommended)
or micro-batching
Snowplow RDB LoaderProduction-ready
SnowflakeBatching (recommended)
or micro-batching
Snowplow RDB LoaderProduction-ready
DatabricksBatching (recommended)
or micro-batching
Snowplow RDB LoaderProduction-ready
PostgresStreamingPostgres LoaderNot recommended for production use

Data lake loadersโ€‹

All lake loaders are micro-batching.

LakeFormatCompatibilityLoader applicationStatus
S3DeltaAmazon Athena, DatabricksLake LoaderEarly release
S3TSV/JSONAmazon AthenaS3 LoaderOnly recommended for use with RDB Batch Transformer or for failed events
Was this page helpful?