Data diffs
Get a data diff
GET
/
api
/
v1
/
datadiffs
/
{datadiff_id}
Path Parameters
datadiff_id
integer
requiredQuery Parameters
poll
any
Response
200 - application/json
data_source1_id
integer
requireddata_source2_id
integer
requiredkind
enum<string>
requiredAn enumeration.
Available options:
in_db
, cross_db
pk_columns
string[]
requiredaffected_columns
string[]
algorithm
enum<string>
An enumeration.
Available options:
join
, hash
, hash_v2_alpha
, fetch_and_join
archived
boolean
default: falsebisection_factor
integer
bisection_threshold
integer
ci_base_branch
string
ci_pr_branch
string
ci_pr_num
integer
ci_pr_sha
string
ci_pr_url
string
ci_pr_user_display_name
string
ci_pr_user_email
string
ci_pr_user_id
string
ci_pr_username
string
ci_run_id
integer
ci_sha_url
string
column_mapping
array
columns_to_compare
string[]
created_at
string
data_app_metadata
object
data_app_type
string
data_source1_session_parameters
object
data_source2_session_parameters
object
diff_progress
object
diff_stats
object
diff_tolerance
number
diff_tolerances_per_column
object[]
done
boolean
default: falsedownload_limit
integer
exclude_columns
string[]
execute_as_user
boolean
file1
string
Required string length:
1 - 65536
file2
string
Required string length:
1 - 65536
filter1
string
filter2
string
finished_at
string
id
integer
include_columns
string[]
materialization_destination_id
integer
materialize_dataset1
boolean
materialize_dataset2
boolean
materialize_without_sampling
boolean
default: falsemonitor_error
object
monitor_state
enum<string>
An enumeration.
Available options:
ok
, alert
, error
, learning
, checking
, created
, skipped
per_column_diff_limit
integer
purged
boolean
default: falsequery1
string
query2
string
result
enum<string>
Available options:
error
, bad-pks
, different
, missing-pks
, identical
result_revisions
object
result_statuses
object
runtime
number
sampling_confidence
number
sampling_ratio
number
sampling_threshold
integer
sampling_tolerance
number
source
enum<string>
An enumeration.
Available options:
interactive
, demo_signup
, manual
, api
, ci
, schedule
, auto
status
enum<string>
An enumeration.
Available options:
needs_confirmation
, needs_authentication
, waiting
, processing
, done
, failed
, cancelled
table1
string[]
table2
string[]
table_modifiers
enum<string>[]
Available options:
case_insensitive_strings
tags
string[]
temp_schema_override
string[]
time_aggregate
enum<string>
An enumeration.
Available options:
minute
, hour
, day
, week
, month
, year
time_column
string
time_interval_end
string
time_interval_start
string
time_travel_point1
time_travel_point2
updated_at
string
user_id
integer