Last updated: July 22, 2025
DQOps REST API search operations
Search operations for finding data assets, such as tables.
find_columns
Finds columns in any data source and schema
Follow the link to see the source code on GitHub.
GET
Return value
Property name | Description | Data type |
---|---|---|
column_list_model |
List[ColumnListModel] |
Parameters of this method are described below
Property name | Description | Data type | Required |
---|---|---|---|
connection |
Optional connection name filter, accepts filters in the form: fullname, suffix, prefix, contains. | string | |
schema |
Optional schema name filter, accepts filters in the form: fullname, suffix, prefix, contains. | string | |
table |
Optional table name filter | string | |
column |
Optional column name filter | string | |
column_type |
Optional physical column's data type filter | string | |
column_category |
Optional data type category filter | DataTypeCategory | |
label |
Optional labels to filter the columns | List[string] | |
page |
Page number, the first page is 1 | long | |
limit |
Page size, the default is 100 rows, but paging is disabled is neither page and limit parameters are provided | long | |
check_type |
Optional parameter for the check type, when provided, returns the results for data quality dimensions for the data quality checks of that type | CheckType |
Usage examples
Execution
Expand to see the returned result
[ {
"connection_name" : "sample_connection",
"table" : {
"schema_name" : "sample_schema",
"table_name" : "sample_table"
},
"column_name" : "sample_column",
"has_any_configured_checks" : true,
"has_any_configured_profiling_checks" : true,
"type_snapshot" : {
"column_type" : "string",
"nullable" : false,
"length" : 256
},
"advanced_properties" : { },
"can_edit" : false,
"can_collect_statistics" : true,
"can_run_checks" : true,
"can_delete_data" : true
}, {
"connection_name" : "sample_connection",
"table" : {
"schema_name" : "sample_schema",
"table_name" : "sample_table"
},
"column_name" : "sample_column",
"has_any_configured_checks" : true,
"has_any_configured_profiling_checks" : true,
"type_snapshot" : {
"column_type" : "string",
"nullable" : false,
"length" : 256
},
"advanced_properties" : { },
"can_edit" : false,
"can_collect_statistics" : true,
"can_run_checks" : true,
"can_delete_data" : true
}, {
"connection_name" : "sample_connection",
"table" : {
"schema_name" : "sample_schema",
"table_name" : "sample_table"
},
"column_name" : "sample_column",
"has_any_configured_checks" : true,
"has_any_configured_profiling_checks" : true,
"type_snapshot" : {
"column_type" : "string",
"nullable" : false,
"length" : 256
},
"advanced_properties" : { },
"can_edit" : false,
"can_collect_statistics" : true,
"can_run_checks" : true,
"can_delete_data" : true
} ]
Execution
from dqops import client
from dqops.client.api.search import find_columns
from dqops.client.models import CheckType, \
DataTypeCategory
dqops_client = client.Client(
'http://localhost:8888/',
raise_on_unexpected_status=True
)
call_result = find_columns.sync(
client=dqops_client
)
Expand to see the returned result
[
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]
Execution
from dqops import client
from dqops.client.api.search import find_columns
from dqops.client.models import CheckType, \
DataTypeCategory
dqops_client = client.Client(
'http://localhost:8888/',
raise_on_unexpected_status=True
)
call_result = await find_columns.asyncio(
client=dqops_client
)
Expand to see the returned result
[
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]
Execution
from dqops import client
from dqops.client.api.search import find_columns
from dqops.client.models import CheckType, \
DataTypeCategory
token = 's4mp13_4u7h_70k3n'
dqops_client = client.AuthenticatedClient(
'http://localhost:8888/',
token=token,
raise_on_unexpected_status=True
)
call_result = find_columns.sync(
client=dqops_client
)
Expand to see the returned result
[
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]
Execution
from dqops import client
from dqops.client.api.search import find_columns
from dqops.client.models import CheckType, \
DataTypeCategory
token = 's4mp13_4u7h_70k3n'
dqops_client = client.AuthenticatedClient(
'http://localhost:8888/',
token=token,
raise_on_unexpected_status=True
)
call_result = await find_columns.asyncio(
client=dqops_client
)
Expand to see the returned result
[
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
ColumnListModel(
connection_name='sample_connection',
table=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
column_name='sample_column',
disabled=False,
id=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
type_snapshot=ColumnTypeSnapshotSpec(
column_type='string',
nullable=False,
length=256
),
advanced_properties={
},
can_edit=False,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]
find_tables
Finds tables in any data source and schema
Follow the link to see the source code on GitHub.
GET
Return value
Property name | Description | Data type |
---|---|---|
table_list_model |
List[TableListModel] |
Parameters of this method are described below
Property name | Description | Data type | Required |
---|---|---|---|
connection |
Optional connection name filter, accepts filters in the form: fullname, suffix, prefix, contains. | string | |
schema |
Optional schema name filter, accepts filters in the form: fullname, suffix, prefix, contains. | string | |
table |
Optional table name filter | string | |
label |
Optional labels to filter the tables | List[string] | |
page |
Page number, the first page is 1 | long | |
limit |
Page size, the default is 100 rows, but paging is disabled is neither page and limit parameters are provided | long | |
check_type |
Optional parameter for the check type, when provided, returns the results for data quality dimensions for the data quality checks of that type | CheckType |
Usage examples
Execution
Expand to see the returned result
[ {
"connection_name" : "sample_connection",
"table_hash" : 7188561880498907939,
"target" : {
"schema_name" : "sample_schema",
"table_name" : "sample_table"
},
"do_not_collect_error_samples_in_profiling" : false,
"always_collect_error_samples_in_monitoring" : false,
"has_any_configured_checks" : true,
"has_any_configured_profiling_checks" : true,
"run_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true
},
"run_profiling_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "profiling"
},
"run_monitoring_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "monitoring"
},
"run_partition_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "partitioned"
},
"data_clean_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"deleteErrors" : true,
"deleteStatistics" : true,
"deleteCheckResults" : true,
"deleteSensorReadouts" : true,
"deleteErrorSamples" : true,
"deleteIncidents" : true,
"deleteChecksConfiguration" : false
},
"advanced_properties" : { },
"can_edit" : true,
"can_collect_statistics" : true,
"can_run_checks" : true,
"can_delete_data" : true
}, {
"connection_name" : "sample_connection",
"table_hash" : 7188561880498907939,
"target" : {
"schema_name" : "sample_schema",
"table_name" : "sample_table"
},
"do_not_collect_error_samples_in_profiling" : false,
"always_collect_error_samples_in_monitoring" : false,
"has_any_configured_checks" : true,
"has_any_configured_profiling_checks" : true,
"run_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true
},
"run_profiling_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "profiling"
},
"run_monitoring_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "monitoring"
},
"run_partition_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "partitioned"
},
"data_clean_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"deleteErrors" : true,
"deleteStatistics" : true,
"deleteCheckResults" : true,
"deleteSensorReadouts" : true,
"deleteErrorSamples" : true,
"deleteIncidents" : true,
"deleteChecksConfiguration" : false
},
"advanced_properties" : { },
"can_edit" : true,
"can_collect_statistics" : true,
"can_run_checks" : true,
"can_delete_data" : true
}, {
"connection_name" : "sample_connection",
"table_hash" : 7188561880498907939,
"target" : {
"schema_name" : "sample_schema",
"table_name" : "sample_table"
},
"do_not_collect_error_samples_in_profiling" : false,
"always_collect_error_samples_in_monitoring" : false,
"has_any_configured_checks" : true,
"has_any_configured_profiling_checks" : true,
"run_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true
},
"run_profiling_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "profiling"
},
"run_monitoring_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "monitoring"
},
"run_partition_checks_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"enabled" : true,
"checkType" : "partitioned"
},
"data_clean_job_template" : {
"connection" : "sample_connection",
"fullTableName" : "sample_schema.sample_table",
"deleteErrors" : true,
"deleteStatistics" : true,
"deleteCheckResults" : true,
"deleteSensorReadouts" : true,
"deleteErrorSamples" : true,
"deleteIncidents" : true,
"deleteChecksConfiguration" : false
},
"advanced_properties" : { },
"can_edit" : true,
"can_collect_statistics" : true,
"can_run_checks" : true,
"can_delete_data" : true
} ]
Execution
from dqops import client
from dqops.client.api.search import find_tables
from dqops.client.models import CheckType
dqops_client = client.Client(
'http://localhost:8888/',
raise_on_unexpected_status=True
)
call_result = find_tables.sync(
client=dqops_client
)
Expand to see the returned result
[
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]
Execution
from dqops import client
from dqops.client.api.search import find_tables
from dqops.client.models import CheckType
dqops_client = client.Client(
'http://localhost:8888/',
raise_on_unexpected_status=True
)
call_result = await find_tables.asyncio(
client=dqops_client
)
Expand to see the returned result
[
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]
Execution
from dqops import client
from dqops.client.api.search import find_tables
from dqops.client.models import CheckType
token = 's4mp13_4u7h_70k3n'
dqops_client = client.AuthenticatedClient(
'http://localhost:8888/',
token=token,
raise_on_unexpected_status=True
)
call_result = find_tables.sync(
client=dqops_client
)
Expand to see the returned result
[
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]
Execution
from dqops import client
from dqops.client.api.search import find_tables
from dqops.client.models import CheckType
token = 's4mp13_4u7h_70k3n'
dqops_client = client.AuthenticatedClient(
'http://localhost:8888/',
token=token,
raise_on_unexpected_status=True
)
call_result = await find_tables.asyncio(
client=dqops_client
)
Expand to see the returned result
[
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
),
TableListModel(
connection_name='sample_connection',
table_hash=7188561880498907939,
target=PhysicalTableName(
schema_name='sample_schema',
table_name='sample_table'
),
disabled=False,
do_not_collect_error_samples_in_profiling=False,
always_collect_error_samples_in_monitoring=False,
has_any_configured_checks=True,
has_any_configured_profiling_checks=True,
has_any_configured_monitoring_checks=False,
has_any_configured_partition_checks=False,
partitioning_configuration_missing=False,
run_checks_job_template=CheckSearchFilters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_profiling_checks_job_template=CheckSearchFilters(
check_type=CheckType.PROFILING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_monitoring_checks_job_template=CheckSearchFilters(
check_type=CheckType.MONITORING,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
run_partition_checks_job_template=CheckSearchFilters(
check_type=CheckType.PARTITIONED,
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
),
data_clean_job_template=DeleteStoredDataQueueJobParameters(
connection='sample_connection',
full_table_name='sample_schema.sample_table',
delete_errors=True,
delete_statistics=True,
delete_check_results=True,
delete_sensor_readouts=True,
delete_error_samples=True,
delete_incidents=True,
delete_checks_configuration=False
),
advanced_properties={
},
can_edit=True,
can_collect_statistics=True,
can_run_checks=True,
can_delete_data=True
)
]