sian-data-destination

Determines the correct GCP project destination for new SIAN data sources and dbt models.

Updated May 21, 2026
One-click install
npx skills add https://github.com/gestaosian/gtsi-claude-skills --skill sian-data-destination-gestaosian
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sian-data-destination
Source: https://github.com/gestaosian/gtsi-claude-skills/tree/main/plugins/gtsi-ops-plugin/skills/sian-data-destination
Command: npx skills add https://github.com/gestaosian/gtsi-claude-skills --skill sian-data-destination-gestaosian

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Deciding where a new data source, system, or dbt model should be materialized in the SIAN platform is an architectural decision with direct cost impact, since gcp-sian-dados shares costs across all group companies. This Skill removes ambiguity by applying a clear shared-versus-exclusive criterion and showing exactly how to configure the dbt project accordingly. ## Core Features & Use Cases - Destination Decision Criteria: Classifies a system as shared (multi-company, goes to gcp-sian-dados) or exclusive (single company, goes to gcp-sian-proj-<empresa>), with concrete examples like Protheus, RM, Pontotel, and MIX. - dbt Configuration Guidance: Provides ready-to-adapt dbt_project.yml snippets for both shared models under models/sian/<sistema>/ and exclusive models under models/clients/<empresa>/, including schema and materialization settings. - Governance Rules: Enforces that the destination decision is declared in the PR, that Raw ingestion tables always land in gcp-sian-dados.raw, and that exclusive data is exposed only via RBAC on the company project. - Use Case: When adding the MIX system for Urbi, the Skill identifies it as company-exclusive, directs the models to models/clients/urbi/mix/, and configures +database: gcp-sian-proj-urbi. ## Quick Start Ask the assistant to determine where a new system or dbt model should be materialized in the SIAN platform and how to configure it in dbt_project.yml.

Frequently Asked Questions about sian-data-destination

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I decide which GCP project a new data source belongs in?▼

Apply the shared-versus-exclusive criterion: systems used by more than one client company go to gcp-sian-dados, while systems used by a single company go to gcp-sian-proj-<empresa>. Separate instances per company count as exclusive even if the software name is identical.

How to configure a dbt model for a client-specific GCP project?▼

Place the model under models/clients/<empresa>/ and add an entry in dbt_project.yml setting +database to gcp-sian-proj-<empresa>, with silver and gold schemas and their materializations. Shared models instead live under models/sian/<sistema>/ using the default gcp-sian-dados database.

Do Raw ingestion tables also go to the client-specific project?▼

No. Raw tables ingested via DAG always land in gcp-sian-dados.raw regardless of the source system. The separation between shared and exclusive data happens only in the Silver and Gold layers built by dbt.

Can I change the destination project after a system is already deployed?▼

Not without a data migration, which is why the destination decision must be declared in the PR that adds the system. Treat the choice as effectively irreversible and validate it against the quick verification checklist before coding.

How do business teams access data in client-specific projects?▼

Data in gcp-sian-proj-* projects is accessed by business teams through RBAC permissions granted on the company's own project. Exclusive data must not be exposed through the shared gcp-sian-dados project.