Overview

This documentation outlines the process of configuring and using AWS Athena with DBeaver.

To manage databases using AWS Athena in DBeaver, establishing a connection is essential. This is done by selecting the

option in the database connection settings of DBeaver. For those new to this process, our Creating a Connection article provides detailed guidance.

Athena specialty

AWS Athena, as an analytical database service, has limitations compared to traditional relational databases. It does not support real-time data changes, such as adding or updating data. Also, Athena cannot modify data using

or commands. It lacks constraint enforcement like primary keys and foreign keys. For more detailed information, refer to the AWS Athena database documentation.

Important: In DBeaver, AWS Athena is read-only.

For a detailed overview of the supported features and capabilities of AWS Athena within DBeaver, please see the section on Powering Athena with DBeaver.

Setting up

This section provides an overview of DBeaver’s settings for establishing a direct connection and the configuration of secure connections using SSH, Proxies, and Kubernetes.

Athena connection settings

In this subsection, we will outline the settings for establishing a direct connection to a Athena database using DBeaver. Correctly configuring your connection ensures seamless interaction between DBeaver and your Athena database.

The page of the connection settings requires you to fill in specific fields to establish the initial connection.

Field	Description
Region	Specify the AWS region where your Athena database is located, such as us-west-1 . This should match the region of the S3 bucket used for storing query results.
S3 location	Enter the output location for query results in the format s3://aws-athena-query-results-[your-account-id]-[region]/ . Replace [your-account-id] with your actual AWS account ID and [region] with the region code, for example, s3://aws-athena-query-results-80980980-us-east-1/ . Ensure you have the necessary permissions set for this S3 location.
Browse	Click to open a dialog that allows you to navigate and select an S3 bucket through DBeaver’s interface.
Show catalogs	Check this option if you want to view the data catalog in the DBeaver connection. This will show the databases and tables defined in Athena’s data catalog.
Authentication	Choose the type of authentication you want to use for the connection. For detailed guides on authentication types, please refer to the following articles: – Database native – AWS IAM – DBeaver Profile You can also read about security in DBeaver PRO.
Connection Details	Provide additional connection details if necessary.
Driver Name	This field will be auto-filled based on your selected driver type.
Driver Settings	If there are any specific driver settings, configure them here. For detailed guide on driver properties please refer to the official AWS Athena documentation.

Connection details

The Connection Details section in DBeaver allows for further customization of your Athena connection. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:

• Connection Details Configuration
• Database Navigator
• Security Settings Guide
• Filters Settings Guide
• Connection Initialization Settings Guide

• Shell Commands Guide

Secure connection configurations

DBeaver supports secure connections to your Athena database. Guidance on configuring such connections, specifically SSH, Proxy, Kubernetes, AWS SSM and SSL connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:

• SSH Configuration

• Proxy Configuration

• SSL Configuration

• Kubernetes Configuration

• AWS SSM

Powering Athena with DBeaver

DBeaver provides a host of features designed for Athena databases. This includes the ability to view schemas, along with numerous unique capabilities aimed at optimizing database operations.

Athena database objects

DBeaver lets you view a range of Athena database objects, such as:

• Schemas

  • Tables
    • Columns
  • Views
    • Columns
  • Procedures

Athena additional features in DBeaver

DBeaver provides additional features compatible with Athena, but not exclusive to it:

Category	Feature
Data Transfer	Data Export
Schema Management	Schema Compare

Overview

This section provides guidance on configuring and using AWS Redshift with DBeaver.

AWS Redshift is a fully managed data warehouse service known for its high performance and scalability in handling large datasets. An important aspect of Redshift is that it is based on open standard PostgreSQL, which means it shares numerous settings and capabilities similar to PostgreSQL databases. For detailed information about AWS Redshift’s features, visit the AWS Redshift documentation.

To manage databases using AWS Redshift in DBeaver, select the

option in the database connection settings of DBeaver. Our Creating a Connection article offers comprehensive instructions for those new to this process.

Redshift specialty

AWS Redshift is an optimized database service designed for large-scale data warehousing and analytics, supporting a wide array of SQL operations. Its foundation in PostgreSQL, through a modified version tailored for its query processing, allows Redshift to support many of the standard SQL features of PostgreSQL. In addition to its PostgreSQL roots, a key feature of AWS Redshift is its columnar data storage. This approach to data storage is particularly efficient for analytics, as it allows for faster retrieval of specific columns, optimizing the performance for query-heavy workloads typically associated with data warehousing. However, it is important to note that AWS Redshift does not fully support referential integrity constraints, such as foreign keys. For more detailed information, refer to the AWS Redshift database documentation.

