Import Events from Snowflake to Netcore

Import Snowflake event data to power targeted campaigns and journeys in Netcore CE.

Overview

An Events import moves event records, such as Add To Cart, from a Snowflake table or view into Netcore CE. You choose the Snowflake connection, warehouse, database, schema, and table. You select the event, its source, and the app. You map the identity columns. You then run the import once or on a recurring schedule.

Item	Detail
Source	Snowflake
Destination	Netcore CE, as event records for your contacts
Location in Netcore CE	Settings > Data transfer > Import
Required identity mapping	EMAIL (Primary key) and Event time
Attributes mapping	No. Events has Identity mapping only.
Schedule options	One-time or Recurring
Multiple event types in one table	Supported. Select the column that contains the event name.

Pre-requisites

An active Snowflake connection in Netcore CE. See Snowflake.
Read access to the Snowflake warehouse, database, schema, and table or view that holds your events.
At least one email address to receive import alerts.
The event name, the event source, and the app name that the imported events belong to.

Refer to Import Data from Snowflake to Netcore to learn the steps to start an Events import.

Step 1: Setup

The Import details section asks for the basic details of your import.

Field name	Description
Import title	A unique name for this import. Up to 80 characters.
Connection	Select an existing Snowflake connection that you created under Integrations.
Warehouse	Select the Snowflake virtual warehouse to use. This field appears after you select a connection.
Database	Select the database to import from. This field appears after you select a warehouse.
Schema	Select the schema within the selected database. This field appears after you select a database.
Table	Select the table or view to import events from. This field appears after you select a schema.
Event	Select the event that the imported rows represent, for example Add To Cart.
Source of event	Select where the event comes from, for example App.
App name	Select the app that the event belongs to.
Alert email	Select the email addresses that receive alerts about this import.

A Contacts import does not have the Event, Source of event, and App name fields.

After you select a table, click PREVIEW to see a few sample records. Then click NEXT. Netcore CE saves your setup details.

Import a Table That Contains Multiple Events

After you select a table, the Table contains multiple events checkbox appears. Select it when a single Snowflake table stores more than one event type. An information icon next to the checkbox shows this hint: "Use this when a single table stores multiple event types. Select the column that contains the event name."

Select the Table contains multiple events checkbox. A Column name dropdown appears.
In the Column name dropdown, select the column that contains the event name. The placeholder reads "Select column name containing event."

Field	Description
Table contains multiple events	A checkbox. Select it when one table stores multiple event types.
Column name	Required when you select the checkbox. Select the column that contains the event name.

If you select the checkbox and leave Column name empty, Netcore CE outlines the dropdown in red and shows the error "Column name is required." Select a column to continue.

After you complete the Setup fields, click NEXT.

Step 2: Data Mapping

An Events import has Identity mapping only. Netcore CE does not show Attributes mapping for events.

Netcore attribute	Requirement
EMAIL (Primary key)	Required. Map it to the Snowflake column that identifies the contact who performed the event, for example `contact_email`.
Event time	Required. Map it to the Snowflake column that stores when the event happened, for example `event_time`.

When you map Event time, a date time format dropdown appears. Select the format that matches the values in your column.

The available formats include YYYY-MM-DD, YYYY/MM/DD, DD/MM/YYYY, DD-MM-YYYY, DD-MM-YYYY hh:mm:ss, and YYYY-MM-dd HH:mm:ss.SSS XX.

Click NEXT to move to Schedule.

Step 3: Schedule

The page shows your account timezone and the current date and time. Select one of two options:

Option	Behavior	Fields
One-time	Netcore CE transfers the complete dataset once. It performs no incremental transfer.	Scheduled at
Recurring	The first run transfers the complete dataset. Later runs transfer incremental data.	Start date time, End date time, Frequency (for example Every hour or Weekly)

Updated about 23 hours ago

Did this page help you?