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.
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
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!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.