skills/dataplex-and-bigquery-governance/SKILL.md
Guides agents through GCP-native data governance workflows with Dataplex and BigQuery. Use when designing lakes, zones, policy tags, metadata quality, lineage, discovery, and governed publishing across Cloud Storage, BigQuery, Dataflow, Dataproc, and Google Cloud analytics platforms.
npx skillsauth add kilo-org/kilo-marketplace dataplex-and-bigquery-governanceInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Use this skill when governance on GCP is centered on Dataplex, BigQuery, and related Google Cloud metadata controls. It helps agents define governance zones, policy-tag boundaries, lineage expectations, and trusted publishing patterns for warehouse and lake platforms.
Dataplex lakes, zones, or governance domainsBigQuery policy tags and governed publish boundariesGCPCloud Storage, BigQuery, Dataflow, and DataprocDo not treat BigQuery governance as only a permissions problem. Trusted publishing also needs metadata, ownership, and policy boundaries.
Define the governance boundary. Decide:
Define metadata and policy controls. Include:
Align lake and warehouse governance.
Make explicit how Cloud Storage, BigQuery, and processing services fit the same control model.
Design governed publish behavior. Require:
Validate day-2 operations. Review whether onboarding, schema evolution, and new domains remain manageable under the governance model.
| Rationalization | Reality | | --- | --- | | "Policy tags are the whole governance design." | Tags help, but they do not replace ownership, zone design, trusted publishing, or metadata quality. | | "Dataplex is only for lake governance." | Many teams need a joined governance model across storage, warehouse, and processing surfaces. | | "Discovery will happen automatically once assets are scanned." | Useful discovery requires curated metadata and trust signals. |
development
Oracle Database guidance for SQL, PL/SQL, SQLcl, ORDS, administration, app development, performance, security, migrations, and agent-safe database workflows. Use when the user asks to write, edit, rewrite, review, format, debug, tune, or explain SQL; create or refactor PL/SQL; use SQLcl, Liquibase, ORDS, JDBC, node-oracledb, Python, Java, .NET, or database frameworks; troubleshoot queries, sessions, locks, waits, indexes, optimizer plans, AWR, ASH, migrations, schemas, users, roles, privileges, backup, recovery, Data Guard, RAC, multitenant, containers, monitoring, auditing, encryption, VPD, or safe agent database operations.
documentation
Patterns for reading and writing oleander Iceberg catalog tables in Spark jobs, including naming conventions, write modes, and catalog hierarchy.
data-ai
Integrate Okta for enterprise identity workflows including OIDC login, group claims, and policy-based access controls. Use when implementing workforce or B2B identity scenarios.
documentation
Use when arranging Apache NiFi processors, process groups, ports, comments, numbering, crossing connections, dense fan-in/fan-out, or reusable readable canvas layouts.