Amplitude
Amplitude is a product analytics platform that enables you to build products by tracking and understanding user behavior.
Amplitude integration relies on the Amplitude Query product add-on, which utilizes a Snowflake database to store data.
Amplitude integrations can replicate event and merged user ID data.
See the Schema section for a list of objects available for replication.Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Creating the connection
Weitere Informationen finden Sie unter Herstellung einer Verbindung zu SaaS-Anwendungen.
- Füllen Sie die erforderlichen Verbindungseigenschaften aus.
Geben Sie einen Namen für die Verbindung in Verbindungsname ein.
Wählen Sie Verbindungsmetadaten öffnen aus, um nach der Erstellung Metadaten für die Verbindung zu definieren.
Klicken Sie auf Erstellen.
| Setting | Description |
|---|---|
| Data gateway | Wählen Sie ein Data Movement Gateway aus, wenn dies für Ihren Anwendungsfall erforderlich ist. Informationshinweis Dieses Feld ist für das Qlik Talend Cloud Starter-Abonnement nicht verfügbar, da dieses Abonnement Data Movement Gateway nicht unterstützt. Wenn Sie eine andere Abonnementstufe haben und Data Movement Gateway nicht verwenden möchten, wählen Sie Keine. Weitere Informationen zu den Vorteilen von Data Movement Gateway und den Anwendungsfällen, in denen es erforderlich ist, finden Sie unter Qlik Data Gateway – Datenbewegung. |
| Start Date | Geben Sie das Datum im Format |
| Amplitude Snowflake Username | Enter your Snowflake username. |
| Amplitude Snowflake Password | Enter the Snowflake user's password. |
| Amplitude Snowflake Account | Enter the Snowflake account. |
| Amplitude Snowflake Warehouse | Enter the name of the Snowflake warehouse. |
| Amplitude Snowflake Database | Enter the name of the Snowflake database. |
Schema
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
Amplitude replicates two types of tables: Events and merged user IDs.
For each project in your Amplitude account, a set of these tables will be available for replication. Stitch will append a project’s ID to each table name to make them easily identifiable. For example: If a project has an ID of 168342, the events table for the project will be named events_168432.
You can identify which tables are for a specific project by comparing the ID in the table name to the projects in your Amplitude account. You can access this page in your Amplitude account by clicking the User menu (top right corner) > Settings > Projects.
Depending on your destination, table and column names may not appear as they are outlined below.
events
events_[project_id] tables contain info about the events logged in your Amplitude projects.
Note: Each event table will have the project ID appended. For example: If a project has an ID of 168342, the events table for the project will be named events_168432.
Replication Method | CDC |
Primary Key | uuid |
Replication Key | event_time |
| Useful links |
merge_ids
merge_ids_[project_id] tables contain info about merged users. These are users whose records have been merged with other user records to eliminate duplicates.
For example: If an anonymous user logs events anonymously before signing in, they will go from being anonymous to a recognized user. Without merging the user’s records, it’ll look like two users with two sets of events, rather than one user completing a series of events.
For more info on how Amplitude handles merging users, refer to their documentation.
Note: Each table will have the project ID appended. For example: If a project has an ID of 168342, the merged ID table for the project will be named merge_ids_168432.
Replication Method | CDC |
Primary Keys | amplitude_id merge_server_time merged_amplitude_id merge_event_time |
Replication Key | merge_event_time |
| Useful links |