Snowflake-specific behavior in Peak, including incremental load support, audit fields, case-sensitive SQL semantics, and schema management considerations.

This page summarizes how Peak behaves when your organization uses Snowflake as the data warehouse.

Snowflake supports incremental load only. When data is ingested, Peak appends audit fields such as peakauditcreatedate and feed-run-id.

Snowflake uses case-sensitive SQL semantics. Unquoted identifiers are stored and resolved in uppercase. Use double quotes if you need to preserve lowercase identifiers.

When you build images for Workspaces, Workflows, or Web Apps, include Snowflake connectors, drivers, and connection parameters. Store credentials as environment variables prefixed with SNOWFLAKE_.

Snowflake requires explicit column selection and consistent case handling. If a column name uses lowercase, wrap it in double quotes and define an alias. Avoid using * in queries when lowercase identifiers are used.