Package liquibase.database.core

Class SnowflakeDatabase

java.lang.Object

liquibase.database.AbstractJdbcDatabase

liquibase.database.core.SnowflakeDatabase

All Implemented Interfaces:

AutoCloseable, Database, PrioritizedService

public class SnowflakeDatabase
extends AbstractJdbcDatabase

Field Summary

Fields

Modifier and Type	Field	Description
static final String	PRODUCT_NAME

Fields inherited from class liquibase.database.AbstractJdbcDatabase

caseSensitive, currentDateTimeFunction, dateFunctions, defaultAutoIncrementBy, defaultAutoIncrementStartWith, defaultCatalogName, defaultSchemaName, quotingStrategy, sequenceCurrentValueFunction, sequenceNextValueFunction, unmodifiableDataTypes, unquotedObjectsAreUppercased

Fields inherited from interface liquibase.database.Database

COMPLETE_SQL_SCOPE_KEY

Fields inherited from interface liquibase.servicelocator.PrioritizedService

COMPARATOR, PRIORITY_DATABASE, PRIORITY_DEFAULT

Constructor Summary

Constructors

Constructor	Description
SnowflakeDatabase()

Method Summary

Modifier and Type	Method	Description
protected void	configureSession()
boolean	generateAutoIncrementBy(BigInteger incrementBy)
boolean	generateAutoIncrementStartWith(BigInteger startWith)
String	generateConnectCommandSuccessMessage()	Returns a custom message to be displayed upon successful execution of the connect command.
protected String	getAutoIncrementByClause()
String	getAutoIncrementClause()
protected String	getAutoIncrementStartWithClause()
protected String	getConnectionSchemaName()	Overwrite this method to get the default schema name for the connection.
protected String	getDefaultDatabaseProductName()
String	getDefaultDriver(String url)	If this database understands the given url, return the default driver class name.
Integer	getDefaultPort()
String	getDisplayName()
int	getPriority()
String	getShortName()	Returns an all-lower-case short name of the product.
Set<String>	getSystemTables()	Returns system (undroppable) views.
Set<String>	getSystemViews()	Returns system (undroppable) views.
String	getViewDefinition(CatalogAndSchema schema, String viewName)
boolean	isCorrectDatabaseImplementation(DatabaseConnection conn)	Is this AbstractDatabase subclass the correct one to use for the given connection.
void	rollback()
void	setConnection(DatabaseConnection conn)
boolean	supportsAutoIncrement()
boolean	supportsCatalogInObjectName(Class<? extends DatabaseObject> type)
boolean	supportsCatalogs()	Whether this database supports catalogs
boolean	supportsDatabaseChangeLogHistory()	Does the particular database implementation support the database changelog history feature and associated table?
boolean	supportsDropTableCascadeConstraints()
boolean	supportsInitiallyDeferrableColumns()	Returns whether this database support initially deferrable columns.
boolean	supportsRestrictForeignKeys()
boolean	supportsSequences()	Does the database type support sequence.
boolean	supportsTablespaces()

Methods inherited from class liquibase.database.AbstractJdbcDatabase

