我需要使用 python 创建一个 Azure SQL 数据仓库。我找不到任何文档。我能够使用 python 创建资源组和 SQL 服务器。
创建资源组:
def create_resource():
# Create Resource group
print('Create Resource Group')
print_item(client.resource_groups.create_or_update(group_name, resource_group_params))
创建sql服务器:
def create_sql_server():
# Create SQL Instances
print('Create SQL Instances')
sql_client.servers.create_or_update(
group_name,
server_name,
{
'location': region,
'version': '12.0', # Required for create
'administrator_login': 'ttt', # Required for create
'administrator_login_password': 'ttt' # Required for create
}
)
我能够使用 Rest API 做到这一点:
def create_dwh():
# Create sql data warehouse
print('Create sql data warehouse')
# this will return a azure api token
token=TokenMgt.get_token()
headers = {'Content-Type': 'application/json',
'Authorization': token}
# parameters
# subscription_id : azure subscription id
# group_name : azure resource group
# server_name : SQL server name
# dwh_name : data warehouse db name
api_url = dwh_end_point.format(subscription_id, group_name, server_name, dwh_name)
print(api_url)
data = {
"location": "westus",
"sku": {
"name": "DW100c"
}
}
print(data)
query_params = {'api-version': '2017-10-01-preview'}
response = requests.put(url = api_url, params = query_params, json = data, headers = headers)
response_data = response.json()
print(response_data)
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句