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

Try to remove the original "Create-CSV", and after "Add Publish Action" and do it again.

I suppose it's a bug.

Answer 2

Dataprep can't currently read datasets from a different project, including public projects. But there is a way to work around this:

1. In your own project, create a new view - pointing to the desired dataset.
2. Direct Dataprep to the view you created.

Then the view will be available in Dataprep:

And you'll be ready to play:

Answer 3

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.