This project is based in dbt starter project (generated by running dbt init)
Try running the following commands:
- dbt run
- dbt test
A project includes the following files:
- dbt_project.yml: file used to configure the dbt project. If you are using dbt locally, make sure the profile here matches the one setup during installation in ~/.dbt/profiles.yml
- *.yml files under folders models, data, macros: documentation files
- csv files in the data folder: these will be our sources, files described above
- Files inside folder models: The sql files contain the scripts to run our models, this will cover staging, core and a datamarts models. At the end, these models will follow this structure:
After having installed the required tools and cloning this repo, execute the following commnads:
- Change into the project's directory from the command line:
$ cd [..]/taxi_rides_ny - Load the CSVs into the database. This materializes the CSVs as tables in your target schema:
$ dbt seed - Run the models:
$ dbt run - Test your data:
$ dbt testAlternative: use$ dbt buildto execute with one command the 3 steps above together - Generate documentation for the project:
$ dbt docs generate - View the documentation for the project, this step should open the documentation page on a webserver, but it can also be accessed from http://localhost:8080 :
$ dbt docs serve
- Learn more about dbt in the docs
- Check out Discourse for commonly asked questions and answers
- Join the chat on Slack for live discussions and support
- Find dbt events near you
- Check out the blog for the latest news on dbt's development and best practices