Quickstart: Create a dedicated SQL pool (formerly SQL DW) with Azure PowerShell

2025-04-12

Create an dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics using Azure PowerShell.

Pré-requisitos

Se não tiver uma subscrição do Azure, crie uma conta do Azure gratuita antes de começar.

Important

Creating a dedicated SQL pool (formerly SQL DW) may result in a new billable service. Para obter mais informações, consulte Preços do Azure Synapse Analytics.

Observação

Recomendamos que utilize o módulo do Azure Az PowerShell para interagir com o Azure. Para começar, consulte Instalar o Azure PowerShell. Para saber como migrar para o módulo do Az PowerShell, veja Migrar o Azure PowerShell do AzureRM para o Az.

Entre na sua assinatura do Azure usando o comando Connect-AzAccount e siga as instruções na tela.

Connect-AzAccount

Para ver qual assinatura você está usando, execute Get-AzSubscription.

Get-AzSubscription

Se você precisar usar uma assinatura diferente da padrão, execute Set-AzContext.

Set-AzContext -SubscriptionName "MySubscription"

Create variables

Define variables for use in the scripts in this quickstart.

# The data center and resource name for your resources
$resourcegroupname = "myResourceGroup"
$location = "WestEurope"
# The server name: Use a random value or replace with your own value (don't capitalize)
$servername = "server-$(Get-Random)"
# Set an admin name and password for your database
# The sign-in information for the server
$adminlogin = "ServerAdmin"
$password = "ChangeYourAdminPassword1"
# The ip address range that you want to allow to access your server - change as appropriate
$startip = "0.0.0.0"
$endip = "0.0.0.0"
# The database name
$databasename = "mySampleDataWarehouse"

Criar um grupo de recursos

Create an Azure resource group using the New-AzResourceGroup command. A resource group is a container into which Azure resources are deployed and managed as a group. The following example creates a resource group named myResourceGroup in the westeurope location.

New-AzResourceGroup -Name $resourcegroupname -Location $location

Criar um servidor

Create a logical SQL server using the New-AzSqlServer command. Um servidor contém um grupo de bancos de dados gerenciados como um grupo. The following example creates a randomly named server in your resource group with an admin user named ServerAdmin and a password of ChangeYourAdminPassword1. Replace these pre-defined values as desired.

New-AzSqlServer -ResourceGroupName $resourcegroupname `
    -ServerName $servername `
    -Location $location `
    -SqlAdministratorCredentials $(New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList $adminlogin, $(ConvertTo-SecureString -String $password -AsPlainText -Force))

Configurar uma regra de firewall ao nível do servidor

Create an server-level firewall rule using the New-AzSqlServerFirewallRule command. A server-level firewall rule allows an external application, such as SQL Server Management Studio or the SQLCMD utility to connect to a dedicated SQL pool (formerly SQL DW) through the dedicated SQL pool service firewall.

In the following example, the firewall is only opened for other Azure resources. Para habilitar a conectividade externa, altere o endereço IP para um endereço apropriado para seu ambiente. Para abrir todos os endereços IP, use 0.0.0.0 como o endereço IP inicial e 255.255.255.255 como o endereço final.

New-AzSqlServerFirewallRule -ResourceGroupName $resourcegroupname `
    -ServerName $servername `
    -FirewallRuleName "AllowSome" -StartIpAddress $startip -EndIpAddress $endip

Observação

SQL endpoints communicate over port 1433. Se você estiver tentando se conectar de dentro de uma rede corporativa, o tráfego de saída pela porta 1433 pode não ser permitido pelo firewall da rede. Em caso afirmativo, você não poderá se conectar ao servidor, a menos que o departamento de TI abra a porta 1433.

Create a dedicated SQL pool (formerly SQL DW)

The following example creates a dedicated SQL pool (formerly SQL DW) using the previously defined variables. It specifies the service objective as DW100c, which is a lower-cost starting point for your dedicated SQL pool (formerly SQL DW).

New-AzSqlDatabase `
    -ResourceGroupName $resourcegroupname `
    -ServerName $servername `
    -DatabaseName $databasename `
    -Edition "DataWarehouse" `
    -RequestedServiceObjectiveName "DW100c" `
    -CollationName "SQL_Latin1_General_CP1_CI_AS" `
    -MaxSizeBytes 10995116277760

Required Parameters are:

RequestedServiceObjectiveName: The amount of data warehouse units you're requesting. Increasing this amount increases compute cost. For a list of supported values, see memory and concurrency limits.
DatabaseName: The name of the dedicated SQL pool (formerly SQL DW) that you're creating.
ServerName: The name of the server that you're using for creation.
ResourceGroupName: Resource group you're using. To find available resource groups in your subscription use Get-AzureResource.
Edition: Must be "DataWarehouse" to create a dedicated SQL pool (formerly SQL DW).

Optional Parameters are:

CollationName: The default collation if not specified is SQL_Latin1_General_CP1_CI_AS. Collation can't be changed on a database.
MaxSizeBytes: The default max size of a database is 240TB. The max size limits rowstore data. There is unlimited storage for columnar data.

For more information on the parameter options, see New-AzSqlDatabase.

Limpeza de recursos

Outros tutoriais de início rápido nesta coleção se baseiam neste início rápido.

Tip

If you plan to continue on to work with later quickstart tutorials, don't clean up the resources created in this quickstart. If you don't plan to continue, use the following steps to delete all resources created by this quickstart in the Azure portal.

Remove-AzResourceGroup -ResourceGroupName $resourcegroupname

Próximos passos

You've now created a dedicated SQL pool (formerly SQL DW), created a firewall rule, and connected to your dedicated SQL pool. To learn more, continue to the Load data into a dedicated SQL pool article.

Partilhar via