Self-service analysis & shared metrics — found from sitemap — Cluvio

Cited by

Facts read from this source

• Sql snippets definition Report an error

  “SQL snippets are reusable SQL fragments that can be referenced in queries across many reports, filters, and SQL alerts, while being maintained in a single central definition.”

• Sql snippets categories Report an error

  “There are two categories of SQL snippets: Built-in Snippets — provided by Cluvio with pre-defined behavior. Custom Snippets — freely defined name and replacement text, with optional parameters.”

• Builtin snippets context Report an error

  “Built-in snippets let a SQL query access contextual information about the currently logged-in user or the dashboard displaying the report.”

• Builtin snippets list Report an error

  “[CLUVIO_USER_EMAIL] E-mail address of the logged-in user, or NULL for sharing links and scheduled e-mails. [CLUVIO_USER_FIRSTNAME] First name of the logged-in user, or NULL for sharing links and scheduled e-mails. [CLUVIO_USER_LASTNAME] Last name of the logged-in user, or NULL for sharing links and scheduled e-mails. [CLUVIO_USER_ROLE] 'admin', 'analyst' or 'viewer' for logged-in users, or NULL for sharing links and scheduled e-mails. [CLUVIO_DASHBOARD_NAME] Name of the dashboard on which the report or dynamic filter is displayed. [CLUVIO_DASHBOARD_ID] ID of the dashboard on which the report or dynamic filter is displayed.”

• Snippet nesting Report an error

  “A snippet's replacement text can itself reference other snippets. The constraints are: The maximum chain length is 10 levels deep (A → B → C → … → J). Cycles are not allowed (A → B → A would cause an infinite loop and is rejected).”

• Parameterized snippets Report an error

  “A snippet can accept parameters, making it behave like a function. Specify parameter names (comma-separated) in the Params field of the snippet dialog, then use them inside the snippet text enclosed in square brackets.”

• Snippet filter values limit exemption Report an error

  “Filter values are a separate matter and do not count towards the limit: they are substituted when the query runs, after it has been checked, so the statement that reaches your database can exceed the limit without the query being refused.”

• Snippet management page Report an error

  “All custom snippets are managed from the SQL Snippets overview page, which shows the snippet name, description, and how many reports, filters, or alerts use each snippet. Use the search box to find a snippet by name, description, or text, click the Name header to sort, and page through longer lists with the pagination controls.”

• Snippet actions Report an error

  “Edit — modify the snippet's name, text, params, description, or datasource. Duplicate… — create a copy with all settings pre-filled. The new name is generated automatically by appending a numeric suffix (e.g. revenue_1). Find Usages — search for all reports, filters, and alerts that reference this snippet. Results open in the global search. Delete — permanently remove the snippet.”

• Snippet delete warning Report an error

  “Deleting a snippet that is still referenced by reports, filters, or alerts will cause those queries to fail at runtime. Use Find Usages first to check whether the snippet is in use.”

• Snippet editor sidebar Report an error

  “The SQL Snippets icon in the report editor's left icon bar opens a panel listing the organization's snippets. Each entry shows the snippet's name with its parameters and its description, and the search box narrows the list by name or snippet text. The + button in the panel header creates a new snippet.”

• Snippet autocompletion Report an error

  “In the report SQL editor, snippet names appear in the auto-complete suggestions. Select a suggestion to insert the snippet reference.”

• Snippet tooltip Report an error

  “Hovering over a snippet reference in the SQL editor shows a tooltip containing the snippet text and description, so you can verify what will be substituted without leaving the editor.”

• Snippet extract and inline Report an error

  “To extract part of an existing query into a snippet, select the SQL text you want to extract and choose Create Snippet from the editor's expanded Run menu.”

• Snippet datasource selection Report an error

  “The Datasource selection only affects code completion in the SQL editor — it has no bearing on where the snippet can be used at runtime.”

• Snippet name characters Report an error

  “Names may only contain letters, digits, and the characters +, *, _, - (spaces and most special characters are not allowed).”

1 fact read from this page is not shown because it could not be confirmed on the page as captured.

Scores citing this record

• The Data Analyst Self-service analysis & shared metrics
• The Finance Controller Self-service analysis & shared metrics
• The IT Administrator Self-service analysis & shared metrics
• The Managing Director Self-service analysis & shared metrics
• The SaaS Product Lead Self-service analysis & shared metrics
• The Skeptic Self-service analysis & shared metrics
• The Skeptic Access control, administration & portability