addReservedWords, canCreateChangeLogTable, close, commit, correctObjectName, correctSchema, correctSchema, createsIndexesForForeignKeys, dataTypeIsNotModifiable, disableForeignKeyChecks, doesTagExist, dropDatabaseObjects, enableForeignKeyChecks, equals, escapeColumnName, escapeColumnName, escapeColumnNameList, escapeConstraintName, escapeDataTypeName, escapeIndexName, escapeObjectName, escapeObjectName, escapeSequenceName, escapeStringForDatabase, escapeTableName, escapeViewName, execute, executeRollbackStatements, executeRollbackStatements, executeStatements, filterRollbackVisitors, generateDatabaseFunctionValue, generatePrimaryKeyName, get, getAutoCommitMode, getAutoIncrementClause, getAutoIncrementClause, getAutoIncrementClosing, getAutoIncrementOpening, getConcatSql, getConnection, getConnectionCatalogName, getConnectionSchemaNameCallStatement, getContainingObjects, getCurrentDateTimeFunction, getDatabaseChangeLogLockTableName, getDatabaseChangeLogTableName, getDatabaseMajorVersion, getDatabaseMinorVersion, getDatabaseProductName, getDatabaseProductVersion, getDataTypeMaxParameters, getDateFunctions, getDateLiteral, getDateLiteral, getDateLiteral, getDateTimeLiteral, getDefaultCatalogName, getDefaultFractionalDigitsForTimestamp, getDefaultScaleForNativeDataType, getDefaultSchema, getDefaultSchemaName, getFetchSize, getJdbcCatalogName, getJdbcCatalogName, getJdbcSchemaName, getJdbcSchemaName, getLineComment, getLiquibaseCatalogName, getLiquibaseSchemaName, getLiquibaseTablespaceName, getMaxFractionalDigitsForTimestamp, getName, getObjectQuotingStrategy, getOutputDefaultCatalog, getOutputDefaultSchema, getQuotingEndCharacter, getQuotingEndReplacement, getQuotingStartCharacter, getRanChangeSet, getRanChangeSetList, getRanDate, getRawDatabaseChangeLogLockTableName, getRawDatabaseChangeLogTableName, getRunStatus, getSchemaAndCatalogCase, getSchemaFromJdbcInfo, getSystemSchema, getTimeLiteral, hashCode, isAutoCommit, isCaseSensitive, isCatalogOrSchemaType, isCurrentTimeFunction, isDateOnly, isDateTime, isDefaultCatalog, isDefaultSchema, isFunction, isLiquibaseObject, isReservedWord, isSafeToRunUpdate, isSystemObject, isSystemView, isTimeOnly, isTimestamp, jdbcCallsCatalogsSchemas, markChangeSetExecStatus, mustQuoteObjectName, parseDate, quoteObject, removeRanStatus, requiresExplicitNullForColumns, requiresPassword, requiresUsername, resetInternalState, saveRollbackStatement, saveStatements, set, setAutoCommit, setCanCacheLiquibaseTableInfo, setCaseSensitive, setCurrentDateTimeFunction, setDatabaseChangeLogLockTableName, setDatabaseChangeLogTableName, setDefaultCatalogName, setDefaultSchemaName, setLiquibaseCatalogName, setLiquibaseSchemaName, setLiquibaseTablespaceName, setObjectQuotingStrategy, setOutputDefaultCatalog, setOutputDefaultSchema, setPreviousAutoCommit, startsWithNumeric, supportsBatchUpdates, supportsDDLInTransaction, supportsForeignKeyDisable, supportsNotNullConstraintNames, supportsPrimaryKeyNames, supportsSchemas, tag, toString, unescapeDataTypeName, unescapeDataTypeString, validate

Methods inherited from class java.lang.Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface liquibase.database.Database

addCompleteSqlToScope, afterUpdate, checkDatabaseConnection, dropDatabaseObjects, failOnDefferable, supports, supportsCreateIfNotExists, temporarilySetObjectQuotingStrategy

Field Details

PRODUCT_NAME

public static final String PRODUCT_NAME

See Also:

• Constant Field Values

Constructor Details

SnowflakeDatabase

public SnowflakeDatabase()

Method Details

getShortName

public String getShortName()

Description copied from interface: Database

Returns an all-lower-case short name of the product. Used for end-user selecting of database type such as the DBMS precondition.

getDisplayName

public String getDisplayName()

Returns:

a properly formatted name of the product. Used for situations where the database is printed to the console. Example: "Snowflake" (note the capitalization)

getDefaultDatabaseProductName

protected String getDefaultDatabaseProductName()

Specified by:

getDefaultDatabaseProductName in class AbstractJdbcDatabase

getDefaultPort

public Integer getDefaultPort()

getSystemTables

public Set<String> getSystemTables()

Description copied from class: AbstractJdbcDatabase

Returns system (undroppable) views.

Overrides:

getSystemTables in class AbstractJdbcDatabase

getSystemViews

public Set<String> getSystemViews()

Description copied from class: AbstractJdbcDatabase

Returns system (undroppable) views.

Overrides:

getSystemViews in class AbstractJdbcDatabase

getPriority

public int getPriority()

supportsInitiallyDeferrableColumns

public boolean supportsInitiallyDeferrableColumns()

Description copied from interface: Database

Returns whether this database support initially deferrable columns.

supportsDropTableCascadeConstraints

public boolean supportsDropTableCascadeConstraints()

