Skip to main content

Canot: prove you can leave

Prove you can leave.
An exit exercise for your data platform, run inside your own accounts.

license Apache-2.0 python 3.11+ no telemetry Snowflake, BigQuery

canot.io · Documentation · Measured discrepancies · Try it · Why


▶ Try it

uvx canot demo

No account, no data: Canot generates TPC-H, the standard database benchmark (8 tables, 22 queries, up to 1 GB of data at scale factor 1), copies it to Apache Iceberg, compares everything, replays TPC-H queries on both sides and writes a signed evidence report. A 100 MB version by default (a few seconds); uvx canot demo --sf 1 runs scale factor 1, about 1 GB (around 20 seconds on a laptop). The command prints the two commands it runs (canot demo-data, then canot drill): copy them to change the destination, for example uvx canot demo aws:eu-west-3 --bucket MY-BUCKET.

uvx canot demo copies the 8 TPC-H tables, compares everything and flags a discrepancy

Result: 7 tables out of 8 with identical content, 3 queries out of 4 returning the same result. The discrepancy comes from a nanosecond timestamp column added by Canot: Iceberg v2 reduces it to microsecond precision. This is the kind of discrepancy you want to find before you leave.

▶ Connectors

canot connectors lists them with what each can do (inventory, export, evidence) and whether it has been validated.

Connector Source URL Status
Snowflake snowflake://ACCOUNT/DATABASE available, tested: full scan, copy, comparison, query replay
BigQuery bigquery://PROJECT/DATASET available, tested: full scan, copy, comparison, query replay
dbt dbt://PROJECT_PATH available, tested: scan of the project files, replay of the models (canot replay-dbt)
DuckDB file.duckdb available, tested: light scan, copy, comparison
Databricks databricks://HOST/HTTP_PATH?catalog=… written, not yet validated on a real account
Microsoft Fabric / Azure Synapse, Amazon Redshift, Teradata, Oracle, SAP Datasphere, ClickHouse on the roadmap, no connector yet

Running Canot on a platform without a connector prints how to ask for it. A connector is written and validated with you, on your own account: tell us what you run.

🧭 Why

The imbalance The pressure The hidden risk
Snowflake and Databricks offer free tools to move in. Nobody offers the tool that checks the way out. DORA requires financial entities to have a tested exit plan. In France, data transfer when switching cloud providers already costs €0; on 12 Jan 2027, all switching charges disappear (EU Data Act). The work remains: duration, discrepancies and what does not move as-is stay unknown until someone actually runs the exit.

Canot runs the rehearsal. You stay with your provider.

▶ On your data

uvx canot scan "snowflake://MY_ACCOUNT/MY_DATABASE?user=MY_USER"    # read-only assessment
uvx canot drill "snowflake://MY_ACCOUNT/MY_DATABASE?user=MY_USER" ./iceberg   # full exit exercise, to a local folder

Exit to your own infrastructure (folder, NAS, self-hosted S3 storage), commands, permissions and agent access (MCP): see the documentation. uvx canot connectors lists the supported platforms, what Canot can do on each (inventory, export, evidence) and whether the connector is tested. Canot is not a certification: it produces a dated record of measurements on the scope you ran. The website, canot.io, explains the rest.

Apache-2.0 · No trackers, no telemetry · Security policy · q4o

Metadata

Release files for canot 0.3.3

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for canot 0.3.3
File Size Uploaded Provenance
canot-0.3.3.tar.gz 1.1 MB Without provenance Details

Built distribution (wheel)

Table of built distributions (wheels) for canot 0.3.3
File Interpreter ABI Platform
canot-0.3.3-py3-none-any.whl Python 3 none any Details

Total release size: 1.3 MB

Release files / canot-0.3.3.tar.gz

Download URL canot-0.3.3.tar.gz
Size 1.1 MB
Tags Source
SHA-256 checksum
How to use checksums
b3a38e5e7612e07a322257e43b650a32f050125ea91f15a97dfb0e11b9c39bf2
BLAKE2b-256 checksum
How to use checksums
a8b0e86ec2eb3d144d0ac703d58812bca602e1a0c6c609847275bb8add6048d8
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.2 {"installer":{"name":"uv","version":"0.11.2","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Release files / canot-0.3.3-py3-none-any.whl

Download URL canot-0.3.3-py3-none-any.whl
Size 189.3 kB
Tags Python 3
SHA-256 checksum
How to use checksums
5cbdf671a6408bfa066d098297d9b1aa26695f5749010f3c2021cb55d4dade02
BLAKE2b-256 checksum
How to use checksums
7ea182f5087253e5114a51485248e2b0c1dc18fd8fa81d5fc546382af0682819
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via uv/0.11.2 {"installer":{"name":"uv","version":"0.11.2","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

Security for canot 0.3.3

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page