Stack Overflow
Stack Overflow

Questions tagged [azure-synapse]

Questions about Azure Synapse Analytics, bringing together enterprise data warehousing and big data analytics.

Azure Synapse is a limitless analytics service that brings together enterprise data warehousing and Big Data analytics. It gives you the freedom to query data on your terms, using either serverless or provisioned resources—at scale. Azure Synapse brings these two worlds together with a unified experience to ingest, prepare, manage, and serve data for immediate BI and machine learning needs.

2525 questions
5
votes
2 answers

Azure synapse Merger syntax error for Merge into TSQL

Just would like to know what's the problem of the following merge . thanks
mytabi
  • 639
  • 2
  • 12
  • 28
5
votes
2 answers

Azure Synapse Analytics | Login failed for user ''

I have created a dedicated SQL pool in Azure Synapse Analytics. When I am trying to create a table in my dedicated SQL pool then it is showing below error. Login failed for user < token-identified principal> Things I tried- Reset user…
Praval Sharma
  • 1,921
  • 2
  • 14
  • 20
5
votes
1 answer

Connect to Synapse from DataBricks using Service Principal

I am trying to connect from Databricks to Synapse using service principal. I have configured the service principal in cluster configuration fs.azure.account.auth.type..dfs.core.windows.net OAuth fs.azure.account.oauth.provider.type…
Ram
  • 51
  • 1
  • 3
5
votes
1 answer

Azure Databricks to Azure SQL DW: Long text columns

I would like to populate an Azure SQL DW from an Azure Databricks notebook environment. I am using the built-in connector with pyspark: sdf.write \ .format("com.databricks.spark.sqldw") \ .option("forwardSparkAzureStorageCredentials", "true") \ …
casparjespersen
  • 3,460
  • 5
  • 38
  • 63
5
votes
2 answers

Character length over 130 does not show in column

I have a lot of questions from a survey im using for a pivot table. To collect all the questions to my pivot dynamically im using stuff and for xml path. However it seems like question text > 130 in length is not showing. And i can select all the…
SqlKindaGuy
  • 3,501
  • 2
  • 12
  • 29
5
votes
3 answers

UPDATE FROM in Azure SQL DW?

I'm receiving an error in Azure SQL DW trying to do an UPDATE FROM query. The error is "FROM clause in UPDATE and DELETE statements cannot contain subquery sources or joins" Is this just specific to SQL DW? I don't see anything wrong with this query…
Brian Vallelunga
  • 9,869
  • 15
  • 60
  • 87
5
votes
2 answers

Rename Column in Azure Data Warehouse

I know I can accomplish my objective with this process: Create new column Update new from old Drop old I am looking for a way to do this with one command. I know that remane object works at the table level. For example, I can do this: rename…
Dan Bracuk
  • 20,699
  • 4
  • 26
  • 43
5
votes
2 answers

Dump table and view DDL from Azure SQL Data Warehouse

How does one dump/export the DDL at the schema-level on Microsoft's Azure SQL Data Warehouse?
Steve
  • 548
  • 8
  • 24
5
votes
4 answers

Azure SQL Data Warehouse Db Development Tools

With the new release of SSDT I noticed the addition of Azure objects such as External Tables and such. However in the Target Db platform Configuration of the Database project I do not see Azure SQL Data Warehouse as an option, just Azure SQL Server.…
SQL Data Ninja
  • 78
  • 1
  • 5
5
votes
2 answers

SQL Azure Data warehouse Dynamic SQL Select query

In Azure SQL Data Warehouse stored procedure I try to form Dynamic SQL and perform select query,I unable to fetch the resutSet Below is code Snippet: DECLARE @sql nvarchar(400) DECLARE @cnt int BEGIN ---Some Business Logic--- SELECT @sql = N'select…
Prakash
  • 281
  • 5
  • 18
5
votes
6 answers

Azure SQL Data Warehouse Surrogate Keys

So Azure SQL Data Warehouse doesn't support identity columns, and therefore it's tricky to deal with surrogate keys.. anyone got any bold solutions on this one? This is best i have found, and it's pretty horrific.
m1nkeh
  • 1,337
  • 23
  • 45
5
votes
1 answer

Azure SQL Data Warehouse and PolyBase can't read CSV files generated using U-SQL and ADLA

I have a U-SQL script that generates a CSV file in Azure storage and an external table in Azure SQL Data Warehouse (SDW) using PolyBase to read that CSV file. When the CSV file is generated using the U-SQL script, SDW is unable to read the data and…
Tiam
  • 73
  • 4
5
votes
2 answers

Recommended tools to ETL data from Azure SQL Database to Azure SQL Data Warehouse?

I have a requirement to build a data warehouse using Azure SQL Data Warehouse, sourced with data from a single Azure SQL Database. Looking at this article, it seems I have two options: SSIS Azure Data Factory My Azure SQL Database is normalized,…
tarun713
  • 2,177
  • 3
  • 17
  • 31
5
votes
2 answers

Polybase create external datasource giving syntax error

I'm trying to execute the following command in Azure Data Warehouse: CREATE EXTERNAL DATA SOURCE Brand WITH (TYPE=HADOOP, LOCATION ='wasbs://brand@mywarehouse.blob.core.windows.net' CREDENTIAL = StorageCred); And I get this error message: Incorrect…
Randy Walker
  • 153
  • 1
  • 9
5
votes
2 answers

Why does Group by Grouping Sets work on SQL Server and not on the Azure SQL Data Warehouse?

The Group By Grouping Sets, Cube and Rollup work on SQL Server, but they don't appear to be supported yet on the Azure SQL Data Warehouse. The same goes with some Ordered Analytics that use the keywords "Rows Unbounded Preceding". I also noticed…
Thomas Coffing
  • 51
  • 1
1 2
3
…
99 100