Table
laktory.models.resources.databricks.Table
¤
Bases: BaseModel
, PulumiResource
, TerraformResource
A table resides in the third layer of Unity Catalog’s three-level namespace. It contains rows of data.
ATTRIBUTE | DESCRIPTION |
---|---|
catalog_name |
Name of the catalog storing the table |
columns |
List of columns stored in the table
TYPE:
|
comment |
Text description of the catalog |
data_source_format |
External tables are supported in multiple data source formats. The string constants identifying these formats are DELTA, CSV, JSON, AVRO, PARQUET, ORC, TEXT. Change forces creation of a new resource. Not supported for MANAGED tables or VIEW.
TYPE:
|
grants |
List of grants operating on the schema
TYPE:
|
lookup_existing |
Specifications for looking up existing resource. Other attributes will be ignored.
TYPE:
|
name |
Name of the table
TYPE:
|
schema_name |
Name of the schema storing the table |
storage_credential_name |
For EXTERNAL Tables only: the name of storage credential to use. Change forces creation of a new resource. |
storage_location |
URL of storage location for Table data (required for EXTERNAL Tables). Not supported for VIEW or MANAGED table_type. |
table_type |
Distinguishes a view vs. managed/external Table.
TYPE:
|
view_definition |
SQL text defining the view (for |
warehouse_id |
All table CRUD operations must be executed on a running cluster or SQL warehouse. If a warehouse_id is specified, that SQL warehouse will be used to execute SQL commands to manage this table. |
Examples:
from laktory import models
table = models.resources.databricks.Table(
name="slv_stock_prices",
table_type="MANAGED",
)
References
ATTRIBUTE | DESCRIPTION |
---|---|
parent_full_name |
Schema full name
TYPE:
|
full_name |
Table full name
TYPE:
|
column_names |
List of column names |
is_from_cdc |
If
TYPE:
|
resource_key |
Table full name (catalog.schema.table)
TYPE:
|
additional_core_resources |
TYPE:
|
Attributes¤
--
laktory.models.resources.databricks.table.TableColumn
¤
Bases: BaseModel
A table column.
ATTRIBUTE | DESCRIPTION |
---|---|
name |
User-visible name of column
TYPE:
|
comment |
User-supplied free-form text.
TYPE:
|
identity |
Whether field is an identity column. Can be
TYPE:
|
nullable |
Whether field is nullable (Default:
TYPE:
|
type |
Column type spec (with metadata) as SQL text. Not supported for
TYPE:
|
type_json |
TYPE:
|
--
laktory.models.resources.databricks.table.TableLookup
¤
Bases: ResourceLookup
ATTRIBUTE | DESCRIPTION |
---|---|
name |
Full name of the databricks_table:
TYPE:
|