Ruka hadi maudhui makuu

Ghala

Tuma matukio, watu na vikundi vya mradi kwenye ghala lako la data kwa ratiba, na ulete data ya nje kando yake.

Destinations

Warehouse sits under Connect and has three tabs. Destinations lists the places a project’s data is sent on a schedule. Add destination asks where to send it: S3-compatible storage (a bucket, a region, an optional endpoint for anything other than Amazon S3, and a key prefix the files are written under), BigQuery (a dataset and a service account Prodantix acts as) or Snowflake (an account, a database, a schema and a user’s private key). Each destination picks what it exports (events, people, groups), a format for files (Parquet or JSON lines) and a schedule (every hour or every day). Check and save tests the destination before keeping it; secrets are saved sealed and never shown again.

Opening a destination shows its Runs (the export, its interval, state, rows and size, with the detail of a failure) and its Settings. The first run starts once the next full interval ends. Backfill opens runs for a past range, at most 2,000 at a time. Deleting a destination stops the sync and removes its run history; files already written stay in the bucket.

Sources

Sources bring outside data in beside the project’s events, and each table then reads in the project’s SQL under a fixed name. A source is one of three kinds: Postgres tables, copied as a read-only user over verified TLS; S3 files in CSV, NDJSON or Parquet; or Stripe objects (customers, subscriptions, invoices and charges) read with a restricted key. A source loads hourly or daily, Load now runs it at once, and each table shows its rows and size. Deleting a source removes its tables from SQL.

Models

Models save SQL over events, cohorts and source tables under a name other SQL reads. A model is a view, computed on every read so it is always current, or a table, refreshed on its schedule so reads are fast; the kind is fixed once the model is made, and renaming a model does not change the name SQL reads it by. The editor previews the query’s rows before saving. Deleting a model removes its table, and any SQL that reads it stops working.

Permissions, API and agents

Adding, changing or deleting anything here needs prodantix.warehouse.manage, and a tab the company’s plan does not include says so in place of its list. REST serves the same under /v1/projects/{projectId}/warehouse/destinations, /v1/projects/{projectId}/warehouse/sources, /v1/projects/{projectId}/warehouse/models, and agents reach it over MCP (prodantix.warehouse.destinations, prodantix.warehouse.runs, prodantix.warehouse.sources, prodantix.warehouse.models).