Synapse Studio error while trying to read data from Storage Account using SQL On Demand

Published Jul 09 2020 07:47 AM 5,260 Views
Microsoft

ErrorFile 'https://storageaccount.dfs.core.windows.net/parquettest/filename.snappy.parquet' cannot be opened because it does not exist or it is used by another process.

 

Scenario: Storage is with the firewall set to use Selected Network\Allow Trusted Microsoft services. Be aware If that is the case you will need to create the MSI. In order to create MSI on SQL On Demand follow the script example steps. 

The error happens when you try to run the Select on the file that exist inside of the storage account from Synapse Studio using SQL On Demand.

 

Before I proceed with the step by step. Another link that may help you: https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/resources-self-help-sql-on-demand

 

Here it goes - how to do it:

 

  1. First check if your account is Data Lake Storage Gen2. This is defined during the creation of the storage account. Fig. 1:

datalake.png

Fig. 1 Data Lake

 

  1. I am using for this test Selected Network\Allow Trusted Microsoft services. But It should work with All Networks as well. Fig. 2.firewall.pngFig. 2  Firewall
  2. Add the RBAC permission to your workspace. Fig. 3.workspace_permission.pngFig. 3  RBAC
  3. Open Synapse Studio
    1. Open Data option for SQL on Demand
    2. Create a database
    3. Point to the database created.
    4. Create the MSI which requires the master key
    5. Create the datasource.
    6. Run OpenRowset using that credential as data source.

 

Follow the script:

 

CREATE DATABASE [YourDatabase]

GO

-------Change to YourDatabase

CREATE MASTER KEY ENCRYPTION BY PASSWORD'XXXXX!0000';

-- Create a database scoped credential.

CREATE DATABASE SCOPED CREDENTIAL AppCred WITH IDENTITY = 'Managed Identity'

 

script.png

 

 

Note my Storage Account is called Criativity, you should use for the MSI .dfs instead of .blob.

 

 

CREATE EXTERNAL DATA SOURCE YourDataSourceName_criativity

WITH (

LOCATION = 'https://criativity.dfs.core.windows.net',

cREDENTIAL = [AppCred]

)

SELECT  TOP 100 *

FROM OPENROWSET(

        BULK 'parquet/*.parquet',

        DATA_SOURCE = 'YourDataSourceName_criativity',

        FORMAT = 'PARQUET'

as X

 

That is it!

 

Thanks to the collegues Charl Roux and Veljko Vasic. :)

 

Liliam Leme

UK Engineer

 

 

 

 

 

