Connect Sendinblue to Snowflake in 2023

sendinblue
+
snowflake

Stream all your data from Sendinblue to Snowflake

Connect Sendinblue to Snowflake in 2023

It is very simple to connect Sendinblue to Snowflake, it can be done in a fast and easy manner with Windsor.ai.

 

First Step

Follow the Tutorial Below:

  1. Add all the columns that are returned by your connector’s URL. Snowflake Integration 1
  2. Create the WINDSOR_UPLOAD role (name has no importance) Snowflake Integration 2
  3. Create a user and add the previously created role to that user Snowflake Integration 3
  4. Grant rights to the DATABASE to the created user Snowflake Integration 4
  5. Grand the rights to the destination table Snowflake Integration 5
  6. Get the required fields from Snowflake to use the Snowflake destination in Onboard Form

 

  • Get the username Import Snowflake 1

 

  • Get the password Import Snowflake 2

 

  • Get the account Import Snowflake 3

 

  • Get the warehouse Import Snowflake 4

 

  • Get the database Import Snowflake 5

 

  • Get the schema Import Snowflake 6

 

  • Get the table name Import Snowflake 7

 

Second step

1.You need to select Sendinblue as a Data Source and Grant Access to Windsor.ai.

Windsor.ai SendinBlue Onboarding Screen

 

2. In Select Destination select Snowflake as destination

snowflake integration

 

3. Enter all the credentials required and click Save
Snowflake connector

 

4. Your data will now be streamed from Sendinblue to Snowflake. In case there is an error you will be notified.

Sendinblue metrics and dimensions available for streaming into Snowflake

Connect your data

 

