Build a warehouse-native data model

In Warehouse-native Amplitude, data models are the building blocks of analyses. A data model in Amplitude is a table or view in your Snowflake instance that you can use to create queries and reports. You can use multiple data models when creating an analysis in Amplitude.

While the following data types are like those used by traditional Amplitude, think of Warehouse-native events as a fact table and Warehouse-native properties (user, group, and event) as dimensional tables.

Warehouse-native Amplitude currently supports the following data model types:

Type	Mandatory fields	Description
Events	Unique ID Timestamp (`TIMESTAMP_NTZ`)	A specific action or interaction that is recorded and associated with a timestamp. This ID will be used to understand the project and organization’s MTU count as well as how Amplitude will count uniques in Analytics.
User properties (current)	Unique ID	These are current traits and attributes associated with an individual user at the present moment, such as their current preferences or recent interactions.
User properties (historical)	Unique ID Start time End time	These are traits and attributes associated with an individual user over time, such as historical preferences or past interactions.
Group properties (current)	Unique ID	Current characteristics and attributes of a group at the present moment, such as name, description, or membership composition.
Group properties (historical)	Unique ID Start time End time	Past characteristics and attributes of a group or organization over time, such as previous name, description, or past membership composition.
Event properties	Event ID	Current traits and attributes associated with a specific action or interaction that is recorded.

Create a data model

In a Warehouse-native project, navigate to Amplitude Data and click Add Models.
Select Table Selection or SQL Query as the base table option.
- Table selection provides selectable options based on the contents of your Snowflake instance. The available values reflect the access you granted to the set of credentials used for Warehouse-native Amplitude.
- SQL Query provides more flexibility for base table creation. Join tables, filter rows and use any level of SQL you need to create the base table.
When the table is finished, complete the required fields. Supported data types are listed in the data types table at the top of this article.
Map the columns in the table or view you select.
Select or deselect any columns in the table.

Note
You can update this configuration post-set up. You can also use Snowflake’s functions in the Source Column field to convert the value in the table into the desired value within Amplitude.
Click Save to name your model.