Snowflake

This page describes how to set up Snowflake as a destination.

Set up

An example setup for Snowflake is shown below.

src/pages/api/syft.ts

// ...
const destinations = [
  {
    type: "snowflake",
    settings: {
        account: "xxxx",
        warehouse: "xxxx",
        database: "xxxx",
        schema: PUBLIC,
        username: "xxxx",
        password: "xxxx"
    },
  },
];
// ...

Configuration options

Name	Type	Description	Required	Default
account	string	Your Snowflake Account	true
warehouse	string	Your Snowflake Warehouse	true
database	string	Your Snowflake Database	true
schema	string	Your Snowflake Schema	true	PUBLIC
username	string	Your Snowflake Username	true
password	string	Your Snowflake Password. This is a secret field.	true

Data Modeling

Track Calls

Insert

Matched events

type = "track" or type = "screen" or type = "page"

Data Mapping

Destination Field	Type	Description	Source Field
_id	string	The unique ID of the track call itself.	$.messageId
anonymous_id	string	The anonymous ID of the user.	$.anonymousId
user_id	string	The User ID.	$.userId
context_ip	string	The IP address of the client. Non-user-related context fields sent with each track call.	$.context.ip
context_library_name	string	The Logging library name. Non-user-related context fields sent with each track call.	$.context.library.name
context_library_version	string	The Logging library version. Non-user-related context fields sent with each track call.	$.context.library.version
context_page_path	string	The path of the page on which the event was logged.	$.context.page.path
context_page_title	string	The title of the page on which the event was logged.	$.context.page.title
context_page_url	string	The full url of the page on which the event was logged.	$.context.page.url
context_locale	string	The browsers locale used when the event was logged.	$.context.locale
context_user_agent	string	The browsers user-agent string.	$.context.userAgent
event	string	The slug of the event name, so you can join the tracks table.	$.event
name	string	The event name.	$.name
received_at	datetime	When Syft received the track call.	$.receivedAt
sent_at	datetime	When a user triggered the track call. This timestamp can also be affected by device clock skew	$.sentAt
timestamp	datetime	The UTC-converted timestamp which is set by the Syft library	$.timestamp
properties	object	JSON representation of the properties for the event.	$.properties
context	object	JSON representation of the context	$.context

,

Identify Calls

Insert

Matched events

type = "identify" or type = "group"

Data Mapping

Destination Field	Type	Description	Source Field
_id	string	The unique ID of the track call itself.	$.messageId
anonymous_id	string	The anonymous ID of the user.	$.anonymousId
user_id	string	The User ID.	$.userId
context_ip	string	The IP address of the client. Non-user-related context fields sent with each track call.	$.context.ip
context_library_name	string	The Logging library name. Non-user-related context fields sent with each track call.	$.context.library.name
context_library_version	string	The Logging library version. Non-user-related context fields sent with each track call.	$.context.library.version
context_page_path	string	The path of the page on which the event was logged.	$.context.page.path
context_page_title	string	The title of the page on which the event was logged.	$.context.page.title
context_page_url	string	The full url of the page on which the event was logged.	$.context.page.url
context_locale	string	The browsers locale used when the event was logged.	$.context.locale
context_user_agent	string	The browsers user-agent string.	$.context.userAgent
event	string	The slug of the event name, so you can join the tracks table.	$.event
name	string	The event name.	$.name
received_at	datetime	When Syft received the track call.	$.receivedAt
sent_at	datetime	When a user triggered the track call. This timestamp can also be affected by device clock skew	$.sentAt
timestamp	datetime	The UTC-converted timestamp which is set by the Syft library	$.timestamp
properties	object	JSON representation of the properties for the event.	$.properties
context	object	JSON representation of the context	$.context