I am trying to do the Audit log report for checking user's workbook connect our Database which table. Our source database is DB2 and user would use db2 connector to connect our DB2 when they create the datasource object. May I ask does any Tableau Repository table I could find this information in Postgre DB ?
Hi, your best option is to query the metadata api. A basic query may look like:
query databases{
databases (filter: {connectionType: "db2"}){
name
connectionType
tables{
name
downstreamDatasources{
name
projectName
}
}
}
}
You get a result with something like:
{
"data": {
"databases": [
{
"name": "Rfam",
"connectionType": "db2",
"tables": [
{
"name": "author",
"downstreamDatasources": [
{
"name": "Test MyDb2 Bridge",
"projectName": "default"
}
]
}
]
}
]
}
}
If this post resolves the question, would you be so kind to "Accept this Answer"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Tableau Ambassador
