Data Flow Gen2 ODBC connection to AWS for Incremental Refresh

 Hi, I am in higer Ed and we are not currently on Fabric License. 
I have a query against an AWS Athena table using  an AWS ODBC Connection.

The table is upward of 17 million rows and approximately 70 columns, many are ID columns.  I would like to incrementally update this data.

I have try many ways to do this unsuccessfully for one reason or anther.   Either it does not fold or it does not do an incremental refesh.

My current state:  dsn, catalog and table are in the source (suggestion in troubleshooting)

Primary query: set to allow staging, it has no destination (Microsoft doc)

Reference query: does not allow staging, it is set to not require folding (it does in Power Query) ,this is where the incremental update is set.  I want to refresh an entire year, when the update field has changed. 

Destination is a lake house table columns are not dynamic, options set to limit 10

Parameters are RangeStart, RangeEnd points to a query to todays date.

I would really love it if anyone has an issue with AWS and figured this out.   (Dates are set as they are per another blog, stating date issues)

This query runs, but it does not appear to do incremental updates.  The second time I run it after adding additional data is longer then the first.  

    // 1. Format dates for Athena

    StartText = DateTime.ToText(RangeStart, "yyyy-MM-dd"),

    EndText   = DateTime.ToText(RangeEnd,   "yyyy-MM-dd"),

    // 2. The SQL Statement with manual folding built-in

    FullQuery = "

        SELECT

            journal_line_wid,

            as_entered_company, (lots of fields)

        FROM edl_workday_fin.cur_journal_transactions_vw

        WHERE accounting_date >= (select date '" & StartText & "') and accounting_date < (select date '" & EndText & "')",

    // 3. The Actual Data Connection

    Source = Odbc.Query("dsn=DSNName;Catalog=AwsDataCatalog;Schema=SchemaName;",

        FullQuery

    )

in

    Source