Skip to content

Guides

Task-oriented walkthroughs for working with the model day to day.

Querying a real ASYCUDA World system?

These guides use the friendly logical model. To run the same queries on a live Sydonia, see Querying Sydonia (the real tables) and the query compiler (write friendly, run genuine).

  •  Loading the schema

    Integration patterns beyond the quickstart — CI, test resets, loading alongside your own tables, and namespacing.

    Loading

  •  Querying the model

    The join paths that matter, plus an analytics cookbook: revenue by HS, assessed-vs-paid, lane throughput, warehouse stock.

    Querying

  •  Extending the schema

    Add tables and columns while keeping the conventions — and the provenance trail — intact.

    Extending

  •  Worked example

    e2e.sql, narrated step by step: manifest → declaration → valuation → taxes → selectivity → payment → release.

    Worked example

  •  Useful queries

    A growing, verified library of analytical queries — effective rates, valuation outliers, selectivity hit-rates — with a copy-paste format.

    Useful queries

  •  ML on customs data

    The risk-engine blueprint: features mapped to SAD boxes and columns, labels from the Inspection Act, the selectivity loop.

    ML on customs data