Connecting to Amplitude
Amplitude is a product analytics software for self-service product analytics insights to help businesses better understand their customers.
Data integration: Skyvia supports importing data to and from Amplitude, exporting Amplitude data to CSV files, and replicating Amplitude data to relational databases. It does not support synchronizing Amplitude data with other cloud apps and relational databases.
Backup: Skyvia Backup does not support Amplitude.
Query: Skyvia Query supports Amplitude.
Amplitude-Specific Features and Limitations
Skyvia has the following features and limitations for Amplitude:
In the Data Integration product, Amplitude connections are supported only for packages, which use a new data integration runtime.
Make sure that the Use new runtime checkbox is selected on the tab bar if you want to use Amplitude in your package.
Skyvia supports the following import operations for Amplitude objects:
INSERT, UPDATE, DELETE: EventCategories, EventTypes, UserProperties.
INSERT: Annotations, Events.
Skyvia does not support Synchronization for Amplitude.
Only the Id field of the Annotations object is marked as a primary key in Skyvia. For other objects, primary keys are not marked in the metadata.
Users and Groups objects are not supported.
When importing data to the Events table you are not required to specify UserId and Type values, existing in the corresponding objects. In case you insert a new Type value, the corresponding record is also created in the EventTypes object automatically.
Replication with incremental updates is supported only for the Events object. The ServerUploadTime field is used to determine record creation time. Please note that new events become available via Amplitude API only after 2-3 hours. It is recommended to run replication with incremental updates at most every 3 hours or even more seldom. If you run replication with incremental updates more often, part of the records can be skipped and never replicated.
To connect to Amplitude, you need to select the Server Region to use and specify the API Key and API Secret.
- Server Region - the region where the Amplitude server to connect is located.
- API Key — an automatically generated API key used for connecting to Amplitude.
- API Secret — an automatically generated secret, used in validating the authentication of the API Key.
At the end, use the Test Connection button to make sure that the connection is successful and then click Create Connection.
You can find your API Key and API Secret on the Amplitude Project Settings page. To find them, perform the following steps:
In your workspace, click Settings.
Under ORG SETTINGS, click Projects, and then select the project to obtain the API key for.
Finally, on the Project Settings page, copy the API key and Secret key.
Events API and Additional Connection Settings
Skyvia uses events API to query Events data. This API has a limit of 4 GB data per API call, and it allows querying data for certain period. If the limit is exceeded, Amplitude returns an error.
You can control the total period, for which events are queried when you query events data, and the period per API call, for which events are queried in the Advanced Settings.
The Events Export Period parameter determines the total period, for which the events are queried, when no filter on the ServerUploadTime field is specified.
The Events Export Delta parameter determines the length of the period, for which events are queried with one API call, in hours.
By default, Skyvia queries events for the last 30 days, and query events for one day per API call. If you have too many events, and the volume of data per day can exceed the 4 GB limit, decrease the value of the Events Export Delta parameter. On the other hand, if you have few events, you can increase this value to use less API calls.
Supported Actions and Actions Specifics
Amplitude connector supports the following actions: