Our new datasources page

Managing your database connections just got easier
Andreas MartinsonAndreas Martinson·Nov 24, 2024

Screenshot of the datasources page

Screenshot of the datasources page

We just created a new datasources page! It was included in the ‘Company’ page before, but it now has its own page to support the increased number of options.

TLdr

Here is the video for those of you who want to watch our release update.

Release Feature Overview

In the prior release, we added database metadata editing, which was really important to give the AI the appropriate context. With this release, we improved database management. We added some really important new features that increases the usability of the product:

  • Support templated schemas that may be created using Jinja workflows (think dbt)
  • Added options to bulk add connections (each connection is a database user role with its own permissions and login credentials)
  • Added the ability to bulk edit permissions for teams and how many teams have access to a given connection

Templated Schemas (aka ‘Jinjafied’ Schemas)

We call each user role that is created for a database ‘connections’. One of the important considerations is that connections can have access to different schemas, but these different schemas are based on the exact same database tables. This is more common with SQL workflows powered by dbt or using some variant where Jinja and SQL are combined.

We’re proud that we have the option to support schemas that have this setup. In order to set up templated schemas, add a database on the database page.

Initial connection details

Initial connection details

You can see here, that I added a templated schema, with the key for the templated schema listed as ‘db_type’. This creates an input box down below to fill in the value for that particular connection.

Bottom of the modal from the prior screenshot

Bottom of the modal from the prior screenshot

For this one we will put, ‘demo’. So the full schema name will resolve to ‘hr_demo_db’.

Then whenever a new connection is added, it will also prompt you for the jinjafied schema. Adding a new connection now looks like this:

What adding a new connection would look like

What adding a new connection would look like

Bulk Add Connections

You will see a tally by the database name with the connection count.

Screenshot showing button to manage connections

Once this is clicked you can bulk import connections.

Screenshot of bulk importing connections

This is really important for those who may have many different user roles all with different schemas. Instead of inputting them manually, you can upload the connections using a CSV.

Bulk Manage Team Access

We also made it easier to change which teams have access to which connection.

Screenshot showing how to manage team access to a connection

Using the checkboxes, you can easily provision or de-provision access to database connections.

Screenshot showing managing team connections

Conclusion

We’re really happy with this release and wanted to share our progress. Our product is still in beta, but we’re making large strides to improving usability and accuracy for building our AI data agent.

If you and someone you know is interested in trying out AI for data analytics, book a demo here: https://basejump.ai/demo

We would love to show you how our product can help your data team and business users. Also follow us on our social platforms as well to stay updated:

Thanks!

-Basejump AI Team

Want product news and updates?

Join Our Email List

We care about your data. Read our privacy policy.

Follow Us