Unable to access database irs_990 for table irs_990_reporting Dataprep Google Cloud

Question

I am having problems with Google DataPrep when I am trying to create a table. There is a message "Unable to access database irs_990 for table irs_990_reporting".

You, guys, can see all the steps here.

https://docs.google.com/document/d/1u5rFyg7nMv4YJ_u_ASjpmVdkusJARTN2gCtBj8zr4T0/edit?usp=sharing

---

Thanks for all your answers, but I still have this problem. I tried all your suggestions, but it still doesn't work. I have just one project, one flow, one dataset and one job. I created a new flow, to make it more clear.

https://docs.google.com/document/d/1CU6CU_-plQ9Id1etj5nLbJ6iKSVPQURZISk6YYohAM0/edit?usp=sharing

Here in this image, you can see some permissions.

It is alive! It is alive! It is alive!

Will's answer solve this issue, I don't understand why it happened, so if you guys have some answer to specify, it would be perfect.

Thanks, Will

Answer 1

I had this same (similar?) issue. I was able to fix it by creating an empty table in destination BQ dataset. That seemed to allow the dataprep to then create its own table.

I found this solution by looking at the big query logs in stackdriver.