DbSchema for Amazon Athena Database

How to Connect to Your Database

DbSchema is a powerful database management and design tool for Amazon Athena. With DbSchema, you can visually design your schema, collaborate with your team using Git, deploy schema changes, and even generate interactive HTML documentation for your database.

Explore all the powerful features DbSchema provides for Amazon Athena:

Our Highlights
Explore Important Features

Connect to Your Database & Reverse Engineer the Schema

Start a new model by reverse-engineering the schema from the database. The model contains a database-independent image of the schema.
Documentation

  1. 1
    Connect to your Database
    Using JDBC driver you can connect to any database and reverse engineer the schema.
  2. 2
    Connect to Cloud Databases

    In the cloud database console, you will find the JDBC URL. In DbSchema tick the 'I know the JDBC URL' checkbox and copy the URL.

  1. 3
    Automatic JDBC Driver Download

    Choosing a database DbSchema will automatically download the JDBC driver from the driver repository. This requires Internet connectivity.

  2. 4
    SSH Connections

    Work on your database through secured connections.

Connect to Amazon Athena

Troubleshoot Firewall Issues

If you encounter connection issues, it may be due to firewall settings. Read how to enable Firewall Connections.

Double-check your AWS credentials, IAM policies, and permissions to ensure you have access to Athena.

Remember to enable Windows Firewalls Firewalls & anti-viruses may block database connections.