To set up a Jebbit Snowflake integration you either choose to upload the data either to a Jebbit SFTP or your own SFTP, so we can send the data into Snowflake. From there, you can upload the files from the SFTP server to the external stage in Snowflake.
Setting up a Snowflake Integration
1. Download SFTP Client
To communicate with the SFTP server, download an SFTP client such as FileZilla.
2. Create SSH Keys (Public & Private Keys)
Instead of a username/password combination, you will need to connect to Jebbit via the use of a private key generated, using tools like Puttygen.
Once you have generated the keys, share them using this Dropbox URL.
3. 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.
4. Establishing an SFTP connection with Jebbit
Use any SFTP client software, such as FileZilla, WinSCP, or Cyberduck, and enter the provided credentials.
SFTP Details:
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.
5. Retrieve your data from Jebbit via SFTP
After establishing the SFTP connection, access your designated directory on Jebbit's server and retrieve the requested files.
6. Upload the files from the SFTP server to Snowflake
After establishing the SFTP connection, you can initiate data transfer to Snowflake. Subsequently, you'll have to upload files from the SFTP server to the external stage in Snowflake. For this step, it's advisable to refer to Snowflake documentation or collaborate with a Snowflake developer.