Connect to a Database Tool to Run Ad Hoc Queries

Create an Immuta user SQL account

The query engine must be enabled in your tenant to create a user SQL account. Contact your Immuta representative for details.

1. Navigate to your Profile page.

2. Click the , and then Create Account.

3. Fill out the required fields following these guidelines:

   • Usernames must be unique and can only consist of lowercase letters, numbers, and underscores ( _ ).

   • Usernames cannot start with a number and can be no longer than 63 characters.

   • Passwords should not contain braces ( { ).

   Your SQL password will never be displayed in the Immuta console, so be sure to store it in a secure location.

4. Click Create.

These are the credentials you will use for authentication when you connect your database tool to Immuta to query data sources.

Connect database tool

1. Connect your database tool (for example, DBeaver) to Immuta’s PostgreSQL tenant using the credentials you created in the previous section. For a list of database tools PostgreSQL supports, see the PostgreSQL Clients page.

2. Query data sources registered from any of the following data platforms in your database tool:

   • Apache Impala

   • Netezza

   • Oracle

   • PostgreSQL

   • Teradata