Zepl Data Sources

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.

Creating a Data Source

There are 3 easy ways to create Data Sources in Zepl:

  1. Home page: Add New > Add Data Source

  2. Data Source: Resources > Data Sources > Select a data source type

  3. Notebook: Select the Data icon > Add new > Select a Data source type

For more detail on how to complete the data source inputs for a specific data source type, proceed to the corresponding data source type documentation page.

Attaching a Data Source

  1. Navigate to your notebook and select the Data Source icon:

  2. Locate your data source toward the bottom of the screen and Select the "+" icon by your data source:

  3. Select the settings button to make sure you have your credentials entered before running the notebook

Attaching data sources MUST be done while the notebook container is Stopped. Please stop your container before attaching any data sources.

Use Data Source

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.

The String "<Data Source Name>" that is passed into this function, is case sensitive and must match the name exactly of your data source exactly.

Data Source Security

Securely store credentials

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.

Credential Types

  1. 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.

  2. 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.

Managing Data Source Connections

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.

Editing data source records