POST
/
api
/
v1
/
datadiffs

Body

application/json
algorithm
enum<string>

An enumeration.

Available options:
join,
hash,
hash_v2_alpha
archived
boolean
default: false
bisection_factor
integer
bisection_threshold
integer
column_mapping
array
columns_to_compare
string[]
data_source1_id
integer
required
data_source1_session_parameters
object
data_source2_id
integer
required
data_source2_session_parameters
object
diff_tolerance
number
diff_tolerances_per_column
object[]
download_limit
integer
exclude_columns
string[]
filter1
string
filter2
string
include_columns
string[]
materialization_destination_id
integer
materialize_dataset1
boolean
materialize_dataset2
boolean
materialize_without_sampling
boolean
default: false
per_column_diff_limit
integer
pk_columns
string[]
required
purged
boolean
default: false
query1
string
query2
string
sampling_confidence
number
sampling_ratio
number
sampling_threshold
integer
sampling_tolerance
number
table1
string[]
table2
string[]
table_modifiers
enum<string>[]
Available options:
case_insensitive_strings
tags
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

Response

200 - application/json
affected_columns
string[]
algorithm
enum<string>

An enumeration.

Available options:
join,
hash,
hash_v2_alpha
archived
boolean
default: false
bisection_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_id
integer
required
data_source1_session_parameters
object
data_source2_id
integer
required
data_source2_session_parameters
object
diff_stats
object
diff_tolerance
number
diff_tolerances_per_column
object[]
done
boolean
default: false
download_limit
integer
exclude_columns
string[]
execute_as_user
boolean
filter1
string
filter2
string
finished_at
string
id
integer
include_columns
string[]
kind
enum<string>
required

An enumeration.

Available options:
in_db,
cross_db
materialization_destination_id
integer
materialize_dataset1
boolean
materialize_dataset2
boolean
materialize_without_sampling
boolean
default: false
monitor_state
enum<string>

An enumeration.

Available options:
ok,
alert,
error,
learning,
checking,
created
per_column_diff_limit
integer
pk_columns
string[]
required
purged
boolean
default: false
query1
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
List data diffsGet a data diff