question

TarunChawla-0025 avatar image
0 Votes"
TarunChawla-0025 asked ·

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

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

azure-synapse-analytics
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered ·

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


· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TarunChawla-0025 avatar image
0 Votes"
TarunChawla-0025 answered ·

Hi Himanshu,

Thank you for your support. It looks better now.



Regards,
Tarun

· Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.