Skip to content

Releases: UltraCart/rest_api_v2_sdk_javascript_bigquery

Release list

v0.1.0

Choose a tag to compare

@ucjonathan ucjonathan released this 30 Jun 16:03

First public release of @ultracart/bigquery-sdk — query the UltraCart data warehouse in BigQuery and get back native UltraCart JS SDK model instances (Order, Customer, AutoOrder, …).

Published from GitHub Actions via OIDC trusted publishing with a signed provenance attestation (no long-lived tokens).

Added

  • Initial release: UltraCartBigQuery client that streams UltraCart data-warehouse rows and hydrates them into native ultra_cart_rest_api_v2 SDK model instances.
  • Async-iterator query() with constant-memory pagination (default page size 50,000).
  • Default maximumBytesBilled cap (10 GB, overridable; 0 disables) and dryRun() cost estimation.
  • Generic, schema-driven row transformer: BigQuery DATETIME → ISO 8601 (UTC Z); single-value REPEATED RECORD → primitive array; numeric normalization.
  • toBigQueryDatetime() helper for filtering DATETIME columns (inverse of the read-side date transform).
  • projectIdForMerchant() and resolveDataset() helpers; dataset constants.
  • Schema-drift guard (scripts/check-schema-drift.js, npm run check:schema) comparing SDK model field trees to the warehouse schema, with a reviewed baseline in schemas/known-sdk-only.json.
  • Per-entity examples for full backfill and change-data-capture (orders, customers, auto orders, items), plus the extraction guide in docs/EXTRACTION.md.

Install

npm install @ultracart/bigquery-sdk ultra_cart_rest_api_v2 @google-cloud/bigquery

📦 npm: https://www.npmjs.com/package/@ultracart/bigquery-sdk