The following is an SQL Query that pulls data needed to generate Revenue data. The data is fetched from a BigQuery table that is updated from NetSuite via the FiveTran Connector. SELECT t.id AS transaction_id, t.tranid AS transaction_number, MAX(t.trandate) AS transaction_date, MIN(c.id) AS customer_id, MAX(c.externalid) AS customer_sfid, MAX(c.entityid) AS customer_name, MAX(s.id) AS subsidiary_id, MAX(s.name) AS… Continue reading SQL query example that pulls Revenue data and the necessary fields from a BigQuery table containing NetSuite data