Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this tutorial step, you create the contoso-orders-db HorizonDB database in Microsoft Fabric HorizonDB and validate the operational PostgreSQL endpoint.
Important
Fabric HorizonDB is in public preview. Capabilities, limits, and behavior might change before general availability. For more information, see Microsoft Fabric preview features.
Prerequisites
- Complete Create a workspace.
- Keep the
contoso-horizondb-tutorialworkspace open. - Confirm that you can create database items in the workspace.
Create the database
In the
contoso-horizondb-tutorialworkspace, select New item.Search for HorizonDB database.
Select HorizonDB database (preview).
Enter
contoso-orders-dbas the name.Select Create.
Wait for the creation operation to finish.
Open the database item when it reports Online or Ready.
Creation is asynchronous. Don't create another database if the first operation is still running. If creation fails, record the item ID, operation or correlation ID, timestamp, and displayed error before retrying.
The database can become ready before every dependent integration finishes initializing. PostgreSQL readiness and mirroring state are separate.
Validate PostgreSQL
In the database item, open a new SQL query.
Run this PostgreSQL query:
SELECT current_database() AS database_name, current_user AS signed_in_user, current_setting('server_version') AS server_version, current_setting('server_version_num') AS server_version_number, pg_backend_pid() AS session_id, clock_timestamp() AS validated_at;Confirm that:
database_namematches the database name in the connection pane:postgresin the current preview, not the item display namecontoso-orders-db.signed_in_userrepresents your expected Microsoft Entra principal.server_versionreports the version used by your preview database.- One session ID and timestamp are returned.
The full build string can contain service implementation details. Use the settings in the query rather than publishing unreviewed version() output.
Review the connection information
Select Visual Studio Code in the database toolbar, and record these nonsensitive connection values for the client and application exercises:
- PostgreSQL host.
- Port.
- Database name.
- Microsoft Entra user format.
- Released TLS mode and certificate guidance.
- Released token scope or token-acquisition guidance.
Don't record an access token, password, authorization header, or complete authenticated connection string. The notebook uses the PostgreSQL endpoint, not the SQL analytics endpoint.
Review compute behavior
The platform manages compute resources. Use only the controls shown in your item. Where scale to zero is enabled, an idle database can pause and a connection through the same endpoint resumes it. Allow for startup latency; don't assume a fixed idle interval.
Expected outcome
The contoso-orders-db item is ready, the validation query succeeds with your Microsoft Entra identity, and you have recorded the nonsensitive connection coordinates required later.
Only the Microsoft Entra identity that created the database can connect in the current preview. Keep using that identity in later steps. Sharing the item doesn't enable other users or principals. See Validate PostgreSQL access.