[Feature] sc-32422 Add option to select dbt profile and target

[kentwelcome]

PR checklist

• [x] Ensure you have added or ran the appropriate tests for your PR.
• [x] DCO signed

What type of PR is this? Feature request from GitHub issue #898

What this PR does / why we need it:

• Add options --dbt-profile and --dbt-target for init, diagnose and `run commands
• Users can specific the DBT profile or target when executing the run command.

Which issue(s) this PR fixes: sc-32422

898

Special notes for your reviewer:

Does this PR introduce a user-facing change?:

[codecov[bot]]

Codecov Report

Merging #903 (4a6ddde) into main (75d3fda) will increase coverage by 0.00%. The diff coverage is 85.96%.

@@           Coverage Diff           @@
##             main     #903   +/-   ##
=======================================
  Coverage   48.00%   48.01%           
=======================================
  Files          77       77           
  Lines       10693    10714   +21     
=======================================
+ Hits         5133     5144   +11     
- Misses       5560     5570   +10     

Files	Coverage Δ
piperider_cli/cli.py	67.59% <100.00%> (+0.40%)	:arrow_up:
piperider_cli/cli_utils/run_cmd.py	92.55% <100.00%> (+0.16%)	:arrow_up:
piperider_cli/initializer.py	45.80% <100.00%> (ø)
piperider_cli/runner.py	53.60% <100.00%> (+0.44%)	:arrow_up:
piperider_cli/cloud/__init__.py	25.69% <0.00%> (-0.09%)	:arrow_down:
piperider_cli/validator.py	22.00% <40.00%> (-0.15%)	:arrow_down:
piperider_cli/configuration.py	60.21% <83.33%> (-1.36%)	:arrow_down:

... and 1 file with indirect coverage changes

:mega: We’re building smart automated test selection to slash your CI/CD build times. Learn more