E-conomic SQL templates

2 ready-to-run SQL models for E-conomic data in your own warehouse. Each one runs as-is against your synced tables, in Weld SQL or dbt.

• Invoice line items

  Retrieves invoice line items from the economic integration. It combines data from the "booked_invoices" table and the "products" and "customers" tables to provide information such as the customer name, invoice details, product details, and order by date in descending order.

  intermediate

• Order items

  Retrieves order items from the "economic" integration. It combines data from the "orders" table and the "customers" table, joining them based on the customer ID. The result is sorted in descending order by date.

  intermediate

Or browse templates for every connector.