acuantia-dataform

What problem does it solve?

This Skill standardizes and enforces Acuantia-specific conventions within BigQuery Dataform pipelines, ensuring consistency and integration across various data sources and reporting layers.

Core Features & Use Cases

• Enforces Acuantia ODS Architecture: Mandates the use of two-argument ref() for ODS tables to correctly handle schema suffixes.
• Standardizes Looker Table Naming: Requires looker_ prefix for tables destined for Acuantia's Looker instance and specifies looker_prod/looker_dev schemas.
• Integrates Source System Data: Provides patterns for coordinating with CallRail, Dialpad, HubSpot, and Magento data sources.
• Use Case: When developing a new Dataform model that pulls data from CallRail and needs to be exposed to Looker, this Skill ensures the correct ref() syntax, table naming, and schema configurations are applied.

Quick Start

Use the acuantia-dataform skill to define a new Dataform table for customer metrics, ensuring it uses the two-argument ref() for ODS and the looker_ prefix for the schema.