tables

Operations on a tables resource.

Overview

Name	tables
Type	Resource
Id	databricks_workspace.unitycatalog.tables

Fields

Name	Datatype
name	string
access_point	string
browse_only	boolean
catalog_name	string
columns	array
comment	string
created_at	integer
created_by	string
data_access_configuration_id	string
data_source_format	string
deleted_at	integer
delta_runtime_properties_kvpairs	object
effective_predictive_optimization_flag	object
enable_predictive_optimization	string
full_name	string
metastore_id	string
owner	string
pipeline_id	string
properties	object
row_filter	object
schema_name	string
sql_path	string
storage_credential_name	string
storage_location	string
table_constraints	array
table_id	string
table_type	string
updated_at	integer
updated_by	string
view_definition	string
view_dependencies	object

Methods

Name	Accessible by	Required Params	Description
get	SELECT	full_name, deployment_name	Gets a table from the metastore for a specific catalog and schema. The caller must satisfy one of the following requirements:
list	SELECT	catalog_name, schema_name, deployment_name	Gets an array of all tables for the current metastore under the parent catalog and schema. The caller must be a metastore admin or an owner of (or have the
delete	DELETE	full_name, deployment_name	Deletes a table from the specified parent catalog and schema. The caller must be the owner of the parent catalog, have the

SELECT examples

tables (get)

SELECT
name,
access_point,
browse_only,
catalog_name,
columns,
comment,
created_at,
created_by,
data_access_configuration_id,
data_source_format,
deleted_at,
delta_runtime_properties_kvpairs,
effective_predictive_optimization_flag,
enable_predictive_optimization,
full_name,
metastore_id,
owner,
pipeline_id,
properties,
row_filter,
schema_name,
sql_path,
storage_credential_name,
storage_location,
table_constraints,
table_id,
table_type,
updated_at,
updated_by,
view_definition,
view_dependencies
FROM databricks_workspace.unitycatalog.tables
WHERE full_name = '{{ full_name }}' AND
deployment_name = '{{ deployment_name }}';

tables (list)

SELECT
name,
access_point,
browse_only,
catalog_name,
columns,
comment,
created_at,
created_by,
data_access_configuration_id,
data_source_format,
deleted_at,
delta_runtime_properties_kvpairs,
effective_predictive_optimization_flag,
enable_predictive_optimization,
full_name,
metastore_id,
owner,
pipeline_id,
properties,
row_filter,
schema_name,
sql_path,
storage_credential_name,
storage_location,
table_constraints,
table_id,
table_type,
updated_at,
updated_by,
view_definition,
view_dependencies
FROM databricks_workspace.unitycatalog.tables
WHERE catalog_name = '{{ catalog_name }}' AND
schema_name = '{{ schema_name }}' AND
deployment_name = '{{ deployment_name }}';

DELETE example

Deletes a tables resource.

/*+ delete */
DELETE FROM databricks_workspace.unitycatalog.tables
WHERE full_name = '{{ full_name }}' AND
deployment_name = '{{ deployment_name }}';