[CT-61] [Bug] interactive dbt init allows illegal project names

[joellabes]

Is there an existing issue for this?

• I have searched the existing issues

Current Behavior

I just set up a sandbox project for myself using the new interactive dbt-init. When it asked what I wanted to call it, I chose joel-sandbox.

When I ran dbt debug, it failed because 'joel-sandbox' does not match '^[^\\d\\W]\\w*$'.

Expected Behavior

dbt init should at minimum include the "lowercase and underscores only" rule, and really should also validate that the input conforms.

Steps To Reproduce

No response

Relevant log output

Project loading failed for the following reason:
Runtime Error
  at path ['name']: 'joel-sandbox' does not match '^[^\\d\\W]\\w*$'

Error encountered in /Users/joel/Documents/GitHub/joel-sandbox/dbt_project.yml

Environment

- OS: MacOS
- Python: 3.8.10
- dbt: 1.0.0

What database are you using dbt with?

snowflake

Additional Context

No response

[iknox-fa]

Thanks for the bug report @joellabes! We'll get this sorted ASAP.

[amirkdv]

@joellabes I took a stab at this! PR is ready for review

p.s: first time dbt contributor 🤓

[joellabes]

That's awesome @amirkdv! Thanks for the contribution.

I'll leave the Core team to handle the review 😁

[leahwicz]

@ChenyuLInx let's remember to backport this as well

[bendiktv2]

The tutorial needs to be updated to use a valid project name: https://docs.getdbt.com/tutorial/create-a-project-dbt-cli

[jtcohen6]

@bendiktv2 Good call! Could I ask you to open a quick issue or PR at https://github.com/dbt-labs/docs.getdbt.com? If you scroll to the bottom of that page, there's also an "Edit this page" link that will open the appropriate file in GitHub's web editor.

[bendiktv2]

@jtcohen6 , please see #1155 :)

[bendiktv2]

Sorry, PR is in other repo. Here is the correct link: dbt-labs/docs.getdbt.com#1155

[jtcohen6]

Thank you!! :)