With the Snowflake integration, you choose to upload your zero-party data collected through Jebbit experiences either to a Jebbit-hosted SFTP or your own SFTP server. From there, the files can be transferred to an external stage in Snowflake, allowing you to analyze and activate customer data at scale. This integration is key for enabling advanced segmentation, personalized marketing, and robust reporting capabilities.
Before you begin
Access to a Snowflake account with permissions to create external stages and load data.
An SFTP client (e.g., FileZilla, WinSCP, or Cyberduck).
The ability to generate SSH key pairs (public and private).
A designated SFTP destination, either Jebbit’s SFTP server or your own.
Create a Snowflake integration
Download an SFTP Client
Install an SFTP client such as FileZilla, WinSCP, or Cyberduck to facilitate secure file transfers.
Generate SSH Key Pair
Instead of using a username/password combination, you'll authenticate via SSH keys
Use a tool like PuTTYgen to create a public/private SSH key pair.
Share the public key with Jebbit by uploading it through the provided Dropbox link.
Connect to the SFTP Host
Once you have obtained the SFTP client and configured your SSH keys, connect to the SFTP host. The SFTP host URL for Jebbit is sftp.jebbit.io, or provide a different destination URL.Host: sftp.us.jebbit.io
Establish an SFTP connection with Jebbit
Use any SFTP client software, such as FileZilla, WinSCP, or Cyberduck, and enter the provided credentials.
Establishing an SFTP connection is essential to securely transfer files between your system and Jebbit's servers. The above credentials are necessary for authenticating your connection and ensuring the confidentiality and integrity of your data.
Retrieve Data from Jebbit via SFTP
After connecting, navigate to your designated directory on Jebbit's server to access and download the required files.
Upload Files to Snowflake
With the files retrieved:
Upload them to an external stage in Snowflake.
Refer to Snowflake's documentation or consult with your Snowflake administrator for detailed instructions on these steps.
Next steps
Validate that data is correctly ingested into Snowflake.