# Stream your customers' audit logs into their own Snowflake warehouse

DevFeed: [Stream your customers' audit logs into their own Snowflake warehouse](<https://devfeed.tech/articles/stream-your-customers-audit-logs-into-their-own-snowflake-warehouse-121079.md>)

Original publisher: [Read original article](<https://workos.com/blog/audit-log-streaming-snowflake>)

Author: WorkOS

Published: 2026-11-05T00:00:00Z

Content type: tutorial

Language: en

Sources: [WorkOS](<https://devfeed.tech/sources/workos-blog.md>)

Topics: [Snowflake streaming data architecture](<https://devfeed.tech/topics/snowflake-streaming-data-architecture.md>), [audit](<https://devfeed.tech/topics/audit.md>), [stream-processing](<https://devfeed.tech/topics/stream-processing.md>), [telemetry](<https://devfeed.tech/topics/telemetry.md>)

Tags: [2](<https://devfeed.tech/tags/2.md>), [2026](<https://devfeed.tech/tags/2026.md>), [3](<https://devfeed.tech/tags/3.md>), [audit](<https://devfeed.tech/tags/audit.md>), [audit-logs](<https://devfeed.tech/tags/audit-logs.md>), [auth](<https://devfeed.tech/tags/auth.md>), [customer](<https://devfeed.tech/tags/customer.md>), [customers](<https://devfeed.tech/tags/customers.md>), [event](<https://devfeed.tech/tags/event.md>), [fixed](<https://devfeed.tech/tags/fixed.md>), [key](<https://devfeed.tech/tags/key.md>), [logs](<https://devfeed.tech/tags/logs.md>), [pair](<https://devfeed.tech/tags/pair.md>), [schema](<https://devfeed.tech/tags/schema.md>), [snowflake](<https://devfeed.tech/tags/snowflake.md>), [stream](<https://devfeed.tech/tags/stream.md>), [table](<https://devfeed.tech/tags/table.md>), [up](<https://devfeed.tech/tags/up.md>), [warehouse](<https://devfeed.tech/tags/warehouse.md>), [with](<https://devfeed.tech/tags/with.md>)

## AI overview

WorkOS Log Streams can write each organization's audit events as rows in the customer's own Snowflake account, where the customer controls storage and retention. Setup requires a dedicated user authenticated by an RSA key pair, a table with the documented schema, and a default role granted access to the warehouse, database, schema, and table; accounts with network policies must allow WorkOS's published IP addresses. The dashboard and Admin Portal configure the same stream, but the portal lets the customer provide credentials directly so the private key need not pass through support. Monitor actual delivery with a customer-specific freshness query in Snowflake: an Active state alone does not establish that rows are arriving, and the article says not to assume stop-delivery notifications. Error or Invalid streams require fixing the cause and revalidating. Delivery resumes from the last successful event, subject to the organization's WorkOS retention window; previously delivered rows remain subject to the customer's own warehouse policy.

## Source excerpt

Each audit event lands as a row in your customer's own Snowflake table, with key-pair auth, a fixed schema, grants up front, and a freshness check.