Benoit
Benoit
I agree the model could be made incremental. however, since updates on transactions and transaction_lines are common occurrence in NetSuite, the logic would need to upsert records based on the...
@fivetran-jamie @fivetran-joemarkiewicz given the shift to netsuite2.com data source, is it worth optimizing the current models or focus on supporting the new source?
I can see an almost 50% execution time improvement on the query run time of models `netsuite__income_statement` `netsuite__transaction_details` `netsuite__balance_sheet` our NetSuite instance is still pretty light in terms of data...
in my case, the total run time (`dbt run --select +netsuite`) is the same for either option.
might it be worth starting with trial balances by period? or the union of the IS and BS reports? I have noticed the BS does not have Subsidiary level information...