Not able to use dimension tables from Azure Synapse Analystice Service sample data

Question

I created the azure sql pool in synapse service and tried to use the sample data. I tried to connect the sample data with SQL pro for MSSQL but could not access the dimensions tables from sample data.

example:
I used this query-
SELECT S.[SalesAmount] AS [Sales]
FROM [FactResellerSales] AS S

but got an error -
Msg 103010, Level 16, State 1.
Parse error at line: 1, column: 5: Incorrect syntax near 'ANSI_NULLS'.

I tried to get select top 1000 row from table FactResellerSales but still had the error -
Msg 103010, Level 16, State 1.
Parse error at line: 1, column: 5: Incorrect syntax near 'ANSI_NULLS'.

I am trying to learn Run queries against an Azure Synapse Analytics data warehouse but not sure how to go further.

Regards,
Manmeet

Answer 1

Hello @TarunChawla-0025 ,

Welcome to the Q&A .

I could like to bring to your attention the below issue from 2017 , I think that you may be on the older bits and so you are facing the issue , please go through the link below and let me know if that helps .

https://github.com/hankinsoft/SQLPro/issues/81

Thanks & stay safe

Himanshu

---

Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Answer 2

Hi Himanshu,

Thank you for your support. It looks better now.

Regards,
Tarun