![]() INFORMATION_SCHEMA: Schema which contains views and table functions that can be used for querying metadata about the objects in theĭatabase, as well as across all objects in the account.ĭatabases created from shares differ from standard databases in the following ways: That is, when an object is replaced, the old object is deleted and the new object is created in a single transaction.Ĭreating a new database automatically creates two schemas in the database: Storage Costs for Time Travel and Fail-safe.ĬREATE OR REPLACE statements are atomic. This is important because dropped databases in Time Travel contribute to data storage for your account. The same name however, the dropped database is not permanently removed from the system. ![]() Using OR REPLACE is the equivalent of using DROP DATABASE on the existing database and then creating a new database with The tag value is always a string, and the maximum number of characters for the tag value is 256.įor details about specifying tags in a statement, refer to Tag Quotas for Objects & Columns. Specifies the tag name and the tag string value. COMMENT = ' string_literal 'ĭefault: No value TAG ( tag_name = ' tag_value ' ) Theĭefault can be overridden at the schema and individual table level.įor more details about the parameter, see DEFAULT_DDL_COLLATION. Specifies a default collation specification for all schemas and tables added to the database. DEFAULT_DDL_COLLATION = ' collation_specification ' Object parameter that specifies the maximum number of days for which Snowflake can extend the data retention period for tables in theĭatabase to prevent streams on the tables from becoming stale.įor a detailed description of this parameter, see MAX_DATA_EXTENSION_TIME_IN_DAYS. MAX_DATA_EXTENSION_TIME_IN_DAYS = integer For more details, see Understanding & Using Time Travel.įor a detailed description of this object-level parameter, as well as more information about object parameters, seeĪ value of 0 effectively disables Time Travel for the database. Specifies the number of days for which Time Travel actions (CLONE and UNDROP) can be performed on the database, as well as specifying theĭefault Time Travel retention time for all schemas created in the database. The cloning operation fails with an error. If the specified Time Travel time is at or before the point in time when the database was created, When cloning a database, the AT | BEFORE clause specifies to use Time Travel to clone the database at orīefore a specific point in the past. AT | BEFORE ( TIMESTAMP => timestamp | OFFSET => time_difference | STATEMENT => id ) For more details about cloning a database, see CREATE … CLONE. Specifies to create a clone of the specified source database. For more information aboutĭefault: No value (i.e. In addition, by definition, all schemas (and consequently all tables) created in a transient database are transient. ![]() They leave Time Travel however, this means they are also not protected by Fail-safe in the event of a data loss. Transient databases do not have a Fail-safe period so they do not incur additional storage costs once As a best practice, we recommend giving each secondary database the same name as its primary database. Though the legacy account locator can also be used as the account identifier, its use is discouraged as it may not work in the future.įor more details about using the account locator as an account identifier, see Database Replication Usage Notes. To view the list of accounts enabled for replication in your organization, query SHOW REPLICATION ACCOUNTS. The preferred identifier is organization_name. Unique identifier of the account that stores the primary database. Requires the account identifier and name of the primary database. Special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Specifies the identifier for a primary database from which to create a replica (i.e. Database Replication Parameters ¶ AS REPLICA OF account_identifier. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |