snowflake.core.table.Table

class snowflake.core.table.Table(*, name: StrictStr, kind: StrictStr | None = None, cluster_by: ConstrainedListValue[StrictStr] | None = None, enable_schema_evolution: StrictBool | None = None, change_tracking: StrictBool | None = None, data_retention_time_in_days: StrictInt | None = None, max_data_extension_time_in_days: StrictInt | None = None, default_ddl_collation: StrictStr | None = None, columns: ConstrainedListValue[TableColumn] | None = None, constraints: ConstrainedListValue[Constraint] | None = None, comment: StrictStr | None = None, created_on: datetime | None = None, database_name: StrictStr | None = None, schema_name: StrictStr | None = None, rows: StrictInt | None = None, bytes: StrictInt | None = None, owner: StrictStr | None = None, dropped_on: datetime | None = None, automatic_clustering: StrictBool | None = None, search_optimization: StrictBool | None = None, search_optimization_progress: StrictInt | None = None, search_optimization_bytes: StrictInt | None = None, owner_role_type: StrictStr | None = None, budget: StrictStr | None = None)

Bases: BaseModel

Attributes

name: StrictStr
kind: StrictStr | None
cluster_by: Optional[conlist(StrictStr)]
enable_schema_evolution: StrictBool | None
change_tracking: StrictBool | None
data_retention_time_in_days: StrictInt | None
max_data_extension_time_in_days: StrictInt | None
default_ddl_collation: StrictStr | None
columns: Optional[conlist(TableColumn)]
constraints: Optional[conlist(Constraint)]
comment: StrictStr | None
created_on: datetime | None
database_name: StrictStr | None
schema_name: StrictStr | None
rows: StrictInt | None
bytes: StrictInt | None
owner: StrictStr | None
dropped_on: datetime | None
automatic_clustering: StrictBool | None
search_optimization: StrictBool | None
search_optimization_progress: StrictInt | None
search_optimization_bytes: StrictInt | None
owner_role_type: StrictStr | None
budget: StrictStr | None

Methods

__init__(**data: Any) None

Create a new model by parsing and validating input data from keyword arguments.

Raises ValidationError if the input data cannot be parsed to form a valid model.

classmethod construct(_fields_set: SetStr | None = None, **values: Any) Model

Creates a new model setting __dict__ and __fields_set__ from trusted or pre-validated data. Default values are respected, but no other validation is performed. Behaves as if Config.extra = ‘allow’ was set since it adds all passed values

copy(*, include: AbstractSetIntStr | MappingIntStrAny | None = None, exclude: AbstractSetIntStr | MappingIntStrAny | None = None, update: DictStrAny | None = None, deep: bool = False) Model

Duplicate a model, optionally choose which fields to include, exclude and change.

Parameters:
  • include – fields to include in new model

  • exclude – fields to exclude from new model, as with values this takes precedence over include

  • update – values to change/add in the new model. Note: the data is not validated before creating the new model: you should trust this data

  • deep – set to True to make a deep copy of the model

Returns:

new model instance

dict(*, include: AbstractSetIntStr | MappingIntStrAny | None = None, exclude: AbstractSetIntStr | MappingIntStrAny | None = None, by_alias: bool = False, skip_defaults: bool | None = None, exclude_unset: bool = False, exclude_defaults: bool = False, exclude_none: bool = False) DictStrAny

Generate a dictionary representation of the model, optionally specifying which fields to include or exclude.

classmethod from_dict(obj: dict) Table

Create an instance of Table from a dict

classmethod from_json(json_str: str) Table

Create an instance of Table from a JSON string

classmethod from_orm(obj: Any) Model
json(*, include: AbstractSetIntStr | MappingIntStrAny | None = None, exclude: AbstractSetIntStr | MappingIntStrAny | None = None, by_alias: bool = False, skip_defaults: bool | None = None, exclude_unset: bool = False, exclude_defaults: bool = False, exclude_none: bool = False, encoder: Callable[[Any], Any] | None = None, models_as_dict: bool = True, **dumps_kwargs: Any) str

Generate a JSON representation of the model, include and exclude arguments as per dict().

encoder is an optional function to supply as default to json.dumps(), other arguments as per json.dumps().

classmethod parse_file(path: str | Path, *, content_type: str = None, encoding: str = 'utf8', proto: Protocol = None, allow_pickle: bool = False) Model
classmethod parse_obj(obj: Any) Model
classmethod parse_raw(b: str | bytes, *, content_type: str = None, encoding: str = 'utf8', proto: Protocol = None, allow_pickle: bool = False) Model
classmethod schema(by_alias: bool = True, ref_template: str = '#/definitions/{model}') DictStrAny
classmethod schema_json(*, by_alias: bool = True, ref_template: str = '#/definitions/{model}', **dumps_kwargs: Any) str
to_dict()

Returns the dictionary representation of the model using alias

to_json() str

Returns the JSON representation of the model using alias

to_str() str

Returns the string representation of the model using alias

classmethod update_forward_refs(**localns: Any) None

Try to update ForwardRefs on fields based on this Model, globalns and localns.

classmethod validate(value: Any) Model
语言: 中文