Count
count.co
  • Getting Started
    • What is Count?
    • Count FAQ
    • Intro to your workspace
    • Example canvases
    • Getting started guides
      • Set up your workspace and projects
        • 1. Review workspace settings
        • 2. Create and organise your projects
      • Canvas orientation
      • Your first ad hoc analysis
        • 1. Examples and templates
        • 2. Build your first queries
        • 3. Create visuals
        • 4. Caching, local cells and scheduling
        • 5. Collaborating with a stakeholder
      • Your first report
        • 1. Examples and templates
        • 2. Filters and control cells
        • 3. Sharing your report
        • 4. Alerts
  • Connect your data
    • Database connection overview
      • Athena
      • Azure Synapse
      • BigQuery
      • Databricks
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
      • Redshift
      • Snowflake
    • Refresh database schema
    • Upload CSV files
    • dbt integration
      • ☁️dbt Cloud integration
      • 👩‍💻dbt Core integration
  • Import & Export
    • Import from other tools
      • Import Miro files
      • Import SQL files
      • Import Google Sheets
      • Import Jupyter notebooks
    • Export code and results
      • Export compiled SQL and Jinja-SQL
      • Export CSV files
      • Export images and PDF files
  • THE CANVAS
    • Navigating the canvas
      • Canvas tool bar
      • Data sidebar
      • Customizing the canvas
    • Canvas objects
      • Cells
      • Text and markdown
      • Shapes and tools
      • Sticky notes
      • Frames
      • Images
      • Embeds
      • Stamps
      • Grouping objects
      • Object order and alignment
      • Locking objects
      • Scaling objects
      • Shared styles
    • Overviews
    • Templates
    • Count AI
    • Alerts and subscriptions
      • Slack integration
    • Keyboard shortcuts
  • Querying data
    • Cells overview
      • Dynamic query compilation engine
    • SQL cells
      • Referencing other cells
      • Jinja templating
      • SQL formatting
    • Python cells
    • Visual and low-code cells
      • Calculations in visuals and low-code cells
      • Joins in visuals and low-code cells
    • Control cells
      • Single and multiple selects
      • Date controls
      • Text, number, and boolean controls
      • Custom control cells
    • Local DuckDB cells
      • DuckDB on the server
    • Query caching and scheduling
    • Manage queries and results
    • Troubleshooting
  • Visualizing data
    • Visualization overview
    • Templated visuals
    • Custom visuals
      • Marks
      • Facet
      • Subplots
      • Style
      • Filters
    • Formatting a visual
      • Axes
        • Secondary Axis
      • Colors and labels
      • Legends
      • Tooltips
    • Column summaries
    • Dynamic text
    • Every Visual Under the Sun
  • Presenting and Reporting
    • Reports and Slides
  • Count Metrics
    • Intro to Count Metrics
    • Build and edit a catalog
    • Views
      • Creating views
      • Customizing views
    • Datasets
      • Creating datasets
    • Save changes to the catalog
      • Catalog validation
      • Version control
    • Exposing catalogs to the workspace
    • Caching in Count Metrics
    • Using the catalog
      • Explore from cell
  • Sharing and Permissions
    • Real-time collaboration
    • Comments
    • Sharing permissions
    • Shared links
    • Embedding canvases
  • History and Versions
    • Version control
    • Duplicating and merging
    • Data snapshots
  • Settings and administration
    • Workspace settings
      • Workspace members
      • Groups
      • Tags
      • Billing
      • Single sign-on (SSO)
        • Okta
        • Entra ID
        • JumpCloud
        • Google
        • Generic OIDC
      • Brand
    • Connection settings
    • Project settings
    • User settings
    • Roles and permissions
  • Quick guides
    • Interactive control guides
      • Date ranges
      • Date groupings
      • Search
      • Select All
  • Resources
    • Join the Slack community
  • Blog
  • Security overview
  • Terms of use
  • Pricing FAQ
Powered by GitBook
On this page
  • 1. Connect your data
  • 2. Set up whitelisting
  • 3. Invite members and set permissions
  • 4. Review core workspace and connection settings
  1. Getting Started
  2. Getting started guides
  3. Set up your workspace and projects

1. Review workspace settings

PreviousSet up your workspace and projectsNext2. Create and organise your projects

Last updated 7 months ago

Before you dive into creating your canvases, there are a few bits of admin it's worth reviewing first. We've listed out these below - in total this should take just a few minutes.

1. Connect your data

To add data to your workspace, you can choose from any of the following options:

2. Set up whitelisting

If you want to quickly add viewers to your canvas, you can whitelist your company's email domain. This means you don't have to explicitly invite everyone you want to share a canvas with.

3. Invite members and set permissions

Whitelisting is great to ensure everyone at your company can join your workspace easily, although it's important to be aware whitelisted users join the workspace as "Members" by default.

If you want to upgrade the level of a user's workspace role, ie for your data analysts/engineers, then you'll want to update their roles in the workspace Members section.

4. Review core workspace and connection settings

In particular, the following settings will become really useful when trying to optimise performance and to reduce query load in your canvases later:

  • Make sure Disable caching of query results is toggled off

  • Set up default caching - we'd suggest at least an hour

Connect your database or data warehouse (see the guides )

Upload a CSV file directly in your canvas (see the guide )

We also support LookerML integrations, which you can learn more about .

You can read more about whitelisting and other workspace settings .

To learn more about workspace roles, check out .

You could also set up at this stage too if you like! (Scale plan only)

There are a number of we'd suggest reviewing at this stage, though you can come back at any point and change these later.

Enable using DuckDB on visuals by default - you can find this option in the for your connection

here
here
here
here
this page
groups
workspace-level settings
settings
Connect your data
Set up whitelisting
Invite members and set permissions
Review workspace settings