Snowflake Import Listing and Stats
Learn how to track and monitor Snowflake imports.
Overview
After configuring, mapping, and setting the frequency for the import, select Import to view the Import Listing page. This page shows a list of all imports created for the Snowflake database and can also be accessed from Settings > Partners > Import Center > Filter by Snowflake.
Private Beta
SnowFlake is a private beta release. Contact your Customer Success Manager for access.
The Import Listing page will display the following:
| Header | Description |
|---|---|
| Nickname | The unique name given to each import. This helps easily identify and differentiate between different Snowflake database imports. |
| Partner | The partner integration (for example, Snowflake) used for the import. |
| Status | The current state of the import |
| Import Type | Indicates whether the import is for user profile data or event data. |
| Frequency | Displays the frequency of the data import (for example, Repeat Intervals, Custom Schedule, or Manually Trigger). |
| Health | Indicates the health of the import: |
| Last Run | Shows the date and time when the import was last triggered. |
| Created On | Displays the date when the import was created. |
| Created By | Shows the user who created the import. |
The listing page can also be filtered based on the following criteria:
| Filter Option | Description |
|---|---|
| Partner Name | Filter imports by the name of the partner (for example, Snowflake) used for the integration. |
| Sync Type | Filter by Event Data or User Profile Data to view imports of a specific type of data. |
| Status | Filter by the status of the import: |
| Frequency | Filter by the frequency of the import: |
| Created On | Filter by the instance (Created, Triggered, etc.) and select the date using the calendar widget to display results for a specific timeframe. |
| Created By | Filter by the user who created the import by selecting a user from the drop-down. This helps you view imports created by specific users. |
Apply these filters by selecting relevant checkboxes to refine the import listings based on your requirements.
Stats
Stats provides a detailed overview of data imports, including their status, success rate, and any errors encountered during the process. These stats help track the health of each import, ensuring data integrity and identifying any failed records that need attention. The stats table includes key metrics such as Total Records, Successful Syncs, Failed Syncs, and the overall health percentage of the import.
To access Stats, go to Settings > Partners > Import Center > Edit selected import > Stats.
| Label | Description |
|---|---|
| Date & Time | The timestamp when the import process was initiated. |
| Imported On | The date when the import was successfully recorded in Snowflake. |
| Health | Indicates the health of the import: |
| Total Records | The total number of records included in the import. |
| Successful Syncs | The number of records that were successfully imported into Snowflake without errors. |
| Failed Syncs | The number of records that encountered errors and failed to import during the import process. |
To review detailed import records and their processing status, follow these steps to navigate the Stats Table and access specific entry details in the right pane.
On the Stats Table, click on a specific import entry to view its detailed information in the right pane. The right pane will display individual entries from the selected import, including relevant details.
- For User Profile Data, the right pane will show:
- Result: If the result is Success, it indicates that the user profile data has been successfully imported; if Failed, it means the user profile data has not been successfully imported.
- CleverTap ID: Unique identifier for the user profile.
- For Event Data, the right pane will show:
- Result: If the result is Success, it indicates that the event data has been successfully imported; if Failed, it means the event data has not been successfully imported.
- Clevertap ID: Unique identifier associated with the event.
- Event Name: Name of the event processed in the import.
By following these steps, you can effectively track import performance, identify any errors, and ensure the accuracy and integrity of the imported data within Snowflake.
Updated 6 months ago