question

RohitKulkarni-3496 avatar image
0 Votes"
RohitKulkarni-3496 asked RohitKulkarni-3496 commented

Sql query Issue in azure synapse pipeline

Hello Team,

I am using the copy activity pipeline and using the QUERY :

Select *
from @{pipeline().parameters.Schema}.
[@{pipeline().parameters.Companies[0]}$@{pipeline().parameters.TablesWithCompany[0]}]

In This @{pipeline().parameters.TablesWithCompany[0]} there are 1139 tables need to pass the value.

example from the screenshot

select from dbo.Group$Acc_ Sched_ Cell Value
select
from dbo.Group$Acc_ Sched_ Chart Setup Line
.select from dbo.Group$Item Discount Group
.
.
.
select
from dbo.Group$Item Cross Refer


If you refer the screenshot i am getting the error :

Please advise how it can be handle.

81524-image.png



azure-data-factory
image.png (85.4 KiB)
5 |1600 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.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered RohitKulkarni-3496 commented

Hey,
Can you try executing the query by adding the table name in brackets since I see space
select from dbo.[Group$Acc_ Sched_ Cell Value]

· 1
5 |1600 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.

Sorry it will be appearing in this format in last message i forgot to mention.

select from dbo.[Group$Acc_ Sched_ Cell Value]
select from dbo.[Group$Acc_ Sched_ Chart Setup Line]
.select from dbo.[Group$Item Discount Group]
.
.
.
select from dbo.[Group$Item Cross Refer]

0 Votes 0 ·