Move raw → intermediate schema using dbt for "daily_weekly_attendance" table.

[akshatasatpute]

Set up dbt in a separate repository and configure it with the staging database.
Define the raw table as a source inside sources.yml and create dbt models to add the "daily_weekly_attendance" table in the intermediate schema.
Apply prefix-based naming conventions for the schema during the initial ingestion of the model.

Steps:

1. Create a new repository and initialize a dbt project.
2. Configure profiles.yml with staging DB connection:
   *Add Postgres connection details.
   *Set schemas: raw (source), prefix_intermediate (output).
3. Define raw source in schema.yml.
4. Create the intermediate model: daily_weekly_attendance.sql

Run and test models (dbt run, dbt test).