Manage your Data connections
In this guide, you’ll learn how to manage your Fresha Data connections by updating details, adding public keys, resetting passwords, monitoring activity, and disabling or deleting connections.
In this article
View data connection details
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- From the connections list, find the connection you want to view and click on the Actions button and then select View details.
- Your database details will be displayed, including:
- Database type = Snowflake
- Account URL (sometimes called 'Account name')
- Username
- Warehouse name
- Database name
- Schema
- Password
- Public key
Add or update a public key
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- In the connections list, locate the connection you want to add or update a public key for, and click on Add public key.
- From your database details, go to Public key and select from the following:
- Add key: Upload a new public key.
Update key: Replace the existing public key with a new one.
- Add key: Upload a new public key.
- In the pop-up, enter your unique public key and click on the Save button to apply this to your database details.
Reset password for your Data connector
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- In the connections list, locate the connection you want to reset the password for, click on the Actions button and then select Reset password.
- In the pop-up, select Generate new password to reset your password.
- Once your password has been reset, click on the copy icon to save your new password, and store it somewhere secure.
- Select the 'X' button to close the pop-up.
Once you reset your password, your existing connections will require the new credentials, as your previous password will no longer be valid.
View Data connector usage
The Data connector add-on includes a fair-use limit of up to 8 hours of daily usage across all connections.
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- In the toolbar on the right of your screen, click on Database usage to view your data connector’s database usage.
- Your database usage will appear in a pop-up in the top right of your screen.
View connection activity logs
Activity logs display who is using a connection, how often it’s accessed, and which tools are being used.
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- In the connections list, locate the connection you want to view activity for, click on the Actions button and then select View activity.
- Your database activity log will be displayed, separated into Login activity and Queries. To close the activity log, select the Close button in the top right of your screen.
Disable a data connection
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- In the connections list, locate the connection you want to disable, click on the Actions button and then select Disable.
- Your connection will be disabled immediately and will appear as 'Inactive'.
Once your data connection is disabled, no new Fresha data will be transferred.
Re-enable a data connection
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- In the connections list, locate the inactive connection that you would like to enable, click on the Actions button and then select Enable.
Once your data connection has been enabled, data from that point forward will be transferred.
Delete a connection
- From the main menu on the left of your screen, go to Reports.
- In the left menu panel, select Data connector to manage your data connections.
- In the connections list, locate the connection that you want to delete, click on the Actions button and then select Delete.
- In the pop-up, click on the Delete button to save your changes.
Once your connection is deleted, it will be removed from your Data connection list and will no longer have access to connected tools.
FAQs
Data is automatically refreshed about every 30 minutes, similar to Fresha's reporting feature. This ensures your database stays up to date with the latest information.
Fresha's Data connector has a fair use policy of up to 8 hours of usage per day across all connections. Using multiple connections at the same time doesn’t increase the usage rate. After 8 hours, queries will be temporarily restrained, and usage will reset the following day. To optimize performance, avoid excessive query frequency and batch requests where possible.
Fresha does not store passwords for data connections to ensure the security of your business data. If you lose your password, you can easily generate a new one by resetting it.
If you cancel your Data connector add-on, your connections will remain active until the end of your billing period, after which they will be disabled. If you resubscribe within two months, your connections will still be available, but after two months they will be permanently deleted.
A public key provides an extra layer of security for your connection, it's an optional step when setting up a data connection in your Fresha account. If your system requires secure SSH authentication, you can upload a public key to protect your data. This ensures that only authorized users can access your connection, keeping it safe from unauthorized use.