Datasets (Deprecated)

Model your data in Sigma using datasets, or collections of data based on tables in your CDW or DBMS.

Datasets function as centralized, shareable data definitions and can include aggregations and other data manipulations. Admins define datasets that are used in workbook analyses as sources for visualizations, tables, and pivot tables.

Workbooks inherit all changes applied to underlying datasets, ensuring consistent, reliable metric calculations. When metric logic requires an update, you can apply the change in one location (the dataset), and all applicable workbooks automatically inherit and reflect the updated calculations.

Modeling data with datasets

• Create and manage datasets
• Create a dataset from SQL
• Use the dataset worksheet
• Configure columns
• Add links
• Join data

Sharing and permissions for datasets

• Permission types
• Share a dataset
• Modify or revoke access
• Respond to a request for access to content

Manage data in datasets

• Controls
• Parameters
• Filters
• Totals
• Upload CSVs
• CLS

Advanced modeling

• Examine dataset queries
• Dataset lineage
• Dataset warehouse views
• Dataset materialization
• Best practices

API endpoints

• List datasets
• Get a dataset
• List dataset sources
• Materialize a dataset
• List materializations for a dataset
• Get grants for a dataset
• Grant permissions on a dataset
• Delete a permission granted on a dataset