Blueshift supports multiple ways of importing customer data. After you import customer data into your Blueshift account, Blueshift can easily build a 360 degree view of all your customers.
Import customer data
You can send customer data to Blueshift using any of the following methods:
|Amazon S3 bucket||
You can upload a customer data CSV file from an Amazon S3 bucket. Blueshift recommends that you use this method when possible.
Configure the job to run hourly/daily/weekly. When the upload is done, you will get an email with the upload status.
You can get high throughput with the customer attribute upload job. Blueshift can process around 1M users/hr and the background job also takes care of retries.
For more information, see Customer data from S3.
With the integration of Blueshift and Snowflake, you can import customer data into your Blueshift account very easily.
Before you can import data from Snowflake you must set up integration of Blueshift with Snowflake and configure at least one adapter.
For more information, see Customer data from Snowflake.
You can upload a customer data CSV file from the Blueshift UI.
For more information, see Customer data from UI.
You can upload a list of customers from the UI.
If you use Blueshift's SDKs to integrate your apps with Blueshift, you can send customer data to Blueshift.
For more information, see Blueshift's Developer Portal.
Use Blueshift's APIs to send customer data to Blueshift.
For more information, see APIs to import customer data.
You can import historical customer data in CSV format into Blueshift to help build a better profile of your customers. For more information, see Historical Data.
View import tasks
To view information about the customer data import tasks, go to Customer Data > Attributes in the left navigation. Click +CUSTOMERS > View Uploads.
On the index page for Customer imports, the status for each task is shown with an overall status that identifies which state the task is in. A task can be in one of the following four statuses:
|Draft||The task is saved along with the configuration but not launched as yet. This is an inactive state.|
|Launched||The task is active. If it is a recurring task, the task remains in this state for the entire duration of its lifetime.|
|Paused||The task has been paused. This is an inactive state which occurs only when a task is paused by the user.|
|Completed||The task has completed its life cycle. This is an inactive state and is reached only when a recurring task reaches its end time or when processing is completed for a one time task.|
When you click an individual task, the Import task details page opens. You can view more details about the status for each time a recurring task runs.
The details page shows the following information about the task:
- Last Fetch Status - Shows the status for the last run of fetching of data from Snowflake into Blueshift. The status can be Fetching, Fetched, or Failed.
- Fetch Start time - Shows the start time for the last run of fetching of data from Snowflake into Blueshift
- Fetch end time - Shows the end time for the last run of fetching of data from Snowflake into Blueshift
The table provides details on the data that was processed when the task ran.
- The status can be Processing, Processed, or Failed.
- Information about Total records, Processed records, and Errored records is also shown.
- You can Download the data that was processed in CSV format and also Download Error File to understand why a particular record resulted in an error.
Note: If there are errors in processing the fetched data, the status is still set as ‘Processed’.
Other import task actions
- Click the drop down in the actions menu and click on the corresponding action in the dropdown to View, Download, or Remove a task.
- You can Pause a recurring import task.
- When you click a task to view the details, you can Edit Import Task. You can only edit import tasks if the Update Method is Snowflake.
You can validate your import by searching for users that you have imported or updated from Customer Data > Attributes.