মূল কনটেন্টে যান

ওয়্যারহাউস

প্রজেক্টের ইভেন্ট, মানুষ ও গ্রুপ সময়সূচি অনুযায়ী আপনার নিজের ওয়্যারহাউসে পাঠান, আর বাইরের ডেটা তাদের পাশে আনুন।

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).