Closed Datayama38 closed 1 week ago
The changes encompass various updates across the dbt project, including the introduction of new configuration files for SQLFluff and a user profile, modifications to existing YAML files, and the addition of multiple SQL models and views. Key adjustments include refined logging practices, enhanced model definitions, and improved data source configurations, all aimed at optimizing the project's structure and functionality.
Files | Change Summary |
---|---|
dbt/.gitignore | Changed logging directory ignore pattern from logs/ to logs/* . |
dbt/.sqlfluff, dbt/.sqlfluffignore | Introduced SQLFluff configuration for dbt with PostgreSQL dialect and a new ignore file for specific directories. |
dbt/dbt_project.yml | Updated string delimiters and added model configurations under models section. |
dbt/justfile | Added a Just build tool configuration for managing dbt commands. |
dbt/macros/generate_schema_name.sql | Introduced a macro for generating schema names based on custom and default parameters. |
dbt/models/geo/_view_evolution_com.yml | New model configuration for view_evolution_com with defined columns. |
dbt/models/geo/view_evolution_com.sql | New SQL file defining a materialized view for geographic perimeter evolution. |
dbt/models/observatoire/*.sql | Multiple new SQL files defining incremental materialized views for carpool and transportation metrics. |
dbt/models/sources/*.yml | New YAML files defining data source configurations for carpool, company, geo, and operator tables. |
dbt/profiles/.user.yml | Introduced a user profile configuration file with a unique identifier. |
dbt/profiles/profiles.yml | New profiles configuration file defining connection settings for prod and dev targets. |
sequenceDiagram
participant User
participant DBT
participant SQLFluff
participant Database
User->>DBT: Execute dbt command
DBT->>SQLFluff: Lint SQL files
SQLFluff-->>DBT: Return linting results
DBT->>Database: Run transformations
Database-->>DBT: Return results
DBT-->>User: Display results
🐰 "Oh, what a change in the land of dbt,
With new files and models, oh so neat!
SQLFluff joins the fun,
Linting code, oh what a run!
Profiles for users, all set to greet,
In this data garden, we hop on our feet!" 🐇✨
Thank you for using CodeRabbit. We offer it for free to the OSS community and would appreciate your support in helping us grow. If you find it useful, would you consider giving us a shout-out on your favorite social media?
Summary by CodeRabbit
New Features
.sqlfluffignore
to streamline linting by excluding unnecessary directories.dbt_project.yml
for better model organization.Bug Fixes
.gitignore
to track thelogs
directory while ignoring its contents, improving version control management.Documentation
Chores