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
3
votes
2 answers

Azure SQL alerts on a T sql query

We have a table where we create a record for a job and remove them once the job is complete. I would like to check if there is any records still hanging more than a an hour or so. We do maintain audit timestamps in the table. Is there in an option…
s-a-n
  • 767
  • 2
  • 9
  • 27
3
votes
2 answers

SQL to calculate difference from 1st day of Month to Date specified

I'm working on a sql query to get differences. I have a table containing a reading, timestamp of the reading, id. My end goal is to get three differences. 1. Difference between a day prior to next day reading, 2. Difference between reading 7 day…
gopi nath
  • 186
  • 3
  • 15
3
votes
1 answer

Column Name also appear as a row when querying the external table for specific column

I have a file in azure data lake store. I am using polybase to move data from data lake store to data warehouse. I followed all the steps which are mentioned here. Let's say I have created external table as External_Emp which has 3 columns : ID,…
Jai
  • 416
  • 6
  • 20
3
votes
2 answers

Transaction not getting completed after commit in Azure SQL Data Warehouse

I am trying out transactions using JDBC in Azure SQL Data Warehouse. The transaction is successfully processed, but after the transaction, DDL command fails with error Operation cannot be performed within a transaction. Here is the what I am trying…
subash
  • 51
  • 2
  • 5
3
votes
1 answer

Azure Data Warehouse External Table

How to only read specific file from External Table that is pointing to a Folder in ADLS that has thousands of file ?
NSS
  • 1,835
  • 2
  • 29
  • 66
3
votes
1 answer

Why doesn't Azure SQL DW support Error_Line() function?

Azure SQL DW supports all error handing function such as Error_Procedure(), Error_Message() except Error_Line(). Why? Is there any other alternative?
HimalayanNinja
  • 421
  • 3
  • 11
3
votes
1 answer

Salesforce to Azure Data warehouse - string truncated

We are using Azure data factory to copy data from Salesforce to Azure Data warehouse. The job is getting failed since some values are getting truncated .The source column in Salesforce is of type Long Text area(32000). What will be equivalent data…
venkatesh sivalingam
  • 263
  • 5
  • 18
3
votes
1 answer

Automation of UPDATE of column-level statistics on Azure SQL Data Warehouse

I am planning to automate the refresh (i.e., UPDATE) of column level statistics on my Azure SQL Data Warehouse databases. I plan to log the operations in a site-specific table and then dynamically generate SQL to refresh the statistics using the…
Steve
  • 548
  • 8
  • 24
3
votes
1 answer

Polybase and Predicate Pushdown on Azure Data Lake Analytis

recently the connectivity from Azure SQL DW to Azure Data Laka Analytics via Polybase was announced. https://azure.microsoft.com/de-de/blog/sql-data-warehouse-now-supports-seamless-integration-with-azure-data-lake-store/ does anyone know whether…
Gerhard Brueckl
  • 708
  • 1
  • 9
  • 24
3
votes
1 answer

Automatic deployment of specific objects to related ADW databases

I am contemplating four types of environments (i.e., tech, development, certification, and production), each contains one to dozens of Azure SQL Data Warehouse databases. Each database will contain from a few to several dozen schemas and from…
Steve
  • 548
  • 8
  • 24
3
votes
2 answers

How to a Drop Poly Base external table if exists?

I have loaded the File data from Azure blob storage to Azure SQL DW external table through poly-base. Now the File present in Blob container has been updated. Now I want to load the fresh data. Can any one suggest how the fresh data can be loaded to…
ravi kiran
  • 371
  • 1
  • 5
  • 17
3
votes
2 answers

Indexing on temporary tables in Azure SQL Data Warehouse

Does Azure SQL Data Warehouse support any indexing on temporary tables? No mention of the limitation is found at https://learn.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-tables-temporary. In one attempt at such, I received: …
Steve
  • 548
  • 8
  • 24
3
votes
1 answer

Internal DMS Error while inserting data in Azure Datawarehouse

I am getting following error while inserting data in dimension table in Azure data warehouse: 110802;An internal DMS error occurred that caused this operation to fail. Details: Please use this Error ID when contacting your Administrator for…
Jai
  • 416
  • 6
  • 20
3
votes
2 answers

Azure SQL Datawarehouse JDBC Connectivity

Asking here as a last resort, we've been having many issues trying to connect to Azure SQL DW from a non-Windows environment (Linux, Mac) where SQL Server Managment Studio (SSMS) is not an option. The core requirement is a GUI for analysis…
Kaiwalya Joshi
  • 55
  • 4
3
votes
2 answers

Parent child hierarchy path without using CTE

Hi I have following tables: create table Features ( FeatureId bigint, FeatureName varchar(255), ParentId bigint ) insert into Features values(10, 'Feature 1', 1); insert into Features values(11, 'Feature 2', 10); insert into Features values(12,…
Amit
  • 25,106
  • 25
  • 75
  • 116
1 2 3
…
99 100