For a detailed overview of the supported features and capabilities of AWS Redshift within DBeaver, please see the section on Powering Redshift with DBeaver.

Setting up

This section provides an overview of DBeaver’s settings for establishing a direct connection and the configuration of secure connections using SSH, SSL, Proxies, Kubernetes, and the setup of ODBC/JDBC drivers for Redshift.

Redshift connection settings

In this subsection, we will outline the settings for establishing a direct connection to a Redshift database using DBeaver. Correctly configuring your connection ensures seamless interaction between DBeaver and your Redshift database.

1) The first page of the connection settings requires you to fill in specific fields to establish the initial connection.

Field	Description
Connect by (Host/URL)	Choose whether you want to connect using a host or a URL.
Driver Type	Select the appropriate driver for your Redshift database.
URL	If you are connecting via URL, enter the URL of your Redshift database here. This field is hidden if you are connecting via the host.
Host/Instance	If you are connecting via host or instance, enter the address of your AWS Redshift database here.
Database	Enter the name of the Redshift database you want to connect to.
Show all databases	Displays all databases in the database navigator. Note: This option works only when the Host connection type is selected. It does not work when connecting via URL.
Connection Details	Provide additional connection details if necessary.
Driver Name	This field will be auto-filled based on your selected driver type.
Driver Settings	If there are any specific driver settings, configure them here.

2) The second page of the connection settings offers additional options that allow you to customize your further connection to the Redshift database.

Field	Description
Show template databases	Displays template databases. This option is available when Show all databases is checked.
Show databases not available for connection	Show databases not available for connection in database list. This option is available when Show all databases is checked.
Show databases statistics	Displays statistics for databases.
Read all data types	Reads all data types from the server (including arrays).
Read table keys with columns	Enable reading table constraints during the column reading stage to ensure accurate recognition of keys. Note that this setting may decrease metadata loading performance.
Show $$ quote as	Displays $$ quotes as code blocks or strings.
Show $tagName$ quote as	Displays $tagName$ quotes as code blocks or strings.

Connection details

The Connection Details section in DBeaver allows for further customization of your Redshift connection. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:

• Connection Details Configuration
• Database Navigator
• Security Settings Guide
• Filters Settings Guide
• Connection Initialization Settings Guide

• Shell Commands Guide

Redshift driver properties

The settings for Redshift Driver properties enable you to adjust the performance of the Redshift JDBC and ODBC driver. These adjustments can influence the efficiency, compatibility, and features of your Redshift database.

For a complete walkthrough on setting up Redshift JDBC and ODBC drivers properties, you can refer to the official AWS Redshift JDBC documentation and AWS Redshift ODBC documentation. These guides detail each driver’s properties and how they can be used to optimize Redshift database connections.

You can customize the Redshift driver in DBeaver via the Edit Driver page, accessible by clicking on the Driver Settings button on the first page of the driver settings. This page offers a range of settings that can influence your Redshift database connections. For a comprehensive guide on these settings, please refer to our Database drivers article.

Secure Connection Configurations

DBeaver supports secure connections to your Redshift database. Guidance on configuring such connections, specifically SSH, Proxy, Kubernetes, AWS SSM and SSL connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:

• SSH Configuration

• Proxy Configuration

• SSL Configuration

• Kubernetes Configuration

• AWS SSM

Powering Redshift with DBeaver

DBeaver provides a host of features designed for Redshift databases. This includes the ability to view schemas, along with numerous unique capabilities aimed at optimizing database operations.

Redshift database objects

DBeaver lets you view and manipulate a wide range of Redshift database objects. DBeaver has extensive support for various Redshift metadata types, allowing you to interact with a wide variety of database objects, such as:

• Databases
  • Schemas
    • Tables
      • Columns
      • Constraints
      • Foreign Keys
      • Dependencies
      • References
    • Views
    • Functions
    • Data types
    • Aggregate functions
  • Users
  • Groups
  • Roles
• Administer
  • Jobs
  • Session Manager

• Datashares

  • Objects
  • Consumers

