This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 41%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Hi,
I'm implementing some ADF pipelines.
I need to query the data source (a relational database) in order to understand the right data filters before the data ingestion.
Is it possible (f.e. at linked service and/or data set)?
Thanks
An Azure service for ingesting, preparing, and transforming data at scale.
Hey,
You need to 1st create a linked service connecting to that database.
Then create a dataset mapping to that linked service and via query option, check out your query in preview mode.
But ideally would suggest using ssms Or data studio to connect to database and phase/test out your Queries
Hi, thanks for your reply. I'm using a SAP Table linked service with the right credentials that I don't know.
For the related dataset I cannot see any option to write a SQL query. It seems that I can specify only the table to read.
Thanks
Ohh! As this is SAP table, please follow the below link:
https://learn.microsoft.com/en-us/azure/data-factory/connector-sap-table?tabs=data-factory
Wherein you can then create a copy activity and in source section work on preview option
I can specify the table to read and in the RFC table option the columns to filter, but I cannot specify f.e. SELECT DISTINCT MANDT FROM myTable.