data-diff icon indicating copy to clipboard operation
data-diff copied to clipboard

Compare tables within or across databases

Results 113 data-diff issues
Sort by recently updated
recently updated
newest added
trafficstars

``` data_diff.databases.base.ConnectError: Exception when trying to execute SQL code: SELECT column_name, data_type, 6 as datetime_precision, 38 as numeric_precision, 9 as numeric_scale FROM my_table_name.INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'booking' AND table_schema =...

I have a database with multiple columns as a primary key. Is there any way to specify multiple columns as a key?

DuckDB is an in-process database. You typically create it as a session, then discard it once you're done (though not the only way to use it) [https://duckdb.org](https://duckdb.org) It's awesome for...

enhancement
new-db-driver

I was browsing through the list of supported databases on your readme and noticed MSSQL is not listed although it can be found in databases.py. Just wondering if this was...

performance
new-db-driver
stale_immune

Getting the following error trying run a diff after installing the postgres driver ![image](https://user-images.githubusercontent.com/1820651/181296619-a8b5287e-7b83-4b6f-84f5-888f3446dff3.png) Think it just needs to be added to requirements for the driver.

We need to [use encrypted secrets](https://docs.github.com/en/actions/security-guides/encrypted-secrets) and then only [trigger manually](https://docs.github.com/en/actions/using-workflows/events-that-trigger-workflows#branch_protection_rule) and on the master branch. The reason we can't always run it, is because someone could PR malicious code.

quality
dba

## Motivation I transfer Spanner tables to BigQuery using data engineering tools. I would like to make sure if data in BigQuery is completely the same as Spanner.

new-db-driver

We do a lot of data ingestion/syncing from Firestore and MongoDB into BigQuery. Any plans in the roadmap for these kinds of DBs? I assume in order to support other...

new-db-driver

Hi, Is [Athena](https://aws.amazon.com/athena/) in the pipeline to be added as a Supported Databases? Regards Johan

new-db-driver

Hi, do you have a plan in your roadmap to add support for DB2 databases? Thanks, Carlos.

new-db-driver