Export Azure Table to CSV

$SQLServer = "xxxx.database.windows.net"
$SQLDBName = "yyyyy"
$uid ="zzzzz"
$pwd = "qqqqqqqqq"
$SqlQuery = "SELECT * from [dbo].[MyTable];"
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; Integrated Security = False; User ID = $uid; Password = $pwd;"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = $SqlQuery
$SqlCmd.Connection = $SqlConnection
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
$SqlAdapter.SelectCommand = $SqlCmd
$DataSet = New-Object System.Data.DataSet
$SqlAdapter.Fill($DataSet)

$DataSet.Tables[0] | export-csv "C:\temp\xxxx.csv" -NoTypeInformation

Till Next Time