Specified by:

supportsDropTableCascadeConstraints in interface Database

Overrides:

supportsDropTableCascadeConstraints in class AbstractJdbcDatabase

isCorrectDatabaseImplementation

public boolean isCorrectDatabaseImplementation(DatabaseConnection conn)
                                        throws DatabaseException

Description copied from interface: Database

Is this AbstractDatabase subclass the correct one to use for the given connection.

Throws:

DatabaseException

getDefaultDriver

public String getDefaultDriver(String url)

Description copied from interface: Database

If this database understands the given url, return the default driver class name. Otherwise return null.

supportsCatalogs

public boolean supportsCatalogs()

Description copied from interface: Database

Whether this database supports catalogs

Specified by:

supportsCatalogs in interface Database

Overrides:

supportsCatalogs in class AbstractJdbcDatabase

supportsCatalogInObjectName

public boolean supportsCatalogInObjectName(Class<? extends DatabaseObject> type)

Specified by:

supportsCatalogInObjectName in interface Database

Overrides:

supportsCatalogInObjectName in class AbstractJdbcDatabase

supportsSequences

public boolean supportsSequences()

Description copied from class: AbstractJdbcDatabase

Does the database type support sequence.

Specified by:

supportsSequences in interface Database

Overrides:

supportsSequences in class AbstractJdbcDatabase

supportsTablespaces

public boolean supportsTablespaces()

supportsAutoIncrement

public boolean supportsAutoIncrement()

Specified by:

supportsAutoIncrement in interface Database

Overrides:

supportsAutoIncrement in class AbstractJdbcDatabase

getAutoIncrementClause

public String getAutoIncrementClause()

Overrides:

getAutoIncrementClause in class AbstractJdbcDatabase

getAutoIncrementStartWithClause

protected String getAutoIncrementStartWithClause()

Overrides:

getAutoIncrementStartWithClause in class AbstractJdbcDatabase

getAutoIncrementByClause

protected String getAutoIncrementByClause()

Overrides:

getAutoIncrementByClause in class AbstractJdbcDatabase

generateAutoIncrementStartWith

public boolean generateAutoIncrementStartWith(BigInteger startWith)

Overrides:

generateAutoIncrementStartWith in class AbstractJdbcDatabase

generateAutoIncrementBy

public boolean generateAutoIncrementBy(BigInteger incrementBy)

Overrides:

generateAutoIncrementBy in class AbstractJdbcDatabase

supportsRestrictForeignKeys

public boolean supportsRestrictForeignKeys()

Specified by:

supportsRestrictForeignKeys in interface Database

Overrides:

supportsRestrictForeignKeys in class AbstractJdbcDatabase

getConnectionSchemaName

protected String getConnectionSchemaName()

Description copied from class: AbstractJdbcDatabase

Overwrite this method to get the default schema name for the connection. If you only need to change the statement that obtains the current schema then override

Overrides:

getConnectionSchemaName in class AbstractJdbcDatabase

See Also:

• AbstractJdbcDatabase.getConnectionSchemaNameCallStatement()

setConnection

public void setConnection(DatabaseConnection conn)

Specified by:

setConnection in interface Database

Overrides:

setConnection in class AbstractJdbcDatabase

rollback

public void rollback()
              throws DatabaseException

Specified by:

rollback in interface Database

Overrides:

rollback in class AbstractJdbcDatabase

Throws:

DatabaseException

configureSession

protected void configureSession()

getViewDefinition

public String getViewDefinition(CatalogAndSchema schema,
 String viewName)
                         throws DatabaseException

Specified by:

getViewDefinition in interface Database

Overrides:

getViewDefinition in class AbstractJdbcDatabase

Throws:

DatabaseException

supportsDatabaseChangeLogHistory

public boolean supportsDatabaseChangeLogHistory()

Description copied from interface: Database

Does the particular database implementation support the database changelog history feature and associated table?

Returns:

true if supported, false otherwise

generateConnectCommandSuccessMessage

public String generateConnectCommandSuccessMessage()

Description copied from interface: Database

Returns a custom message to be displayed upon successful execution of the connect command. This method can be overridden by a database implementation to provide a specific message. If not overridden, it returns null by default.

Returns:

A custom success message for the connect command, or null if not provided.