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
-
0 Votes
azure synapse connect to power bi cloud-based
Hi, I would like to know. when i need connect azure synapse services to power bi pro or premium on cloud-based. secure in data transit from ...Proposed | 3 Replies | 615 Views | Created by za_phu - Saturday, April 25, 2020 4:37 PM | Last reply by CHEEKATLAPRADEEP-MSFT - Wednesday, April 29, 2020 12:09 PM -
1 Votes
Can I back up and recover on a partition-by-partition basis with Azure synapse analytics(Azure SQL Data Warehouse)?
Hello, experts. What I'm curious about is not a full backup, but a partition-by-partition backup? Can I back up and recover on a ...Proposed | 1 Replies | 381 Views | Created by ted.kimm - Friday, April 24, 2020 8:15 AM | Last reply by HimanshuSinha-msft - Monday, April 27, 2020 6:08 PM -
0 Votes
Split column data based on a delimiter in Azure Data Warehouse without using pivot
Hi, I have a table with a path column that contains delimited ...Answered | 4 Replies | 631 Views | Created by _sd_ - Thursday, March 19, 2020 12:24 PM | Last reply by _sd_ - Monday, April 27, 2020 4:05 PM -
0 Votes
Azure Synapse preview
I created a Synapse SQL Pool and signed up for the preview. A day later i received an email "Welcome to Azure Synapse Analytics" but there aren't any instructions for the workspace or ...Proposed | 7 Replies | 517 Views | Created by stumap - Tuesday, April 14, 2020 12:48 AM | Last reply by CHEEKATLAPRADEEP-MSFT - Monday, April 27, 2020 6:22 AM -
0 Votes
Online training for End to End Azure Data Warehouse Development
Hi all, Does anyone know of a comprehensive online training course that takes you through the implementation of a modern datawarehouse in Azure. I've seen ...Answered | 6 Replies | 740 Views | Created by Dz6kb4 - Tuesday, April 21, 2020 7:56 PM | Last reply by CHEEKATLAPRADEEP-MSFT - Monday, April 27, 2020 4:34 AM -
0 Votes
How to check External Data source connection/Database scoped is working.?
Msg 105005, Level 16, State 1, Line 1 CREATE EXTERNAL TABLE AS SELECT statement failed as the path name 'abfss://comm@xxxx.dfs.core.windows.net/xxx/xxx/xxx' could not be used for ...Proposed | 3 Replies | 529 Views | Created by everfor - Tuesday, April 21, 2020 12:43 PM | Last reply by CHEEKATLAPRADEEP-MSFT - Friday, April 24, 2020 11:26 AM -
0 Votes
Azure Synapse backup to Blob storage
I would like to delete subscription but before deleting i would like to take backup of Azure DW. Please do let me know how to take Azure Synapse backup to Blob storage before deleting data warehouse ...Proposed | 2 Replies | 566 Views | Created by Vishwajit - Wednesday, April 15, 2020 11:47 PM | Last reply by ChiragMishra-MSFT - Wednesday, April 22, 2020 11:31 AM -
0 Votes
Poly base script
I am using DWU 100 unit in our SQL data warehouse and facing issue while loading data from blob storage to stage environment for few tables. Poly base script is failing sometimes ...Proposed | 2 Replies | 436 Views | Created by Ashu101 - Wednesday, April 15, 2020 10:37 AM | Last reply by KranthiPakala-MSFT - Monday, April 20, 2020 9:48 PM -
1 Votes
Queries performances on ADLS gen 2
I'm trying to migrate our "old school" database (mostly time series) to an Azure Data Lake. So I took a random table (10 years of data, 200m records, ...Proposed | 2 Replies | 427 Views | Created by Ben_ycc - Monday, April 13, 2020 2:41 PM | Last reply by DanielGoucher - Thursday, April 16, 2020 8:06 AM -
0 Votes
How to create unique index on multiple column in Azure synapse on same table
Hi All please help for How to create unique index on multiple column in Azure synapse on same ...Proposed | 2 Replies | 479 Views | Created by Sanjeev chandawar - Wednesday, April 15, 2020 6:03 AM | Last reply by Sanjeev chandawar - Wednesday, April 15, 2020 3:37 PM -
0 Votes
Any alternative to joined Delete's in SQL Azure DW?
Hi Azure DW gurus, A query such as the following works fine on Azure SQL Server: DELETE FROM dbo.TableA A INNER JOIN ...Answered | 7 Replies | 3105 Views | Created by MK_RP - Monday, September 24, 2018 4:04 PM | Last reply by Mike Ubezzi (Azure) - Monday, April 13, 2020 10:33 PM -
1 Votes
Is there anywhere I can see performance comparison of Azure Synapse Analytics with other Microsoft Services?
I know Microsoft has documentation for comparison to Big Query and AWS on their Synapse page, however, I am looking for comparison to other Microsoft Services has to offer ...Answered | 3 Replies | 591 Views | Created by OCS.New - Friday, April 10, 2020 2:52 AM | Last reply by HimanshuSinha-msft - Monday, April 13, 2020 5:56 PM -
0 Votes
Query between Azure SQL data warehouse and Azure SQL database
Hello Team, I need to query a table present in Azure SQL database from Azure SQL data warehouse. So what should be the external data source details in the Azure ...Answered | 3 Replies | 1590 Views | Created by Nandan Hegde - Monday, April 6, 2020 7:06 AM | Last reply by MartinJaffer-MSFT - Tuesday, April 7, 2020 8:09 PM -
0 Votes
Is Synapse Studio generally available?
Hi, I have a paid subscription account of Azure. I wanted to use Azure Synapse workspace for my development purpose but i am not able to create one for myself. I searched for Azure ...Proposed | 3 Replies | 454 Views | Created by Samyak_Jain - Thursday, April 2, 2020 10:28 AM | Last reply by CHEEKATLAPRADEEP-MSFT - Tuesday, April 7, 2020 12:54 PM -
0 Votes
Pause Azure SQL Data Warehouse
Hi, I have a one requirement. I need to pause Azure SQL Datawarehouse when no there is no active connections or idle time is more than 30min. Example First check ...Answered | 3 Replies | 572 Views | Created by RAJ927 - Thursday, April 2, 2020 11:50 AM | Last reply by MartinJaffer-MSFT - Friday, April 3, 2020 8:44 PM -
0 Votes
error 2200
"errorCode": "2200", "message": "ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database ...Proposed | 4 Replies | 476 Views | Created by Bryan_344 - Friday, March 27, 2020 3:51 PM | Last reply by MartinJaffer-MSFT - Thursday, April 2, 2020 11:32 PM -
0 Votes
Where is Synapse Analytics Studio?
We're starting to explore Synapse and have seen many videos published over the past 2-4 months demonstrating the "single pane of glass" concept of the studio. But it cannot be found in the ...Answered | 3 Replies | 557 Views | Created by wfsharon2 - Wednesday, April 1, 2020 3:30 PM | Last reply by KranthiPakala-MSFT - Thursday, April 2, 2020 10:00 PM -
1 Votes
Creating Materialized View in Azure Data Warehouse SQL error
I'm getting the error: Cannot create the clustered index 'SalesByTerritory' on view 'Sample.wwi.SalesByTerritory' because it does not aggregate results. Consider changing ...Answered | 3 Replies | 750 Views | Created by OCS.New - Monday, March 30, 2020 9:30 AM | Last reply by KranthiPakala-MSFT - Wednesday, April 1, 2020 4:44 PM -
2 Votes
Use Azure Key Vault for Polybase (scoped credential)
Is it possible to retrieve the SECRET from the scoped credential from Azure Key Vault? --Credential CREATE DATABASE SCOPED CREDENTIAL AzureStorageCredential WITH ...Answered | 3 Replies | 932 Views | Created by SSISJoost - Wednesday, March 25, 2020 8:31 PM | Last reply by SSISJoost - Tuesday, March 31, 2020 9:03 PM -
0 Votes
HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: IllegalArgumentException: Must be 12 bytes
Getting this error while querying external table in SQL DW. Saumya SuhagiyaAnswered | 7 Replies | 10614 Views | Created by S S 007 - Wednesday, March 18, 2020 11:30 AM | Last reply by MartinJaffer-MSFT - Monday, March 30, 2020 9:03 PM
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!