PostgreSQL

Adding PostgreSQL data source

From the left navigation panel, click Lakehouse and then click Data Sources.
From the upper right corner of the page, click the + New Database button to start the process of adding a new database.
In the New Data Source page, click the PostgreSQL icon.
Specify the following details to add Microsoft SQL or PostgreSQL. Once you have connected a data source, the system immediately fetches its schema. After this schema retrieval process is complete you can browse and interact with the tables and data.

Field	Description
Connection name	Enter a unique name for the connection.
Database	Specify the name of the existing database that you want to connect.
Host name	Specify the hostname or IP address of the server wherein the database is located.
Port name	Enter the port number used by the database server.
Schema	Specify the schema name for your PostgreSQL or Microsoft SQL connection. If left blank, the default schema will be used (“public” for Postgres and “dbo” for Microsoft SQL).
Properties	Specify additional settings by entering key/value pairs. Each pair represents a unique property and its value.
Case Sensitive	Specify whether your PostgreSQL or Microsoft SQL Server data source has case-sensitive table names. This option allows for seamless integration with databases that use Camel Case or other naming conventions.