2 Comments
%3CLINGO-SUB%20id%3D%22lingo-sub-1511965%22%20slang%3D%22en-US%22%3ESynapse%20Studio%20error%20while%20trying%20to%20read%20data%20from%20Storage%20Account%20using%20SQL%20On%20Demand%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511965%22%20slang%3D%22en-US%22%3E%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%3CSTRONG%3EError%3C%2FSTRONG%3E%3A%26nbsp%3B%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EFile%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Fstorageaccount.blob.core.windows.net%2Fparquettest%2Ffilename.snappy.parquet%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3Ehttps%3A%2F%2Fstorageaccount.dfs.core.windows.net%2Fparquettest%2Ffilename.snappy.parquet%3C%2FSPAN%3E%3C%2FA%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Bcannot%26nbsp%3Bbe%26nbsp%3Bopened%26nbsp%3Bbecause%26nbsp%3Bit%26nbsp%3Bdoes%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Enot%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Bexist%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eor%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Bit%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eis%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eused%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eby%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Banother%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eprocess%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSTRONG%3EScenario%3C%2FSTRONG%3E%3A%20Storage%20is%20with%20the%20firewall%20set%20to%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3Euse%20Selected%20Network%5CAllow%20Trusted%20Microsoft%20services.%20Be%20aware%20If%20that%20is%20the%20case%20you%20will%20need%20to%20create%20the%20MSI.%20In%20order%20to%20create%20MSI%20on%20SQL%20On%20Demand%20follow%20the%20script%20example%20steps.%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3EThe%20error%20happens%20when%20you%20try%20to%20run%20the%20Select%20on%20the%20file%20that%20exist%20inside%20of%20the%20storage%20account%20from%20Synapse%20Studio%20using%20SQL%20On%20Demand.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CSPAN%3EBefore%20I%20proceed%20with%20the%20step%20by%20step.%20Another%20link%20that%20may%20help%20you%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fsql%2Fresources-self-help-sql-on-demand%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fsql%2Fresources-self-help-sql-on-demand%3C%2FA%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%3CSTRONG%3EHere%20it%20goes%20-%20how%20to%20do%20it%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20style%3D%22margin-left%3A%20.375in%3B%20direction%3A%20ltr%3B%20unicode-bidi%3A%20embed%3B%20margin-top%3A%200in%3B%20margin-bottom%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20font-weight%3A%20normal%3B%20font-style%3A%20normal%3B%22%20type%3D%221%22%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%20value%3D%221%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20font-weight%3A%20normal%3B%20font-style%3A%20normal%3B%22%3EFirst%20check%20if%20your%20account%20is%20Data%20Lake%20Storage%20Gen2.%20This%20is%20defined%20during%20the%20creation%20of%20the%20storage%20account.%20Fig.%201%3A%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%20class%3D%22lia-indent-padding-left-60px%22%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22datalake.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204365i678A1713FD304774%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22datalake.png%22%20alt%3D%22datalake.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-60px%22%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20font-weight%3A%20normal%3B%20font-style%3A%20normal%3B%22%3EFig.%201%20Data%20Lake%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20class%3D%22lia-indent-padding-left-60px%22%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%20style%3D%22margin-left%3A%20.375in%3B%20direction%3A%20ltr%3B%20unicode-bidi%3A%20embed%3B%20margin-top%3A%200in%3B%20margin-bottom%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20font-weight%3A%20normal%3B%20font-style%3A%20normal%3B%22%20type%3D%221%22%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%20value%3D%222%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20font-weight%3A%20normal%3B%20font-style%3A%20normal%3B%22%3EI%20am%20using%20for%20this%20test%20Selected%20Network%5CAllow%20Trusted%20Microsoft%20services.%20But%20It%20should%20work%20with%20All%20Networks%20as%20well.%20Fig.%202.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22firewall.png%22%20style%3D%22width%3A%20999px%3B%22%3E-ERR%3AREF-NOT-FOUND-%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EFig.%202%26nbsp%3B%20Firewall%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EAdd%20the%20RBAC%20permission%20to%20your%20workspace.%20Fig.%203.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22workspace_permission.png%22%20style%3D%22width%3A%20999px%3B%22%3E-ERR%3AREF-NOT-FOUND-%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EFig.%203%26nbsp%3B%20RBAC%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EOpen%20Synapse%20Studio%3C%2FSPAN%3E%3C%2FLI%3E%0A%3COL%20style%3D%22margin-left%3A%20.375in%3B%20direction%3A%20ltr%3B%20unicode-bidi%3A%20embed%3B%20margin-top%3A%200in%3B%20margin-bottom%3A%200in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20font-weight%3A%20normal%3B%20font-style%3A%20normal%3B%22%20type%3D%22a%22%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%20value%3D%221%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%20font-weight%3A%20normal%3B%20font-style%3A%20normal%3B%22%3EOpen%20Data%20option%20for%20SQL%20on%20Demand%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3ECreate%20a%20database%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3EPoint%20to%20the%20database%20created.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3ECreate%20the%20MSI%20which%20requires%20the%20master%20key%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3ECreate%20the%20datasource.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3CLI%20style%3D%22margin-top%3A%200%3B%20margin-bottom%3A%200%3B%20vertical-align%3A%20middle%3B%22%3E%3CSPAN%20style%3D%22font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3ERun%20OpenRowset%20using%20that%20credential%20as%20data%20source.%3C%2FSPAN%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FOL%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%3CSTRONG%3EFollow%20the%20script%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ECREATE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EDATABASE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%5BYourDatabase%5D%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20blue%3B%22%3EGO%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20green%3B%22%3E-------Change%26nbsp%3Bto%26nbsp%3BYourDatabase%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ECREATE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EMASTER%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EKEY%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EENCRYPTION%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EBY%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EPASSWORD%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'XXXXX!0000'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3B%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20green%3B%22%3E--%26nbsp%3BCreate%26nbsp%3Ba%26nbsp%3Bdatabase%26nbsp%3Bscoped%26nbsp%3Bcredential.%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ECREATE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EDATABASE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3BSCOPED%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ECREDENTIAL%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3BAppCred%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EWITH%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EIDENTITY%3C%2FSPAN%3E%3CFONT%20color%3D%22%23FFFF00%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'Managed%26nbsp%3BIdentity'%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22script.png%22%20style%3D%22width%3A%20954px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204393i8C0F65DF7A1D7C84%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22script.png%22%20alt%3D%22script.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3ENote%20my%20Storage%20Account%20is%20called%20%3CSTRONG%3ECriativity%3C%2FSTRONG%3E%2C%20you%20should%20use%20for%20the%20%3CU%3E%3CSTRONG%3EMSI%20.dfs%20instead%20of%20.blob.%3C%2FSTRONG%3E%3C%2FU%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ECREATE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EEXTERNAL%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EDATA%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ESOURCE%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3BYourDataSourceName_criativity%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EWITH%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B(%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3ELOCATION%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fcriativity.dfs.core.windows.net%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fcriativity.dfs.core.windows.net%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EcREDENTIAL%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3D%26nbsp%3B%5BAppCred%5D%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E)%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ESELECT%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ETOP%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%2309885a%3B%22%3E100%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B*%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EFROM%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23863b00%3B%22%3EOPENROWSET%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E(%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EBULK%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'parquet%2F*.parquet'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3CSPAN%20style%3D%22color%3A%20black%3B%22%3EDATA_SOURCE%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'YourDataSourceName_criativity'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23863b00%3B%22%3EFORMAT%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'PARQUET'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eas%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3BX%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3EThat%20is%20it!%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3EThanks%20to%20the%20collegues%20Charl%20Roux%20and%20Veljko%20Vasic.%20%3A)%3C%2Fimg%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3ELiliam%20Leme%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3EUK%20Engineer%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Calibri%3B%20font-size%3A%2011.0pt%3B%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%20color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1511965%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EFile%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3Ehttps%3A%2F%2Fstorageaccount%3CSTRONG%3E.dfs%3C%2FSTRONG%3E.core.windows.net%2Fparquettest%2Ffilename.snappy.parquet%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Bcannot%26nbsp%3Bbe%26nbsp%3Bopened%26nbsp%3Bbecause%26nbsp%3Bit%26nbsp%3Bdoes%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Enot%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Bexist%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eor%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Bit%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eis%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eused%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eby%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3Banother%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eprocess%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3EWhile%20trying%20to%20execute%20select%20open%20rowset%20on%20the%20SQL%20On%20Demand%20like%20this%3A%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ESELECT%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3ETOP%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%2309885a%3B%22%3E100%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B*%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EFROM%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23863b00%3B%22%3EOPENROWSET%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E(%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3EBULK%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E-ERR%3AREF-NOT-FOUND-%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fstorageaccount.dfs.core.windows.net%2Fparquettest%2Ffilename.snappy.parquet%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fstorageaccount.dfs.core.windows.net%2Fparquettest%2Ffilename.snappy.parquet%3C%2FA%3E%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%2C%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23863b00%3B%22%3EFORMAT%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3B%3D%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20%23a31515%3B%22%3E'PARQUET'%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%20style%3D%22margin%3A%200in%3B%20margin-left%3A%20.375in%3B%20font-family%3A%20Consolas%3B%20font-size%3A%2010.5pt%3B%22%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E)%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20blue%3B%22%3Eas%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%26nbsp%3BX%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3EYou%20are%20experience%20the%20error%20above.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3EDocs%20are%20here%3A%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E-ERR%3AREF-NOT-FOUND-%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fsql%2Fdevelop-openrowset%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsynapse-analytics%2Fsql%2Fdevelop-openrowset%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1511965%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20Studio%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20Support%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jul 10 2020 05:51 AM
Updated by: