Study guide
12.2 Row-Level Security, Schedules, Subscriptions & Alerts
Salesforce Certified Tableau Data Analyst Exam
Track your progress as you read
Finished sections get a check mark.
1 Chapter 1: Connecting to Data & The Logical Data Model
1.1 Data Connections: Live Connections vs. Hyper Extracts 1.2 The Tableau Data Model: Relationships vs. Physical Joins 1.3 Combining Data: Data Blending vs. Cross-Database Joins
2 Chapter 2: Tableau Prep Builder & Data Wrangling
2.1 Tableau Prep Architecture & Data Cleaning 2.2 Reshaping Data in Prep: Pivots, Splits & Wildcard Unions 2.3 Joins, Aggregations & Output Destinations in Prep
3 Chapter 3: Data Quality, Metadata & Field Configuration
3.1 Data Types, Roles, Organization & Default Properties 3.2 In-Desktop Data Cleaning: Splits, Data Interpreter & Source Replacement 3.3 Managing Slowly Changing Dimensions & Data Quality Warnings
4 Chapter 4: Tableau Fundamentals & Calculations
4.1 Dimensions vs. Measures & Discrete vs. Continuous 4.2 Mastering Dates: Discrete Date Parts vs. Continuous Date Truncations 4.3 Calculations: Logic, Strings, Nulls & Type Conversion 4.4 Aggregation Rules, Granularity & Dealing with the Asterisk (ATTR)
5 Chapter 5: Level of Detail (LOD) Expressions
5.1 Level of Detail Architecture & Scoping Syntax 5.2 FIXED LOD Expressions: Scoping & Baseline Benchmarks 5.3 INCLUDE & EXCLUDE LOD Expressions: Dynamic Granularity 5.4 Real-World LOD Patterns: Cohorts, First/Last Dates & Binning
6 Chapter 6: Table Calculations & Directionality
6.1 Table Calculation Mechanics: Addressing vs. Partitioning 6.2 Essential Table Calculations: Running, Window & Percent of Total 6.3 Navigation & Ranking Functions: LOOKUP, INDEX & RANK 6.4 Secondary & Nested Table Calculations: Multi-Level Scoping
7 Chapter 7: Statistical Analytics, Filtering & Order of Operations
7.1 The Tableau Order of Operations: From Extract to Display Filters 7.2 Sets, Set Actions & Combined Sets vs. Groups 7.3 Parameters, Parameter Actions & Dynamic What-If Analysis 7.4 Analytics Pane: Totals, References, Trends & Forecasts
8 Chapter 8: Chart Types & Comparative Visualizations
8.1 Comparison Visualizations: Bar Charts, Highlight Tables & Bullet Graphs 8.2 Part-to-Whole & Correlation Charts: Treemaps, Scatter Plots & Bubbles 8.3 Trend & Distribution Visualizations: Dual-Axis, Combos & Histograms
9 Chapter 9: Advanced Visualizations & Spatial Analysis
9.1 Specialized Visualizations: Waterfall, Gantt, Sparklines & Bump Charts 9.2 Spatial Data & Mapping: Geographic Layers & Spatial Functions 9.3 Visual Polish: Custom Palettes, Annotations & Viz in Tooltip
10 Chapter 10: Dashboard Design & Interactive Actions
10.1 Dashboard Layout, Devices & Visibility 10.2 Filter, Highlight & URL Actions 10.3 Advanced Interactivity: Parameter, Set & Navigation Actions 10.4 Stories & Visual Storytelling: Sequencing Analytical Narratives
11 Chapter 11: Tableau Server & Cloud: Architecture & Publishing
11.1 Tableau Server & Cloud: Sites, Projects, Roles & Permissions 11.2 Publishing Workbooks, Data Sources & Flows
12 Chapter 12: Data Governance, Security & Operations
12.1 Certification, Data Quality, Lineage & Permissions 12.2 Row-Level Security, Schedules, Subscriptions & Alerts
12.2 Row-Level Security, Schedules, Subscriptions & Alerts
Key Takeaways Explain This Topic AI
Dynamic RLS commonly relates governed entitlements to analytical data and filters with the authenticated Tableau identity.
Priority 1 is highest and priority 100 lowest; priority affects queue selection but does not guarantee completion time.
Extract refresh tasks are suspended after five consecutive failures by default, and Tableau Server administrators can configure the threshold.
Subscriptions deliver recurring snapshots, while data-driven alerts evaluate conditions on supported continuous numeric axes.
Custom views save an interaction state without copying or changing the underlying workbook.
Last updated: September 2026
12.2 Row-Level Security, Schedules, Subscriptions & Alerts
Publishing a view does not mean every viewer should see every row. Row-level security (RLS) restricts records according to the authenticated user. Operational features then keep extracts current and deliver views or notifications at the right time.
Static user filters
An author can create a user filter that maps Tableau users or groups to allowed members of a dimension. This can be practical for a small and stable population. The weakness is maintenance: staffing changes and new dimension members may require the mapping to be edited and content to be republished. Test with actual users because an administrator's unrestricted view can conceal a faulty mapping.
Dynamic row-level security
A scalable pattern stores entitlements in governed data. An entitlement table might contain Username and TerritoryKey, with one row for each allowed territory. Relate or join it to the analytical data on TerritoryKey, then apply a data source filter such as USERNAME() = [Username]. ISMEMBEROF can implement carefully governed group exceptions. Because entitlements are data, authorized administrators can update assignments without editing every workbook.
The relationship design must preserve correct grain. A physical join can duplicate fact rows when one person has multiple entitlements or when multiple people share a territory. Relationships can preserve table grains, while a database-native security policy or Tableau virtual connection can centralize security further when the environment supports it. Whichever model is used, test an ordinary user, a manager, an unauthorized user, null keys, changed assignments, and extract refresh behavior.
USERNAME returns the signed-in Tableau identity. Entitlement values must use the same format and case behavior expected by the environment. FULLNAME is a display name and is generally less stable as a security key. Do not embed individual passwords as an RLS strategy.
Extract schedules and priority
Published extracts become stale until refreshed. A full refresh rebuilds the extract. An incremental refresh processes qualifying new or replacement-range records according to its key configuration, so the design must account for historical changes and deletions.
On Tableau Server, schedules and tasks are administered for background processing. Priority values run from 1 through 100, with 1 the highest priority. Priority influences which pending task is selected first; it does not guarantee an exact completion time because duration, concurrency, failures, and available Backgrounder capacity still matter.
Tableau suspends an extract refresh task after repeated failures—five consecutive failures by default. On Tableau Server, administrators can configure the threshold. Resolve credentials, network access, schema changes, or resource limits before resuming the task. Monitor the latest successful refresh rather than assuming a schedule proves freshness.
Subscriptions
A subscription delivers an image or PDF snapshot and link for a view or workbook on a configured schedule, subject to site settings and permissions. Where available, delivery after data refresh can prevent a subscription from sending before its extract is updated. The recipient sees content according to their access and the subscription's supported execution context. Use subscriptions for recurring delivery, not for conditional threshold detection.
Data-driven alerts
A data-driven alert monitors a supported continuous numeric axis in a published view and notifies recipients when the configured condition is met. If the alert command is unavailable, verify that the view has a continuous numeric axis, alerts are enabled, the user has access, and the data can be refreshed. A text table composed only of discrete headers does not supply the required axis.
An alert answers whether a measure crossed a condition. It is not a data quality warning, permission rule, or substitute for a subscription. Use a dashboard subscription for a weekly snapshot and an alert for a threshold such as inventory below a limit.
Custom views
Custom views save a viewer's filter, sort, selection, and zoom state for an existing view. A user can make a custom view the default and may share it when permitted. The custom view does not copy the workbook or change its underlying data. It is useful when a regional manager repeatedly opens the same governed dashboard filtered to a particular business unit.
Operational decision table
- Requirement Feature
- Restrict rows by signed-in identity Dynamic RLS with entitlements or another governed security model
- Rebuild or incrementally update a .hyper snapshot Extract refresh task
- Deliver a recurring view snapshot Subscription
- Notify when a measure meets a condition Data-driven alert
- Reopen a preferred filter and sort state Custom view
- Warn consumers that data is stale or under maintenance Data quality warning
- Verification checklist
Use groups and governed entitlements rather than hardcoded per-user logic where scale requires it.
Validate row counts and totals for several identities, including a user with no entitlement.
Confirm the published credential and network path can support unattended refresh.
Choose full or incremental refresh based on how inserts, updates, and deletions must be captured.
Assign priority according to business importance without promising an exact finish time.
Monitor failure notifications and the last successful run.
Test subscriptions, alerts, and custom views as representative recipients.
Security and operations must be verified together. A perfectly filtered workbook with a stale extract can still lead to a wrong decision, while a current extract with faulty entitlements can expose protected data.