Connecting your Snowflake database to Catchr allows you to automatically populate the table with data extracted from your Catchr Source.
Here is how to connect your database in 2 simple steps:
Go to app.catchr.io and log in using your Google account.
In the left-hand menu, click on Database.
Click + Add database at the top right of the page.
Name your database. This is the name that will be visible on Catchr. We recommend naming it so you can find it easily, for example, 'Snowflake DB'.
In Destination, select the database type, and here choose Snowflake.
Enter your Host. You will find it in your Database Management System. You can add the port at the end like this: your-db-host.com:3307
Enter your Username and Password (we advise creating a user for Catchr).
Enter the name of the Database to use (it must exist in your Snowflake).
Click Save
You just linked your MySQL database to Catchr !
To learn how to create a Datastream and a Job to populate this database, check this article.