Enable Flexible Server during Data Hub creation

A Data Hub uses the same Flexible Server or Single Server settings as the environment in which it runs, but you can choose to enable a Flexible Server on Data Hubs running in an environment that uses a Single Server. This option can be specified during Data Hub creation in the Advanced Options under Network and Availability > Select Azure Database Server.

There are three possible scenarios:

If you choose to use Private Flexible Server and specify a delegated subnet and a Private DNS Zone on the environment level (either during environment creation or later by editing the environment), then from the Select Azure Database Server dropdown you can select to use Private Flexible Server or Single Server for your Data Hub. You cannot select to use (Public) Flexible Server in this case. If you choose to use Private Flexible Server for your Data Hub, it will use the delegated subnet and private DNS zone specified on the environment level.
If you choose to use (Public) Flexible Server and do not specify a delegated subnet and a private DNS zone on the environment level, then from the Select Azure Database Server dropdown you can select to use Flexible Server or Single Server for your Data Hub. You cannot select to use Private Flexible Server in this case.
If you choose to use Single Server on the environment level, then from the Select Azure Database Server dropdown you can select to use Flexible Server or Single Server for your Data Hub. You cannot select to use Private Flexible Server in this case.

If you do not explicitly specify any Azure Database Server option, CDP follows the logic described in Private Flexible Server setup > Database Server Options.

Steps

CDP UI
CDP CLI

This option can be specified during Data Hub creation in the Advanced Options under Network and Availability > Select Azure Database Server.

Create a Data Hub as usual using the cdp create-azure-cluster CDP CLI command and specifying the —-database-type.

For example:

create-azure-cluster —-database-type FLEXIBLE_SERVER

The following table explains the required parameters:


Parameter	Description	Possible values
database-type (string)	The type of the azure database. FLEXIBLE_SERVER is the next generation managed PostgreSQL service in Azure that provides maximum flexibility over your database, built-in cost-optimizations. SINGLE_SERVER is a fully managed database service with minimal requirements for customizations of the database.	FLEXIBLE_SERVER SINGLE_SERVER