Skip to main content
Question

How to schedule profiling of specific schema in the database Or subset of that schema if schema is too big.

  • May 19, 2025
  • 1 reply
  • 17 views

Forum|alt.badge.img+4

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.

Lisa Kovalskaia
Ataccamer
Forum|alt.badge.img+3

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings