v1.1.0 dbt_netsuite

Schema/Data Change

7 total changes • 2 possible breaking changes

Data Model(s)	Change type	Old	New	Notes
netsuite2__entity_subsidiary_relationships	New model			Unified view combining customer and vendor subsidiary relationships
netsuite2__transaction_details	New columns		nexus_id nexus_country nexus_state tax_agency_id tax_agency_alt_name is_nexus_override is_tax_details_override tax_point_date is_tax_point_date_override	Adds nexus-related tax information. Breaking change: If you already include any of these fields via the passthrough columns variable transactions_pass_through_columns, remove them from the list to avoid duplicate column errors.
stg_netsuite2__nexuses	New model			Provides access to Netsuite tax nexus data with configurable pass-through columns. See the README for instructions on adding the pass-through columns.
stg_netsuite2__customer_subsidiary_relationships	New model			Maps customers to their associated subsidiaries
stg_netsuite2__vendor_subsidiary_relationships	New model			Maps vendors to their associated subsidiaries
stg_netsuite2__transactions	New columns		nexus_id is_nexus_override is_tax_details_override tax_point_date is_tax_point_date_override	Adds nexus-related tax information. Breaking change: If you already include any of these fields via the passthrough columns variable transactions_pass_through_columns, remove them from the list to avoid duplicate column errors.
stg_netsuite2__vendors	New column		entity_id	For use in netsuite2__entity_subsidiary_relationships. Breaking change: If you already include this field via the passthrough columns variable vendors_pass_through_columns, remove it from the list to avoid duplicate column errors.
All models	New column		source_relation	Identifies the source connection when using multiple Netsuite connectors

Feature Update

• Union Data Functionality: This release supports running the package on multiple Netsuite source connections. See the README for details on how to leverage this feature.
• Entity-Subsidiary Relationships: New end model netsuite2__entity_subsidiary_relationships provides a unified view of both customer and vendor subsidiary relationships with enhanced metadata including currency information. Unions and enhances data from stg_netsuite2__customer_subsidiary_relationships and stg_netsuite2__vendor_subsidiary_relationships.
• Nexus Support: Adds comprehensive support for Netsuite nexus data through new staging model stg_netsuite2__nexuses with configurable pass-through columns. See the README for instructions on how to configure them.
• Adds Streamlit example to the README. See the README for more details.

Under the Hood

• Updates integration tests configuration and seed data references
• Updates the get_*_columns macros to return only the columns referenced by the corresponding staging model.

Contributors:

• @jmongerlyra (PR #171)
• @fivetran-poonamagate (PR #104)

Full Changelog: v1.0.0...v1.1.0