Warehouse-native Amplitude: Overview

Your data warehouse stores critical data on every aspect of your business. Some of that data never reaches Amplitude, which makes it inaccessible for Amplitude analyses.

With Warehouse-native Amplitude (WNA), you can create custom analyses using data models based directly on data in your data warehouse. Because you no longer ingest event and end-user data into Amplitude, you can unlock more and newer datasets, especially time-sensitive ones. WNA delivers insights into user behavior, identifies trends, and supports data-driven decisions, all based on data in your own data warehouse.

Create a warehouse-native project

To create a Warehouse-native project in your Amplitude organization:

1. In Amplitude, go to Settings > Organization settings.
2. Click Projects.
3. On the Projects tab, click Create Warehouse Native Project.
4. In the modal that appears, enter a Project name that describes the project, then click Next.
5. Set the Users and roles for your project from your organization's users.
6. Amplitude creates the project and prompts you to connect your Snowflake instance.

Connect to Snowflake

Warehouse-native Amplitude uses a direct connection to Snowflake to generate queries and run them in your data warehouse. You decide the size of the warehouse that runs the Amplitude-generated queries. Create a service account so Amplitude can access the datasets in your Snowflake instance. Amplitude requires read access to these datasets (DB, Schema, and Table). Snowflake charges for the compute costs of queries that Warehouse-native Amplitude generates.

After you provide the read-only credentials from Snowflake and validate the connection, create your first data model.

Performance and optimization

Amplitude recommends clustering keys in tables to improve performance and reduce latency. Consider the date column as part of the key, since most queries include it.

Constraints

Warehouse-native Amplitude doesn't support the following formulas:

• HIST.
• PERCENTILE.
• ROLLWINBEFORE.
• CUMSUM.
• ACTIVE.
• ARPAU.
• FREQPERCENTILE.
• PROPCOUNT.
• PROPCOUNTAVG.
• PROPHIST.
• PROPMIN.
• PROPMAX.
• REVENUETOTAL.

Some Amplitude charts include features that warehouse-native projects don't support. Unsupported features include:

Event segmentation

• Segmenting by new and active users.
• Measuring events as cumulative.
• Real-time intervals.
• Event dropdown doesn't contain derived events, merged events, drop filters, top global events, any active event, or new user.

Funnel analysis

• Viewing events in exact order.
• Measuring events as frequency, improvement, significance, A/B test, or time to convert.
• Calculating the sum of X.

Retention

• Custom retention intervals.
• Usage interval view.
• Microscope.

Cohorts

• Segmenting by new user or propensity.
• Event dropdown doesn't contain derived events, merged events, drop filters, computed properties, derived properties, prediction scores, top global events, any active event, or new user.

Journeys

• Expanding events by property.
• Completed within session.
• Filter by paths > Expand by property.
• Microscope.