Version of Synapse Analytics

MiKeZZa 21 Reputation points
2020-07-01T09:46:25.097+00:00

I'm having a question; I'm having 2 SQL DW / Synapse databases (dev + uat) and a few things that I see is a difference in version. I started figuring this out because of that DEV supported a Common Table Expression with an insert and UAT doesn't... So it seems that dev supports some in preview features. I wanted to find this in Azure Portal, but I can't find something like 'preview features' or 'version' in portal.

The query:

SELECT SERVERPROPERTY('ProductVersion')
SELECT SERVERPROPERTY('EngineEdition')
SELECT @@Version

Gives me for DEV:
12.0.2000.8
5
Microsoft SQL Azure (RTM) -12.0.2000.8 Jun 18 2020 16:54:11

And for UAT:
10.0.11038.0
6
Microsoft Azure SQL Datawarehouse - 10.0.11038.0 Apr 21 2020 19:42:42

Now my questions are:

  • Where in Azure Portal can I find the version of my SQL Synapse Database or Server?
  • Where in Azure Portal can I find the option 'see preview features'
  • Is there anybody who knows more about CTE's in Synapse? Can't find anything on Google at all, but it seems to be possible
  • How can I update a DW?
  • How do ProductVersion and EngineEdition relate to each other? I think it's strange that 1 is higher and the other is lower
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,871 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Mike Ubezzi 2,776 Reputation points
    2020-07-02T04:08:27.017+00:00

    Hi @MiKeZZa - From the information you provided, the DEV environment is an Azure SQL Database. The UAT environment is an Azure Synapse Analytics instance. Please see the following information with regard to the Synapse Analytics server version information: Check your Azure Synapse version, as there is no information available in the portal.

    As new features are rolled out to all regions, check the version deployed to your instance and the latest release notes for feature availability. To check the version, connect to your SQL pool via SQL Server Management Studio (SSMS) and run SELECT @@VERSION; to return the current version. Use this version to confirm which release has been applied to your SQL pool. The date in the output identifies the month for the release applied to your SQL pool. This only applies to service-level improvements.

    I am detailing the below to show I am seeing the same version information between a Azure Synapse instance and an Azure Database. The above link details more about the version information pertaining to Synapse Analytics (how to check version and identify new features).

    The reason I believe DEV is a DB and not a DW is the EngineEdition differences.

     /* Script to get full version detail */
 /* */
 SELECT SERVERPROPERTY('ProductVersion') AS "Product Version", SERVERPROPERTY('EngineEdition') AS "Engine Edition", @@Version AS "Version";

    Using the above script, I ran this in an Azure SQL Database and a Synapse Analytics to compare version information, which matches your results.

    Azure SQL Database

    12.0.2000.8 5 Microsoft SQL Azure (RTM) - 12.0.2000.8 May 15 2020 00:47:08 Copyright (C) 2019 Microsoft Corporation

    11224-screenshot-105.png

    Azure Synapse Analytics

    10.0.11216.0 6 Microsoft Azure SQL Data Warehouse - 10.0.11216.0 Jun 25 2020 22:13:04 Copyright (c) Microsoft Corporation

    11223-screenshot-104.png

    Please let me know if you have any additional questions.

    Regards,
    Mike

  2. MiKeZZa 21 Reputation points
    2020-07-02T07:41:36.223+00:00

    Thank you @Zagato36 for replying!

    Oh... How stupid. I've made the connection to DB instead of DW, you're right.... Pffffffft.

    But now I've done it correct and there still is a difference:

    DEV: 10.0.11115.0
    UAT: 10.0.11038.0

    And now we are where I wanted to be:

    • How is this difference caused? Enabled preview features?
    • If above questions is; yes, preview features; how can I enable them? Where can I see this setting?
    • Is there a list with introduced features per version?

    It seems that INSERT combined with CTE is possible in 10.0.11115.0, but not yet in 10.0.11038.0. So now I'm developing stuff that works and during my CI/CD it fails because of this version difference. I want to have some more info about where this is caused, how to play with this and how to get more info about the new features that are coming but not yet available further on in our DTAP.

    0 comments
  3. MiKeZZa 21 Reputation points
    2020-07-08T18:42:50.687+00:00

    A little kick. Somebody has an idea about this issue?

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.