Your connection details will be encrypted in KAWA’s database and will be decrypted only to import data from your bases when an ETL runs (Manual trigger on the GUI or according to your schedule). It is NOT accessible to KAWA support team.
1. Configure the provider on KAWA
In the data source section:
- Click on “+” button and choose: “Connect to an external system”
- Then, click on “+ Connector ” button next to the data import section
- Pick the Snowflake provider
- Enter the required connection details for your Snow Flake account:
- Host: The host is formed as follows:
<account_identifier>.snowflakecomputing.comYour url can be found on your snowflake account page:
- Port: The port is always 443
- Database: The database you want to connect to
- Username/Password: Your credentials
- URL param: can be left empty.
- Please keep USE SSL and USE KERBEROS turned off.
- You can turn on “Data Provider is restricted” If you want only privileged users to access this data provider.
Here is how a valid configuration looks like:
Click on Test Connection then Create.