Zepl Data Sources enable secure and reusable data connections to any database or data warehouse. Users authenticate to an underlying datastore by entering their credentials in our secure keychain. This ensures that users never expose their credentials in plain text within a notebook or script again! Finally, this approach is simple and secure since all data governance and authorization is handled by the underlying datastore.
Zepl has a number of prebuilt Data Sources and is constantly enabling more. In this section, we will discuss how to configure and how to use each Data Source.
There are 3 easy ways to create Data Sources in Zepl:
Home page: Add New > Add Data Source
Data Source: Resources > Data Sources > Select a data source type
Notebook: Select the Data icon > Add new > Select a Data source type
Navigate to your notebook and select the Data Source icon:
Locate your data source toward the bottom of the screen and Select the "+" icon by your data source:
Select the settings button to make sure you have your credentials entered before running the notebook
After attaching a data source to a given notebook, you will need to make a connection to the data source by using this function:
z.getDatasource("<Data Source Name>") .
This function is intended to securely reference the data source user credentials and greatly reduces the number of lines of code required to perform routine tasks, like connecting to your team's data warehouses. The return value for this function changes for each language and data source type, so please reference the documentation for your specific data source.
Zepl encrypts all sensitive inputs, such as passwords, user secrets and keys, when entered into a data source. This ensures that notebooks can be shared easily with multiple users without exposing sensitive information in the notebook code.
Private: Private credential types require every user to enter their own credential for that data source. This is the most secure practice for data warehouse or databases that support role based access control.
Shared: Shared credential types require only one user (the user creating the data source) to add their credential. This method of access supports a data warehouse or database with service account access. Think, one account for many to access.
Data sources for an organization can be managed under the Resources section of the product. You can see all data sources created for an organization, and see if you need to add your credentials to that data source in order to use it.
To alter any data source settings, click on the data source name, edit any fields, test your connection to see if the changes you made were successful, and click save to update the data source. You can also remove a data source through this edit screen as well. Before doing so, it's wise to check if any notebooks or other users are relying on this data source by seeing what it is connected to.