CODEWITHSUNDEEP
azureazure-sql-databaseazure-synapse
Naveen R
Naveen R

Reputation: 93

Azure Sql DataWareHouse API

Is there a REST API for Azure Sql Datawarehouse? Like API for creating server, table etc.

I don't see anything in the documentation https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-overview-what-is/

Upvotes: 1

Views: 1321

Answers (4)

Kalum Umesh
Kalum Umesh

Reputation: 125

Below are the available APIs, You can not do DML and DDL operations using APIs. You have to create a Wrapper for that.

https://learn.microsoft.com/en-us/rest/api/sql/

Upvotes: 0

Ngovkevin
Ngovkevin

Reputation: 153

Many of the Rest APIs that are supported for SQLDB are also supported for SQLDW. See here for reference:

https://msdn.microsoft.com/en-us/library/azure/mt163685.aspx

This should also have Rest APIs for create database/server which you are looking for. You just need to make sure you enter in the correct params (which should be listed in the link above)

Examples - Edition: DataWarehouse ServiceLevelObject: DW400 Version: V12

Hope that helps!

Upvotes: 2

Sonya Marshall
Sonya Marshall

Reputation: 506

Is this what you are looking for? https://azure.microsoft.com/en-us/documentation/articles/sql-data-warehouse-manage-compute-rest-api/

Upvotes: 1

Rob Farley
Rob Farley

Reputation: 15849

No, the idea is that you submit SQL commands to it, similar to how you submit commands to any relational database. I guess it's very feasible to create a set of wrappers, but I doubt Microsoft will prioritise creating such a thing.

Upvotes: 1

Related Questions