Austin, Have you tried QueryDatabaseTable? For some databases and table schema, it provides a shortcut to querying for the recently changed records, as long as you have a "maximum value column" to use.
https://nifi.apache.org/docs/nifi-docs/components/org.apache.nifi/nifi-standard-nar/1.5.0/org.apache.nifi.processors.standard.QueryDatabaseTable/index.html Thanks, James On Tue, Feb 6, 2018 at 6:12 AM, Austin Duncan <[email protected]> wrote: > All, > I am trying to do a flow that queries a postgres database every hour. I am > trying to use the stateful settings in the updateAttribute processor so > that I only pull new files that have been uploaded within that hour. I am > having trouble figuring out how to implement it. Can anyone help me out? > Thanks, > Austin > > -- > Austin Duncan > *Developer* > PYA Analytics > 2220 Sutherland Avenue > <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> > Knoxville, TN 37919 > <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> > 423-260-4172 > > <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g> > <%28865%29%20684-2828> >
