Databases

class Databases(session_kwargs, client, return_type='raw')

Civis API /databases endpoint.

Methods

delete_schemas_tables_projects(id, ...)	Remove a Database Table from a project
get(id)	Show database information
get_advanced_settings(id)	Get the advanced settings for this database
get_schema_privileges(id, schema_name, *[, ...])	Show schema privileges
get_schemas_tables(id, schema_name, ...[, ...])	Show basic table info
get_status_graphs_timeframe(id, timeframe)	Get the status graphs for this database
get_table_privileges_schema_name(id, ...[, ...])	Show table privileges
get_whitelist_ips(id, whitelisted_ip_id)	View details about a whitelisted IP
list()	List databases
list_advanced_settings(id)	Get the advanced settings for this database
list_groups(id)	List groups in the specified database
list_schemas(id, *[, name, credential_id])	List schemas in this database
list_schemas_tables(id, schema_name, *[, ...])	List tables in this schema
list_schemas_tables_projects(id, ...[, hidden])	List the projects a Database Table belongs to
list_users(id, *[, active])	Show list of database users
list_whitelist_ips(id)	List whitelisted IPs for the specified database
patch_advanced_settings(id, *[, ...])	Update the advanced settings for this database
patch_schemas_tables(id, schema_name, ...[, ...])	Update a table
post_schemas_scan(id, schema, *[, ...])	Creates and enqueues a schema scanner job
put_advanced_settings(id, export_caching_enabled)	Edit the advanced settings for this database
put_schemas_tables_projects(id, project_id, ...)	Add a Database Table to a project