Report for Dataset using Big Query

A_Benincasa

Good Morning, not sure if this is possible, but I want to pull a report for all datasets that use a specific data source, in this case Big Query, is that passible?

ColemenWilson

Yes! There is a Domo Governance dataset report called "Datasets" that has a field called `Type` that has this information. https://domo-support.domo.com/s/article/360056318074?language=en_US#:~:text=The%20Domo%20Governance%20Datasets%20Connector,your%20organization%20is%20using%20Domo.

You would filter the data using the `Type` field to show only datasets who have Big Query as a source. The issue you will run into is dataflows. A dataset could have data from a Big Query data source but it is the output of a dataflow so the dataset type would be 'Dataflow'. To get a complete view into all datasets originating from a Big Query data source would require a lot of ETL work utilizing the Dataflow inputs/outputs report combined with other Domo Gov and Domo Stats reports.

ColemenWilson

Yes! There is a Domo Governance dataset report called "Datasets" that has a field called `Type` that has this information. https://domo-support.domo.com/s/article/360056318074?language=en_US#:~:text=The%20Domo%20Governance%20Datasets%20Connector,your%20organization%20is%20using%20Domo.

You would filter the data using the `Type` field to show only datasets who have Big Query as a source. The issue you will run into is dataflows. A dataset could have data from a Big Query data source but it is the output of a dataflow so the dataset type would be 'Dataflow'. To get a complete view into all datasets originating from a Big Query data source would require a lot of ETL work utilizing the Dataflow inputs/outputs report combined with other Domo Gov and Domo Stats reports.