Azure Synapse - Script parameter for External Table Location

Question

Hello Microsoft Q&A,

I have the following problem: Inside a Azure Synapse Pipeline, I'm using a script to create an External Table in a serverless sql pool. I tried to use a script parameter to parameterize the LOCATION of the External Table:

But I get the following error:

"errorCode": "2011",  
"message": "Incorrect syntax near '@location'.",  
"failureType": "UserError",  

Is it possible to use the script parameter to specify the LOCATION inside a create external table statement?

Answer 1

Hey,
Can you please try the below code

CREATE EXTERNAL TABLE [ExtPB].[Test]  
  
(  
	 c1 int,  
c2 int  
)  
WITH  
(  
	 DATA_SOURCE = [BlobStorage]  
	,LOCATION = N'@{pipeline().parameters.Location}'   
	,FILE_FORMAT = [PipeDelimited]  
	,REJECT_TYPE = VALUE  
	,REJECT_VALUE = 0  
)  
  

Answer 2

Did you ever figure out how to use a script parameter?