Solved: Data Factory : Configuration gateway

DALI007 · ‎02-28-2024

Hello,
I am connecting to an Oracle database through a gateway using my DataFlow Gen 2 (see attached photo). I would like to know if it is possible to configure this gateway to automatically limit the number of rows retrieved from any table in the database when I connect through this gateway.
Thank tou for yoyr help

miguel · ‎02-28-2024

A connection fundamentally only has information about the data source and the credentials associated with it.

Information about how data should be retrieved is handled through the different applications and experiences.

The only way to limit the number of rows retrieved from a given data source, using a specific connection, is by using either a notebook, a data pipeline or a dataflow and implementing the specific filters or using specific views from the data source that have the limiting logic in place.

View solution in original post

miguel · ‎02-28-2024

A connection fundamentally only has information about the data source and the credentials associated with it.

Information about how data should be retrieved is handled through the different applications and experiences.

The only way to limit the number of rows retrieved from a given data source, using a specific connection, is by using either a notebook, a data pipeline or a dataflow and implementing the specific filters or using specific views from the data source that have the limiting logic in place.