Redshift additional features in DBeaver

DBeaver provides additional features compatible with Redshift, but not exclusive to it:

Category	Feature
Data Transfer	Data Import
	Data Export
Data Visualization	ERD Guide
	Query Execution plan
Session Management	Session Manager
Schema Management	Schema Compare
Data Generation	Mock Data Generation

Note: This driver is available in Lite, Enterprise, Ultimate and Team editions only.

Overview

This documentation outlines the process of configuring and using AWS Timestream with DBeaver. For more information, visit the official AWS Timestream website.

To manage databases using AWS Timestream in DBeaver, establishing a connection is essential. This is done by selecting the

option in the database connection settings of DBeaver. For those new to this process, our Creating a Connection article provides detailed guidance.

Timestream specialty

AWS Timestream, while optimized for time-series data, lacks some features common in traditional relational databases. It does not have features like constraints, foreign keys, triggers, views, or complex joins, and sub-queries limit DBeaver’s capabilities when working with Timestream. For more detailed information, refer to the AWS Timestream database documentation. Due to the absence of certain features in AWS Timestream, there is an inability to link tables, automate tasks based on database changes, create virtual tables from queries, or conduct an in-depth analysis of how data is related within Timestream. For more detailed information, refer to the AWS Timestream database documentation.

Important: In DBeaver, AWS Timestream is read-only.

For a detailed overview of the supported features and capabilities of AWS Timestream within DBeaver, please see the section on Powering Timestream with DBeaver.

Setting up

This section provides an overview of DBeaver’s settings for establishing a direct connection and the configuration of secure connections using SSH, Proxies, and Kubernetes.

Timestream connection settings

This subsection will outline the settings for establishing a direct connection to a Timestream database using DBeaver. Correctly configuring your connection ensures seamless interaction between DBeaver and your Timestream database.

The connection settings page requires you to fill in specific fields to establish the initial connection.

Field	Description
Region	Specify the AWS region where your Timestream database is located, such as us-west-1 .
Authentication	Choose the type of authentication you want to use for the connection. For detailed guides on authentication types, please refer to the following articles: – AWS Timestream IAM – DBeaver Profile You can also read about security in DBeaver PRO.
Connection Details	Provide additional connection details if necessary.
Driver Name	This field will be auto-filled based on your selected driver type.
Driver Settings	If there are any specific driver settings, configure them here. For a detailed guide on driver properties, please refer to the official AWS Timestream documentation.

Connection details

The Connection Details section in DBeaver allows for further customization of your Timestream connection. This includes options for adjusting the Navigator View, setting up Security measures, applying Filters, configuring Connection Initialization settings, and setting up Shell Commands. Each of these settings can significantly impact your database operations and workflow. For detailed guides on these settings, please refer to the following articles:

• Connection Details Configuration
• Database Navigator
• Security Settings Guide
• Filters Settings Guide
• Connection Initialization Settings Guide

• Shell Commands Guide

Timestream driver properties

The settings for Timestream Driver properties enable you to adjust the performance of the Timestream JDBC driver.

For a complete walkthrough on setting up Timestream JDBC driver properties, you can refer to the official Timestream JDBC documentation. These guides detail each driver’s properties and how they can be used to optimize Timestream database connections.

You can customize the Timestream driver in DBeaver via the Edit Driver page, accessible by clicking on the Driver Settings button on the first page of the driver settings. This page offers a range of settings that can influence your Timestream database connections. For a comprehensive guide on these settings, please refer to our Database drivers article.

Secure connection configurations

DBeaver supports secure connections to your Timestream database. Guidance on configuring such connections, specifically SSH, Proxy, Kubernetes and AWS SSM connections, can be found in various referenced articles. For a comprehensive understanding, please refer to these articles:

• SSH Configuration

• Proxy Configuration

• Kubernetes Configuration

• AWS SSM

Powering Timestream with DBeaver

DBeaver provides a host of features designed for Timestream databases. This includes the ability to view schemas, along with numerous unique capabilities aimed at optimizing database operations.

Timestream database objects

DBeaver lets you view a few of the Timestream database objects, such as:

• Schemas

  • Tables
    • Columns

Timestream features in DBeaver

DBeaver provides the following features compatible with Timestream, but not exclusive to it:

• Data Export: Enables the exportation of data. See Data Export for more details.

