Overview

EasyConnect moves data from your sources and seamlessly puts it into your Snowflake account at an affordable cost. That's it. We strive to be simple and solve a costly part of the data platform in Snowflake.

Setup

1. Download/install the native app from Snowflake Marketplace.
2. Select a connector.
3. Enter your credentials.
4. EasyConnect handles the rest and transfers your data into your Snowflake account.

Snowflake Resources

• Warehouse: Used for compute during the loading and querying of data.
• Compute Pool: This is used to run the application.
• Stage: Some sources are file-based. The stage is only used when needed.
• External Access Integration: Allows your Snowflake account to communicate with an external source.

Cost

• Warehouse (Extra Small): 1 credit per hour. Depends on how much you load and how often.
• Compute Pool (CPU_X64_XS): 0.06 credits per hour. Monthly, this amounts to 43 credits.

Loading Data

Loading data is mostly handled for users once the source is added. If you want to track the progress of loading, you can do so in the "Load Tables Task" that comes with each schema/source.

Security

Security is primarily handled by Snowflake and the Native App framework. For every version of EasyConnect, Snowflake performs a security review of the codebase in the application. If you would like to add a new role, refer to the "Adding a New Role" guide.

Networking

Networking is managed using the Snowflake native application configuration page or by manually modifying the network policy using the security page in Snowflake. If you would like to modify the network rules of the app, refer to the "Modify the Network Rules" guide.

Whitelisting

The EasyConnect native app uses the Snowflake account it runs on. If your source allows you to whitelist a DNS/URL, you will want to whitelist the account URL.

Static IP Whitelist

Currently, Snowflake does not offer a way for the app or account to have a static IP. There are workarounds, but none that are simple or long-lasting. If this changes, we will update this section and notify our users.

Limitations

• Currently there is only one role in the app that controls everything.

Guides

Useful guides can be found in this section.

Adding a New Role

To add a new role to the app for accessing data and the app, go to the application overview page in Snowflake and click "Manage Access".

Add the role you want using the dropdown menu.

Modify the Network Rules

To modify the network policy for the application, go to the security page in the main navigation bar.

You can either remove URLs from the list or add new ones by typing in the URL and pressing enter to add it. The network is only modified when you click "Update Network Rule".

Tracking Loading

Loading can be tracked by using the task that is created when you start any connector.

Alerting (Verify Email)

To endable alerting in Snowflake it is required that your email is verified. To verify:

Select profile.

Click verify email in your profile.

Go to the email you entered and click the verification link. Once finished you can rerun the notification integration.