Titan Core
  • Overview
  • Getting Started
  • Working With Resources
  • Blueprint
  • GitHub Action
  • Resources
    • APIAuthenticationSecurityIntegration
    • APIIntegration
    • AccountParameter
    • AggregationPolicy
    • Alert
    • AuthenticationPolicy
    • AzureStorageIntegration
    • ComputePool
    • Database
    • DatabaseRole
    • DynamicTable
    • EmailNotificationIntegration
    • EventTable
    • ExternalAccessIntegration
    • ExternalStage
    • FailoverGroup
    • FutureGrant
    • GCSStorageIntegration
    • GenericSecret
    • GlueCatalogIntegration
    • Grant
    • GrantOnAll
    • HybridTable
    • ImageRepository
    • InternalStage
    • JSONFileFormat
    • JavascriptUDF
    • MaterializedView
    • NetworkPolicy
    • NetworkRule
    • OAuthSecret
    • ObjectStoreCatalogIntegration
    • PackagesPolicy
    • ParquetFileFormat
    • PasswordPolicy
    • PasswordSecret
    • Pipe
    • PythonStoredProcedure
    • PythonUDF
    • ReplicationGroup
    • ResourceMonitor
    • Role
    • RoleGrant
    • S3StorageIntegration
    • Schema
    • Sequence
    • Service
    • SessionPolicy
    • Share
    • SnowflakePartnerOAuthSecurityIntegration
    • SnowservicesOAuthSecurityIntegration
    • StageStream
    • Table
    • TableStream
    • Tag
    • Task
    • User
    • View
    • ViewStream
    • Warehouse
Powered by GitBook
On this page
  • Examples
  • Python
  • YAML
  • Fields
  1. Resources

Table

PreviousStageStreamNextTableStream

Last updated 10 months ago

A table in Snowflake.

Examples

Python

table = Table(
    name="some_table",
    columns=[{"name": "col1", "data_type": "STRING"}],
    owner="SYSADMIN",
)

YAML

tables:
  - name: some_table
    columns:
      - name: col1
        data_type: STRING
    owner: SYSADMIN

Fields

  • name (string, required) - The name of the table.

  • columns (list, required) - The columns of the table.

  • constraints (list) - The constraints of the table.

  • transient (bool) - Whether the table is transient.

  • cluster_by (list) - The clustering keys for the table.

  • enable_schema_evolution (bool) - Whether schema evolution is enabled. Defaults to False.

  • data_retention_time_in_days (int) - The data retention time in days.

  • max_data_extension_time_in_days (int) - The maximum data extension time in days.

  • change_tracking (bool) - Whether change tracking is enabled. Defaults to False.

  • default_ddl_collation (string) - The default DDL collation.

  • copy_grants (bool) - Whether to copy grants. Defaults to False.

  • row_access_policy (dict) - The row access policy.

  • tags (dict) - The tags for the table.

  • comment (string) - A comment for the table.

owner (string or ) - The owner role of the table. Defaults to SYSADMIN.

Snowflake Documentation
Role