• Graph Construction: Allows the building of detailed and informative graphs.

  

Please note: This article has been updated and its content is now available in a revised form at a new location. Please refer to the updated article Create Connection for the most current information.

Database Navigator is the main view to work with the structure and content of databases. To open Database Navigator, on the Windows menu, click Database Navigator. For information on how to change the view layout, please see the Application Window Overview article.

Database Navigator contains a tree of objects, a toolbar and View menu which contain generic items. Each object in the tree has its own context menu. The tree contains the following objects:

• Folders –
• Database connections – and other (icons differ depending on the database type)
• Database objects – various depending on the database type, such as Tables , Views , Columns , Indexes , etc.

To open the view menu of Database Navigator, click the View Menu button () in the upper-right corner of the window. For more information on where to find the view toolbar and menu, please see the Views article.

The menu contains the following items:

Icon	Menu item	Description
	Driver Manager	Opens the Driver Manager window that allows you to create, edit and delete drivers for databases. See Database Drivers for information about managing database drivers.
	New Connection	Opens the Create new connection wizard. See Create Connection for information about creating connections.
(empty)	Active Project	Displays a submenu which allows you to choose a project. See Projects and Projects view for information about projects.
	New Folder	Opens a dialog box for creating a new folder
	Collapse All	Collapses the tree to the root level
	Link with editor	Synchronizes the active editor with the element in the database navigator

The toolbar is located in the title bar of the window. Its buttons duplicate the menu items, except for the Active Project.

To open the context menu for an object, right-click the object in the tree. The following table summarizes the context menu items for all types of objects that may appear in the tree. Note that the presence or absence of the context menu items for an object depends on the database and object types.

Menu item	Description
Open folder	Opens a folder in a separate view
Create new connections / Create New Connection	Opens the Create new connection wizard
New Folder	Opens a dialog box for creating a new folder
Copy	Copies an object to the clipboard
Paste	Inserts the copied object into a selected folder – most convenient for copy-pasting connections
Delete	Deletes an object WARNING! The Delete menu item removes the object not only from the tree but from the database itself or the file system, and this action is irreversible.
Rename	Opens the Rename [object] dialog box
Properties	Opens the Properties for [object] window which allows viewing and modifying the object`s properties
Refresh	Depending on the object, refreshes the object itself, or its parent, or its subnodes – mostly used for refreshing tables and schemes
Connect	Attempts to connect to the database
Invalidate/Reconnect	Checks the status of connection, if it is broken, attempts to reconnect
Disconnect	Disconnects from the database
SQL Editor	Opens a new SQL editor for the connection
Recent SQL Editor	Opens the most recently opened SQL editor
Edit Connection	Opens the Connection Configuration window that allows configuring connection settings
Connection view	Adjusts the display of database objects, offering Simple, Advanced, or Custom views for tailored navigation.
View [objects]	Opens the object in a separate viewer
Edit [object]	Opens the object in a separate editor
Create new [object]	Opens an editor in which you can specify properties and save the new object
Filter	Opens a submenu of one or more filtering options (depending on the object): – Hide [object]– Show only [object]– Configure [objects] filter – Toggle filter – Clear filter See Filters for information.
Copy Advanced Info	Copies the full name of an object
Read Data in SQL Console	Opens an SQL console displaying the object`s data
Compare	– Appears only if you select several objects of the same level – Opens the Compare objects wizard which guides you through the steps to generate a comparison report for the selected objects
Generate SQL	Opens a submenu on which you can select the type of SQL query to generate: – SELECT – INSERT – UPDATE – DELETE – MERGE – DDL Clicking one of the items (for example INSERT) generates a relevant query in a separate window.
Export Table Data	Opens the Data Transfer wizard that helps you select a format and export table data
Import Table Data	Opens a window with existing database connections in which you can select a table to import data from
Tools	Opens a submenu that provides tools for database backup and restore, vacuum, etc.

For information on how to filter database objects in Database Navigator, please see the Filter Database Objects article.

While working in the SQL Editor, you can drag the desired object from the Database Navigator to the part of your query. Please pay attention to the selected object name. Running the query immediately with the selected object will cause an error because only the selected part of the script is being executed and fails as it’s not a complete query. An extra step to deselect it by clicking somewhere in the SQL Editor is required to remove the selection. Nevertheless, we cannot deselect the object name automatically after dragging. This action is needed when you drag and drop an object into a complex query or long script, and it would be difficult to track what and where exactly you’ve just dropped, and you can get an unexpected error.

