Skip to content

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

http://localhost:8888/api/search/columns

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

curl http://localhost:8888/api/search/columns^
    -H "Accept: application/json"
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

http://localhost:8888/api/search/tables

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

curl http://localhost:8888/api/search/tables^
    -H "Accept: application/json"
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
    )
]