- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 06:28 AM
Dear Team,
I am unable to create a SQL Warehouse using AZURE Databricks subscription , below are the details
i am able to create a cluster with single node ,but i am not able to create SQL Warehouse , i am using Cluster size - 2X Small , as part of the process i have raised a support ticket with microsoft , ideally i am practising Databricks SQL using AZURE Databricks , below is the response
any alternate solution ( please note i have also tried setting up AWS account seems having more issues , GCP i have another issue DBFS REST API is not enabled for this workspace , so i would like to stay with AZURE Databricks only)
can some one clarify me , can i still able to use sql commands by just creating a notebook in SQL / create a note book in python and switch using %sql magic commands and test all the queries , what is the disadvantage / missing feature if i don't have SQL Warehouse up and running
any suggestions will i be still able to practice SQL ?
Regards,
Rakesh
- Labels:
-
AzureDatabricks
-
Sql Warehouse
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 12:37 PM
In portal.azure.com, write quotas and ask for an increase. https://portal.azure.com/#view/Microsoft_Azure_Capacity/QuotaMenuBlade/~/myQuotas
Additionally, in SQL warehouse "Advanced options," you can change "Spot instance policy" from "cost-optimized" to "Reliability optimized".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-03-2022 12:37 PM
In portal.azure.com, write quotas and ask for an increase. https://portal.azure.com/#view/Microsoft_Azure_Capacity/QuotaMenuBlade/~/myQuotas
Additionally, in SQL warehouse "Advanced options," you can change "Spot instance policy" from "cost-optimized" to "Reliability optimized".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2022 01:57 AM
@Hubert Dudek Many thanks for the suggestions , i was able to create SQL Warehouse finally ✅️ using AZ DB small 2X
one questions even though choosing cluster size to 2X SMALL with "Spot instance policy" = "Reliability optimized" will there be any cost impacts , just curious to know before testing it ?
Regards,
Rakesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-12-2022 06:01 AM
It will use on-demand instances. Spots are up to 2 times cheaper, depends on availability. If it works ok and your limits are updated, better just change to cost-optimized to save costs. Companies are using it in production as well.