The Database object, or metadata editor is available for multiple database objects such as tables, views and schemas. To open the metadata editor for an object, in the Database Navigator or in the Projects view:

• Double-click the database object
• Click the database object and press Enter or F4

Upon performing these steps, you will see a window where the tabs contain the following common parts:

Tabs

• The Properties tab, available for all objects, encompasses the properties of the database object as well as its sub-entities. For more information, please refer to the Properties Editor article.
• The Data tab appears for tables and views and represents the Data Editor.

• The ER Diagram tab appears for tables and schemas and displays ERD (Entity Relation Diagrams).

Database object path

The object’s path shows the chain of all its parent entities. The entities are clickable: clicking an entity in the path, depending on its nature, either shows its children or opens an editor or a settings window.

Content area and Toolbar

The Content Area and Toolbar are key parts of the Properties tab. The Content Area shows information about a database object and things like its sub-parts or DDL. The Toolbar has different tools on each tab to help with different tasks.

Overview

You can view a database structure in the standard ERD (Entity Relation Diagram) form. ER diagrams are available for all tables and schemas (databases).

The ER diagram for a table shows the table itself and its relations with other tables inside the schema. To view the ER diagram for a table or view, double-click the table or view in the Database Navigator and then, in the Database Object Editor, switch to the ER Diagram tab:

To view the ER diagram for a full database schema, double-click the schema name in the Database Navigator or the previous node in the path (usually – Tables):

NOTE: Table and schema diagrams are read-only. You can rearrange the layout, drag-n-drop elements inside a diagram but you cannot save the changes state or delete/add anything. This is because the diagrams represent the actual state of databases.

Relationship Notation

Lines representing the relationship between tables can look different depending on the nature of the relationship. Please note that any line can have only one beginning and one end. We may have links between two tables not only for one pair of attributes, which means that several associations will be displayed:

Notation	Description
	A solid line means that the foreign key column in one table is a primary key in another table
	A dashed line means that the foreign key column is not a primary key but a regular column in another table
	A black dot is used as the start of the line
	A diamond is used at the end of the link when the column in the source table is optional (there is no NOT NULL)

A one-to-one relationship is always a solid line due to the unique primary key – foreign key relationship:

A dashed line is for the one-to-many relationship:

DBeaver supports many different authentication models for different databases. The default authentication model is

– it needs a user name and password which are used to authenticate at the remote database server.

Some database drivers support other database-specific authentications.

PgPass

PostgreSQL specific model. Uses local file PGPASS to obtain user name and/or password.
It does not have any additional parameters.

Parameter	Description
Model ID	postgres_pgpass

Kerberos

Parameter	Description
Model ID	krb5, postgresql_krb5, prestodb_krb5, prestosql_krb5, oracle_krb5
krb5.realm	Kerberos realm/AD domain
krb5.kdc_server	KDC server IP/host name
krb5.user	Kerberos user name
krb5.use_keytab	Force keytab file usage (true/false)
krb5.keytab_path	Keytab file path
krb5.use_kinit	Force kinit utulity usage
krb5.kdc_over_tcp	Force TCP/IP protocol usage (UDP is used by default)

Oracle Wallet

Oracle Wallet authentication

Parameter	Description
Model ID	oracle_wallet
oracle.net.wallet_location	Wallet file location

Oracle OS auth

Oracle native OS authentication

Parameter	Description
Model ID	oracle_os

Oracle native database auth

Oracle native database authentication

Parameter	Description
Model ID	oracle_native

AWS IAM auth

AWS IAM authentication

Parameter	Description
Model ID	iam
iam.region	AWS region ID
iam.aws_access_key	AWS Access Key
iam.aws_secret_key	AWS Secret Key
iam.use_default_aws	Load access/secret key from local AWS configuration

Note: This feature is available in Enterprise, Ultimate and Team editions only.

Overview

DBeaver provides functionality to compare two tables or query results, which is useful when you need to identify minor differences in datasets that appear almost identical. This capability is essential for tasks such as:

• Quickly visualizing and navigating differences.

• Exporting data that differs between sources.

Steps for comparing data

First, select the tables you wish to compare from the Database Navigator.

Choose a comparison type

