Skip to content
Advertisement

Tag: azure-synapse

Is my understanding of how FIELDQUOTE works correct?

I am using Azure Synapse and I m querying the following CSV file: Here is the T-SQL query: Here is the output: I then altered the CSV file to add a colon just before the letter G as so: I get: This lead me to make the following conclusions about FIELDQUOTE: The query as a whole scans each row, character

Azure Synapse is failing to perform the deployment giving error “type Microsoft.Data.Tools.Schema.Sql.SqlDwDatabaseSchemaProvider is not valid”

I am working on Azure Synapse. I am able to build the Azure Synapse project successfully using the Azure CI pipeline’s MS Build task. But as I am trying to deploy Azure Synapse using the Azure CD pipeline, I am getting the following error. I am deploying the DacPac using the following task. I hope this should not be any

Sql Synapse How to update the latest records

Table MAPPING Table MASTER Output after update Table MAPPING I have an issue to update data in Mapping, I’d like to update only latest records. Note: 1 CUST_ID : M ID thus I need to partition by cust_id order by upd_dt DESC,ID ASC to get the latest records. I’d like to update only rows Parse error at line: 33, column:

Why Synapse is not working with my query?

I’m trying to use a query in Synapse Analytics from Azure, and when I use it I got the next error: at Source ‘AgenciesInventoryQueryFromSynapsestg’: shaded.msdataflow.com.microsoft.sqlserver.jdbc.SQLServerException: Parse error at line: 1, column: 47: Incorrect syntax near ‘WITH’. That’s weird for me cause I tested the query in Microsoft SQL Server Management before to add it to Synapse, and it works perfectly

Syntax error when using input parameter to create procedure

I’m getting this error Msg 103010, Level 16, State 1, Line 1 Parse error at line: 33, column: 15: Incorrect syntax near ‘@sas_token’ For reference here are the guides I am following: https://learn.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/quickstart-bulk-load-copy-tsql-examples#b-shared-access-signatures-sas-with-crlf-as-the-row-terminator-windows-style-new-line https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/develop-stored-procedures#stored-procedures-in-synapse-sql I tried the commented part because I thought it didn’t recognize the quotes but it still didn’t work This procedure will be called from Python like

Advertisement