Get Help
CAT DOCS
Browse release-notes
CAT DOCS
Get Started
What is CAT
CAT use-cases
How CAT works
Start using CAT
Full documentation
What's new
Compare plans
More
Releases
Terms of use
Privacy policy
Refund policy
Roadmap
What is CAT
Introduction
CAT use-cases
CAT in your infrastructure
Test examples
Need more info?
Get Started
How to get started?
CAT Studio
What is CAT studio?
Why to follow this tutorial?
Install CAT studio
Explore sample project
Create first test
CAT CLI
What is CAT CLI?
Why to follow this tutorial?
Install CAT CLI
Explore sample project
Create first test
CAT PowerShell module
What is CAT PowerShell module?
Why to follow this tutorial?
Install PowerShell module
Explore sample project
Create first test
CAT Python module
What is CAT Python module?
Why to follow this tutorial?
Install Python package
Explore sample project
Create first test
What next?
Reference
Basics
Introduction
How CAT works
CAT Tools
Project file
Introduction
Complete example
Naming conventions
Lists — implicit and explicit
Root settings
Environment variables
Data sources
Properties
Technologies
Providers
Introduction
Overview
ClickHouse@1
Csv@1
Csv@2
Dax@2
Excel@1
Excel@2
MySql@1
Odbc@1
Oracle@1
Postgres@1
PowerBI@2
Snowflake@1
SqlServer@2
Teradata@1
Yaml@1
CsvOleDB@1
Dax@1
ExcelOleDB@1
PowerBI@1
SqlServer@1
Queries
Properties
Tests
Properties
Templates
Expectations
Introduction
Overview
Set is empty
Set is not empty
Set row count
Sets match
Contains
Order and key
Tolerance
Results
Failure message
Outputs
Introduction
Overview
Settings
Properties
JSON
YAML
XLSX
JUnit
TRX
Database outputs
SQL Server
PostgreSQL
Oracle
CAT Studio
Introduction
Installation
CAT Studio Interface
Project
Data Sources
Tests
Queries
Variables
Settings
Keyboard Shortcuts
CAT Pilot
CAT CLI
Introduction
Installation
run
show
open
exec
new
instance
docs
CAT PowerShell module
Introduction
Installation
Close-CatProject
Get-CatDataSource
Get-CatDataSourceList
Get-CatInstance
Get-CatProject
Get-CatProjectTemplate
Get-CatSession
Get-CatTest
Get-CatTestList
Get-CatTestResult
Get-CatTestResultSummary
Invoke-CatCommand
Invoke-CatProject
Invoke-CatTest
New-CatProject
Open-CatProject
Set-CatInstance
Show-CatProject
Show-CatTestResultSummary
CAT Python module
Introduction
Installation
close_project
get_data_source_lists
get_data_sources
get_instance
get_project_templates
get_test_lists
get_test_results
get_test_results_summary
get_tests
invoke_command
invoke_project
invoke_tests
new_project
open_project
set_instance
Integrations
CAT Portal
How-to guides
Test patterns
Compare data across systems
Test incremental loads
Test schemas and metadata
Test compliance rules
Smoke tests with set is not empty
Find problems with set is empty
Differences between systems
Which expectation when
My expectation does not exist
Organize and run tests
Create a project file
Organize a growing test base
Store definitions in a database
Generate tests from metadata
Use environment variables
Work with secrets
Run your tests
Run tests in parallel
Data platforms
Power BI
Test Power BI
Test a Power BI Desktop file
Test a semantic model in a workspace
Get the DAX query behind a visual
Test measures
DAX for SQL people
Test Databricks
CAT in Databricks notebooks
Test Microsoft Fabric
Test Dataverse
Test CSV and Excel files
Query CSV and Excel data with DuckDB SQL
Pipelines and schedulers
CAT in Azure DevOps Pipelines
CAT in Azure DevOps Classic Releases
CAT in GitLab
CAT in GitHub Actions
CAT in Jenkins
CAT in SQL Server Agent
CAT in Windows Task Scheduler
CAT in cron
Licensing and admin
Get a CAT license
Apply a license key
Manage CAT Pilot with Group Policy
Run CAT on Linux
Troubleshoot CAT
Release notes
Recent releases
CAT 2.4
CAT 2.3
CAT 2.2
CAT 2.1
CAT 2.0
CAT 1.15.0
CAT 1.14.0
Archive
CAT 1.13.0
CAT 1.12.0
CAT 1.11.0
CAT 1.10.0
CAT 1.9.0
CAT 1.8.0
CAT 1.7.0
CAT 1.6.0
CAT 1.5.0
CAT 1.4.0
CAT 1.3.0
CAT 1.2.0
CAT 1.1.0
CAT 1.0.0
CAT 0.28.0
CAT 0.27.0
CAT 0.26.0
CAT 0.25.0
CAT 0.24.0
CAT 0.23.0
CAT 0.22.0
CAT 0.21.0
CAT 0.20.0
CAT 0.19.0
CAT 0.18.0
CAT 0.17.0
CAT 0.16.0
CAT 0.15.0
CAT 0.14.0
CAT 0.13.0
CAT 0.12.0
CAT 0.11.0
CAT 0.10.0
CAT 0.9.1
CAT 0.9.0
CAT 0.8.0
CAT 0.7.0
CAT 0.6.0
CAT 0.5.0
CAT 0.4.0
CAT 0.3.0
CAT 0.2.0
CAT 0.1.0
CAT 0.0.2
CAT 0.0.1
CAT 0.0.2
Compared to CAT 0.0.1, this version contains only one fix:
The
installer
now works with
both PowerShell 5 and newer versions of PowerShell.
(#16002)
← CAT 0.1.0
CAT 0.0.1 →