Skip to main content

Hello,

Is this possible now in latest version? I am using 15.4.0. Requirement is to schedule profiling of specific schema in the database. Or subset of that schema if schema is too big (set of tables).

Thanks in advance.

Hi ​@Ojaswini -- while you can’t schedule profiling of a selected schema from the web app, you could use the following GraphQL query to trigger profiling of selected catalog items programmatically. 

query profiling (
$gid: GID!
$configId: GID!
) {catalogItem(gid: $gid) {
gid
profile(defaultCredential: true, configId: $configId)
{gid}
}
}

Using a ONE Desktop plan, you can export the list of locations (schemas) and the list of catalog items, then filter down to the list of schemas you’re interested in, and then pass the resulting list of catalog items to the JSON call step with the above query. You can further automate this with a scheduled orchestration workflow. Have you created similar plans and workflows before? Let me know if you have questions, I’ll be happy to point you to some more info!


Reply