dbt Fundamentals example data: invalid project ID

Help
1

all - I am doing the dbt fundamentals training and I am running into an issue with stripe.payment part. Keep getting an error: Database Error in rpc request (from remote system.sql) Invalid project ID ‘dbt-tutorial.jaffle_shop’. Project IDs must contain 6-63 lowercase letters, digits, or dashes. Some project IDs also include domain name separated by a colon. IDs must start with a letter and may not end with a dash.

select * from `dbt-tutorial.jaffle_shop.customers`; --this works fine. preview shows table
select * from `dbt-tutorial.jaffle_shop.orders`; --this works fine. preview shows table
select * from `dbt-tutorial.stripe.payment`; --error, mention above. I have tried every possible sequence of syntax, but nothing. Even Ty from support desk is looking into it. no resolution yet

Any ideas?

1 Like
2

all - update.

looking in my setup from gpc I saw this: dbt-tutorial.stripe.payment. I went I tested this in dbt and a preview table shows. but when I add the ID: select * from dbt-tutorial.jaffle_shop.stripe.payment. The error shows again.

3

update: so this is getting confusing now.

*my SQL code shows a table when you click preview, but when you dbt RUN the code this is the error: *
21:07:58 Database Error in model staging_payments (models/staging/stripe/staging_payments.sql)

  • Invalid project ID ‘dbt-tutorial.jaffle_shop’. Project IDs must contain 6-63 lowercase letters, digits, or dashes. Some project IDs also include domain name separated by a colon. IDs must start with a letter and may not end with a dash.*
  • compiled Code at target/run/jaffle_shop/models/staging/stripe/staging_payments.sql*
    21:07:58 Sending event: {‘category’: ‘dbt’, ‘action’: ‘run_model’, ‘label’: ‘1bd10df9-bc01-4e40-9766-4ecdd4849477’, ‘context’: [<snowplow_tracker.self_describing_json.SelfDescribingJson object at 0x7f31a2f86b80>]}
    21:07:58 1 of 1 ERROR creating sql view model dbt_gorchard.staging_payments … [ERROR in 1.03s]
    21:07:58 Finished running node model.jaffle_shop.staging_payments
4

Hey, were you able to figure out the issue? I am seeing the same error.

1 Like
5

Same issue here. Did you solved it? In my case i am using Big Query.