How can we query azure synapse table from azure logic apps.To fetch all the rows
Asked
Active
Viewed 268 times
0
-
Can you please share a screen shot or what have you tried? – RithwikBojja Nov 29 '22 at 14:32
-
Are we talking SQL here or Spark? – Skin Nov 29 '22 at 21:26
-
Is your table in dedicated pool or Serverless? – RithwikBojja Nov 30 '22 at 03:48
-
It's about SQL and It's the Serverless. Anyway I got the answer – Akram Nov 30 '22 at 07:02
-
Please post it as an answer to help other community members. – RithwikBojja Dec 01 '22 at 03:36
1 Answers
0
I had connected using SQL Server connection
1.Connection name: Enter a name
2.Authentication type: SQL Server Authentication
3.SQL Server Name: Synapse Workspace,Copy Serverless SQL Endpoint
4.Database name: Name of your database
5.Username: Choose Properties (inside Settings tab) from the left menu bar and copy the username inside the SQL admin username field
6.Password: Choose (reset admin password) and enter new password and save the passsword.
7.Gateway: Not needed (Only required in case of fetching from external system)
Akram
- 958
- 5
- 11