Azure SQL Data Warehouse announcement
-
Link
We are excited to announce the general availability of Azure SQL Data Warehouse in four additional regions—North Europe, Japan East, Brazil South, and Australia Southeast. These additional locations bring the product worldwide availability count to 18 regions – more than any other major cloud provider.
Read More Here!
Found 685 threads
-
1 Votes[Ongoing Issue] : Unable to Provision Azure SQL Data Warehouse
UPDATE: April 17, 2020 This is an update to the on-going situation that I wanted to share with you all. Here is a link to the full post with a few ...
-
4 Votes
this location is not available for subscription
hile trying to creata a new server for Azure Synapse Analytics I am geting repeated message "this location is not available for subscription " while choosing the location. I tried all ...Proposed | 4 Replies | 905 Views | Created by vikascloud - Friday, March 20, 2020 7:57 PM | Last reply by Mike Ubezzi (Azure) - Friday, March 27, 2020 3:21 AM -
0 Votes
this location is not available for subscription
I am not able to create a sql server on any of the server locations. Please helpProposed | 2 Replies | 343 Views | Created by this location is not available for subscription - Wednesday, March 25, 2020 6:23 AM | Last reply by Mike Ubezzi (Azure) - Friday, March 27, 2020 3:21 AM -
0 Votes
Find Domain Name from Synapse database
Hi, Is there any way to find the Fully Qualified Domain Name from Synapse database through a query similar to the one on SQL Server : SELECT ...Proposed | 3 Replies | 1235 Views | Created by deepu299 - Thursday, March 19, 2020 8:32 PM | Last reply by CHEEKATLAPRADEEP-MSFT - Thursday, March 26, 2020 9:26 AM -
0 Votes
Want to find the total run time or ON time of Data warehouse
I want to find the toal run time of the Azure Data warehouse. We are using data warehouse for processing data. Once we are done with processing data we are pausing data warehouse until there is a ...Proposed | 2 Replies | 413 Views | Created by Murali Mohan Sanapala - Monday, March 16, 2020 2:32 PM | Last reply by Mike Ubezzi (Azure) - Monday, March 23, 2020 5:11 AM -
0 Votes
Azure Synapse single schema - Devops Dacpac?
Our Azure Synapse DB is shared across various teams, we got access only to one schema and need to create devops CI process for further environment deployment. I don't have ...Proposed | 2 Replies | 454 Views | Created by Syedk9 - Monday, March 16, 2020 11:22 PM | Last reply by HimanshuSinha-msft - Thursday, March 19, 2020 6:28 PM -
0 Votes
SSIS Integration Runtime in Azure Synapse Analytics
Is it true that Azure Synapse Analytics does not support Azure-SSIS Integration Runtime? What should I do if I want to migrate an existing ADF (SSIS-IR)?Unanswered | 2 Replies | 633 Views | Created by Yang Jiayi - Saturday, March 14, 2020 8:25 AM | Last reply by KranthiPakala-MSFT - Thursday, March 19, 2020 6:08 PM -
0 Votes
Virtualization layer in Azure
Is there a virtualization layer we can use to query data from different databases on Azure. For eg - Join data from Snowflake on Azure and Azure SQL DWProposed | 5 Replies | 1113 Views | Created by Manikandan Bellan - Friday, February 7, 2020 11:33 AM | Last reply by NavtejSaini-MSFT - Friday, March 6, 2020 3:59 PM -
0 Votes
Azure Synapse Analytics Workspace currently not availbale for public?
I am trying currently to play around with Azure Synapse Analytics. I am able to find and create Azure Synapse Analytics Workspace. I can create a Azure Synapse Analytics (former SQL DW) ...Answered | 2 Replies | 1123 Views | Created by [Yavuz B.] - Monday, March 2, 2020 10:18 AM | Last reply by NavtejSaini-MSFT - Thursday, March 5, 2020 1:36 PM -
0 Votes
How to alter external Table to modify the Location in Azure DataWarehouse?
I have a requirement to use the same external table for multiple sources(all the source data is in same structure) and the copy file Location is Different in ADLS. Below is the ...Proposed | 2 Replies | 869 Views | Created by Venkatesh.Gottimukkala - Thursday, February 27, 2020 4:47 AM | Last reply by Venkatesh.Gottimukkala - Wednesday, March 4, 2020 12:09 PM -
0 Votes
Identity column skipping sequence
Hi, I am trying to create a identity column, but my sequence gets skipped as given below. I am using Azure SQL DW is there any work around for this in AZDW to generate a sequence of ...Proposed | 2 Replies | 937 Views | Created by postman - Wednesday, February 19, 2020 2:57 PM | Last reply by DanielGoucher - Tuesday, February 25, 2020 8:41 AM -
0 Votes
Azure Sql Data Warehouse: Timeout expired issue
when connect to Azure DW and expand table list, i found an error message as following. Execution Timeout expired. The timeout period elapsed prior to completion of the operation or ...Unanswered | 2 Replies | 768 Views | Created by zugapy - Saturday, February 15, 2020 10:39 AM | Last reply by Mike Ubezzi (Azure) - Friday, February 21, 2020 12:20 AM -
0 Votes
Synapse - External Table
Folder1-->3 .csv files DataSource = abfss://containerA@azurestorageadl.blob.core.windows.net Created the external table where the location = ...Answered | 2 Replies | 828 Views | Created by jdb09 - Saturday, February 15, 2020 3:47 PM | Last reply by jdb09 - Thursday, February 20, 2020 4:22 PM -
0 Votes
Azure Synapse(DW) - Column Level Security works or not?
Hello All, I am studying for certification exam where I have a quick and important question: The CLS feature is available for Azure Synapse or not? ...Proposed | 2 Replies | 621 Views | Created by apimenta - Tuesday, February 18, 2020 8:01 PM | Last reply by NavtejSaini-MSFT - Thursday, February 20, 2020 1:26 PM -
1 Votes
Unable to create materialized view in Azure data warehouse
Hi, when i am creating a materialized view with below query it throws me and error. my Azure DB version is : Microsoft SQL Azure ...Answered | 2 Replies | 4320 Views | Created by Nani2020 - Monday, February 17, 2020 1:42 AM | Last reply by Kalyan Chanumolu-MSFT - Tuesday, February 18, 2020 7:07 AM -
0 Votes
Azure SQL db to Azure SQL DWH connectors
Hi, I have an application hosted in Azure SQL database (Source), which is the source system to load data to my Azure SQL DWH (Target). Is there a way I can establish a direct ...Proposed | 2 Replies | 786 Views | Created by naikanvi - Wednesday, February 12, 2020 12:41 PM | Last reply by Kalyan Chanumolu-MSFT - Tuesday, February 18, 2020 5:17 AM -
0 Votes
Transport-level error while running stored procedure
I have an ADF v2 pipeline which triggers stored procedure present in Azure Data warehouse. Mostly this pipeline runs successfully but sometimes i get the following ...Answered | 3 Replies | 569 Views | Created by PriyaJha - Monday, February 17, 2020 5:42 AM | Last reply by Kalyan Chanumolu-MSFT - Monday, February 17, 2020 12:21 PM -
0 Votes
Connecting from DataWareHouse to Storage Account Blob
Dear Team, We are trying to run scala command in Databricks, which will connects to storage for taking data and making dataframe. After that we. need to feed the ...Answered | 4 Replies | 1112 Views | Created by satyajittarai - Wednesday, February 12, 2020 11:49 AM | Last reply by satyajittarai - Friday, February 14, 2020 11:10 AM -
0 Votes
Requesting for Performance Improvement on querying on Table in Azure Synapse
I have a Table with 100k data rows in Azure Synapse. On running "Select Top(1000) from Table;" querry it takes 10s. If I run "Select * from Table;" it is takes 1560s and gets ...Proposed | 3 Replies | 537 Views | Created by Dimpu Sagar N - Wednesday, February 5, 2020 12:31 PM | Last reply by Kalyan Chanumolu-MSFT - Friday, February 14, 2020 3:48 AM -
0 Votes
limit of 8 concurrency slots.
Hi Guys, How to restrict an query to use allocated concurrency slot; rather failing, right we have DW200c so it is able to allow 8 concurrency ...Answered | 3 Replies | 930 Views | Created by Navind - Thursday, February 6, 2020 3:17 PM | Last reply by Mike Ubezzi (Azure) - Wednesday, February 12, 2020 12:14 AM
Azure SQL Data Warehouse announcement
-
Link
We are excited to announce the general availability of Azure SQL Data Warehouse in four additional regions—North Europe, Japan East, Brazil South, and Australia Southeast. These additional locations bring the product worldwide availability count to 18 regions – more than any other major cloud provider.
Read More Here!
