Skip to main content
Snowflake Integration
Updated over 2 months ago

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:

Username: Client_SFTP

Key file: Private SSH Key

Port: 22

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.

Did this answer your question?