nametypedescription
A/B testingBOOLEANStatus of A/B Test for the campaign. abTesting = false means it is disabled, & abTesting = true means it is enabled
CampaignTEXTName of the campaign
Number of total clicksNUMERICNumber of total clicks for the campaign
Number of complaintsNUMERICNumber of complaints (Spam reports) for the campaign
Contact Created AtDATECreation UTC date-time of the contact
Contact IDTEXTID of the contact
Contact List IDsTEXTArray of contact list ids
Contact Modified AtDATELast modification UTC date-time of the contact
Created atDATECreation UTC date-time of the campaign
DateDATEThe Date
Number of deferred emails for the campaignNUMERICNumber of deferred emails
Number of delivered emailsNUMERICNumber of delivered emails for the campaign
EmailTEXTEmail address of the contact for which you requested the details
Blacklist status for Email.BOOLEANBlacklist status for email campaigns (true=blacklisted, false=not blacklisted)
Rate of recipients without privacy protection (all emails)NUMERICRate of recipients without any privacy protection option enabled in their email client, applied to all delivered emails
FirstnameTEXTFirstname
Folder IDTEXTID of the folder
TEXTFooter of the campaign
Number of harbounceNUMERICNumber of harbounce for the campaign
TEXTHeader of the campaign
Inline image activationBOOLEANStatus of inline image. inlineImageActivation = false means image can’t be embedded, & inlineImageActivation = true means image can be embedded, in the email
LastnameTEXTLastname
List Created atDATECreation UTC date-time of the list
List IDTEXTThe unique ID of the recipient list
List NameTEXTThe unique nmae of the recipient list
Mirror activeBOOLEANStatus of mirror links in campaign. mirrorActive = false means mirror links are deactivated, & mirrorActive = true means mirror links are activated, in the campaign
Modified atDATEUTC date-time of last modification of the campaign
NameTEXTName of the campaign
RecurringBOOLEANType of trigger campaign.recurring = false means contact can receive the same Trigger campaign only once, & recurring = true means contact can receive the same Trigger campaign several times
Reply toTEXTEmail defined as the "Reply to" of the campaign
Total number of non-delivered campaignsNUMERICTotal number of non-delivered campaigns for a particular campaign id
Scheduled atDATEUTC date-time on which campaign is scheduled
Send at best timeBOOLEANIt is true if you have chosen to send your campaign at best time, otherwise it is false
sender_emailTEXT
Sender idNUMERIC
sender_nameTEXT
Number of sent emailsNUMERICNumber of sent emails for the campaign
Sent dateDATESent UTC date-time of the campaign. Only available if 'status' of the campaign is 'sent'
TEXTLink to share the campaign on social medias
SMSTEXTSMS
Blacklist status for SMS.BOOLEANBlacklist status for SMS campaigns (true=blacklisted, false=not blacklisted)
Number of softbounceNUMERICNumber of softbounce for the campaign
Split ruleNUMERICThe size of your ab-test groups. Only available if `abTesting` flag of the campaign is `true`
StatusTEXTStatus of the campaign
SubjectTEXTSubject of the campaign. Only available if `abTesting` flag of the campaign is `false`
Subject ATEXTSubject A of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`
subject BTEXTSubject B of the ab-test campaign. Only available if `abTesting` flag of the campaign is `true`
TagTEXTTag of the campaign
Test sentBOOLEANRetrieved the status of test email sending
To fieldTEXTCustomisation of the "to" field of the campaign
Total BlacklistedNUMERICNumber of total blacklisted
Total SubscribersNUMERICNumber of total subscribers
Recipients without privacy protectionNUMERICRecipients without any privacy protection option enabled in their email client
Rate of recipients without privacy protectionNUMERICRate of recipients without any privacy protection option enabled in their email client
Transactional Email Event DateDATEUTC date-time on which the event has been generated
Transactional Email Event EmailTEXTEmail address which generates the event
Transactional Email EventTEXTEvent which occurred
Transactional Email Event Template FromTEXTSender email from which the emails are sent
Transactional Email Event IPTEXTIP from which the user has opened the email or clicked on the link (only available if the event is opened or clicks)
TEXTIP from which the user has opened the email or clicked on the link (only available if the event is opened or clicks)
Transactional Email Event Message IDTEXTMessage ID which generated the event
Transactional Email Event ReasonTEXTReason of bounce (only available if the event is hardbounce or softbounce)
Transactional Email Event SubjectTEXTSubject of the event
Transactional Email Event TagTEXTTag of the email which generated the event
Transactional Email Event Template IDTEXTID of the template (only available if the email is template based)
Transactional Email Report BlockedNUMERICNumber of blocked emails for the date
Transactional Email Report ClicksNUMERICNumber of clicks for the date
Transactional Email Report DateDATEDate of the statistics
Transactional Email Report DeliveredNUMERICNumber of delivered emails for the date
Transactional Email Report Hard BouncesNUMERICNumber of hardbounces for the date
Transactional Email Report InvalidNUMERICNumber of invalid emails for the date
Transactional Email Report OpensNUMERICNumber of openings for the date
Transactional Email Report RequestsNUMERICNumber of requests for the date
Transactional Email Report Soft BouncesNUMERICNumber of softbounces for the date
Transactional Email Report Spam ReportsNUMERICNumber of complaints (spam reports) for the date
Transactional Email Report Unique ClicksNUMERICNumber of unique clicks for the date
Transactional Email Report Unique OpensNUMERICNumber of unique openings for the date
Transactional Email Report UnsubscribedNUMERICNumber of unsubscribed emails for the date
TypeTEXTType of campaign
Number of unique clicksNUMERICNumber of unique clicks for the campaign
Unique SubscribersNUMERICNumber of unique subscribers
Number of unique openings for the campaignNUMERICNumber of unique openings
Number of unsubscriptionNUMERICNumber of unsubscription for the campaign
Number of openingsNUMERICNumber of openings for the campaign
Winner criteriaTEXTCriteria for the winning version. Only available if `abTesting` flag of the campaign is `true`

Easily connect Sendinblue to Snowflake

See the value and return on every marketing touchpoint

data warehouse

Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.

insights

Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.

Build your Sendinblue and Snowflake Integrations