Select what you will compare by choosing the appropriate tab in the Source / Target windows.

• Tables: Compare two tables.

  

• Table to Query: Compare a table with the result of an SQL query.

  

• Queries: Compare the results of two SQL queries. When comparing the results of two SQL queries, you have two methods to perform this operation:

  • Use Source/Target Query tabs

    Select the Query tab in both the Source and Target windows. Enter your SQL queries directly into these fields to set up the comparison.

  • Use SQL Editor

    Alternatively, write your SQL queries in the SQL Editor. Highlight the queries and choose Execute -> Data Compare from query.

Tip: You can compare objects from the same or different databases, or even between different Relational Database Management Systems (RDBMS), such as PostgreSQL and MySQL.

Keys configuration

Select one or more columns that will serve as the unique key for the comparison. Choosing the wrong keys may result in invalid comparison results.

Note: By default, if the table has a unique key, it will be selected automatically during the initial setup. If the table doesn’t have a primary key, you can manually select one or more columns to define a unique key.

Composite keys

When you select multiple columns, they form a composite key. Composite keys uniquely identify rows based on a combination of values across the selected columns.

Tip: Select columns for composite keys that, together, uniquely identify each row. Avoid columns with duplicate or null values, as they may impact comparison accuracy.

Column mapping

If the objects you are comparing have different ordering, naming, or quantities of columns, you can adjust their mappings or skip columns that are not of interest.

You can use the Auto assign button to automatically link columns with the same names.

Note: This page will only feature columns that are not used as the primary key configured on the previous page.

Compare settings

On the final page of the Data Compare wizard, configure settings to tailor the data comparison to your needs:

Setting	Description
Open viewer on finish	Opens the compare viewer for a visual overview of the differences once the comparison is complete.
Export compare results to file	Exports the SQL script diff to a file. You can choose the output format and specify the output file path.
Limit compared rows to	Limits how many rows must be compared against each other before ending the comparison.
Limit different rows to	Limits how many rows must be differ between each other before ending the comparison.
Limit fetch size to	Determines how many rows should be fetched at once, which helps manage memory and performance during comparison.
Show modified rows	Determines whether modified rows should be included in the diff or not, allowing you to track changes in the data.
Show deleted rows	Determines whether deleted rows should be included in the diff or not, providing insight into data that has been removed from the database.
Show inserted rows	Determines whether newly inserted rows should be included in the diff or not, allowing you to see additions to the database.
Store results in memory	Stores results in memory for further processing. Note that DBeaver might run out of memory when comparing large tables if this option is enabled. When disabled, results will be stored in a temporary database.
Open new connections	Opens new physical connections for data reading, which can help manage resources and ensure the stability of data comparison operations.
Query rows count	Queries row count before performing compare. This lets you track the progress of the comparison but may cause performance faults in some cases.
Save task	Opens the Save Task window to assist in creating a task during the compare process. This window provides options and settings for creating and configuring a task related to the compare operation.

Execution log

Once you have configured all settings and clicked Proceed, the Data Compare wizard will perform the comparison operation:

• An Execution Log window will display the progress and outcome of the comparison process.
• Simultaneously, a separate window will open showing the comparison results. This window provides a detailed view of differences between the datasets based on the specified settings.

Viewing the results

After the comparison process is complete, you can view the results in the viewer. It highlights the differences between the datasets in detail, with each row that shows a discrepancy being clearly marked.

Note: A complete visual preview of the results is available only when Data Compare is launched through the wizard. If launched as part of a task, the visual editor will not open. Instead, only statistics will be recorded in the execution log.

Additional tools

The viewer not only displays the differences but also provides tools to manage and interpret these differences effectively. Here’s what you can do within the compare viewer:

Feature	Button image	Description
Export changes		The results of the Data Compare can be exported as an SQL script, which includes DELETE , INSERT , and UPDATE statements to make the data in the second table match the first. Alternatively, you can export the results in an HTML format as a table for easy viewing and sharing.
Swap tables		The Swap tables button allows you to switch the positions of the source and target data panels within the viewer.
Show summary		By clicking the Show Summary button, you can access a statistical summary and analysis of the differences found between the datasets. This summary provides a quick overview of the total changes, including the number of modified, deleted, and inserted rows.

Tip: You can also export the comparison results table through Export data button in the bottom toolbar or copy rows or individual values that differ.