Top Fields Constructors Methods
liquibase.database.core

public Class SnowflakeDatabase

extends AbstractJdbcDatabase
Class Inheritance
Imports
liquibase.CatalogAndSchema, .Scope, liquibase.database.AbstractJdbcDatabase, .DatabaseConnection, liquibase.database.jvm.JdbcConnection, liquibase.exception.DatabaseException, liquibase.executor.ExecutorService, liquibase.statement.core.RawSqlStatement, liquibase.structure.DatabaseObject, liquibase.structure.core.StoredProcedure, .Table, .View, liquibase.util.SystemUtil, java.math.BigInteger, java.sql.ResultSet, java.util.Arrays, .HashSet, .Set, java.util.regex.Pattern

Field Summary

Modifier and TypeField and Description
private static final Pattern
CREATE_VIEW_AS_PATTERN

Hides liquibase.database.AbstractJdbcDatabase.CREATE_VIEW_AS_PATTERN.

public static final String
PRODUCT_NAME

private final Set<String>
systemTables

private final Set<String>
systemViews

Inherited from liquibase.database.AbstractJdbcDatabase:
caseSensitivecurrentDateTimeFunctiondateFunctionsdefaultAutoIncrementBydefaultAutoIncrementStartWithdefaultCatalogNamedefaultSchemaNamequotingStrategysequenceCurrentValueFunctionsequenceNextValueFunctionunmodifiableDataTypesunquotedObjectsAreUppercased

Constructor Summary

AccessConstructor and Description
public
SnowflakeDatabase()

Method Summary

Modifier and TypeMethod and Description
protected void
configureSession()

public boolean
generateAutoIncrementBy(BigInteger incrementBy)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy.

public boolean
generateAutoIncrementStartWith(BigInteger startWith)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith.

protected String
getAutoIncrementByClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementByClause.

public String
getAutoIncrementClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.

protected String
getAutoIncrementStartWithClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementStartWithClause.

protected String
getConnectionSchemaName()

Overrides liquibase.database.AbstractJdbcDatabase.getConnectionSchemaName.

Overwrite this method to get the default schema name for the connection.

protected String
getDefaultDatabaseProductName()

Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.

public String
getDefaultDriver(String url)

Implements liquibase.database.Database.getDefaultDriver.

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

public Integer
getDefaultPort()

Implements liquibase.database.Database.getDefaultPort.

private Set<String>
getDefaultReservedWords()

public String
getDisplayName()

Overrides default liquibase.database.Database.getDisplayName.

public int
getPriority()

Implements liquibase.servicelocator.PrioritizedService.getPriority.

public String
getShortName()

Implements liquibase.database.Database.getShortName.

Returns an all-lower-case short name of the product.

public Set<String>
getSystemTables()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables.

Returns system (undroppable) views.

public Set<String>
getSystemViews()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews.

Returns system (undroppable) views.

public String
getViewDefinition(CatalogAndSchema schema, String viewName)

Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition.

Implements liquibase.database.Database.getViewDefinition.

public boolean
isCorrectDatabaseImplementation(DatabaseConnection conn)

Implements liquibase.database.Database.isCorrectDatabaseImplementation.

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

public void
rollback()

Overrides liquibase.database.AbstractJdbcDatabase.rollback.

Implements liquibase.database.Database.rollback.

public void
setConnection(DatabaseConnection conn)

Overrides liquibase.database.AbstractJdbcDatabase.setConnection.

Implements liquibase.database.Database.setConnection.

public boolean
supportsAutoIncrement()

Overrides liquibase.database.AbstractJdbcDatabase.supportsAutoIncrement.

Implements liquibase.database.Database.supportsAutoIncrement.

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

Overrides liquibase.database.AbstractJdbcDatabase.supportsCatalogInObjectName.

Implements liquibase.database.Database.supportsCatalogInObjectName.

public boolean
supportsCatalogs()

Overrides liquibase.database.AbstractJdbcDatabase.supportsCatalogs.

Implements liquibase.database.Database.supportsCatalogs.

public boolean
supportsDropTableCascadeConstraints()

Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints.

Implements liquibase.database.Database.supportsDropTableCascadeConstraints.

public boolean
supportsInitiallyDeferrableColumns()

Implements liquibase.database.Database.supportsInitiallyDeferrableColumns.

Returns whether this database support initially deferrable columns.

public boolean
supportsRestrictForeignKeys()

Overrides liquibase.database.AbstractJdbcDatabase.supportsRestrictForeignKeys.

Implements liquibase.database.Database.supportsRestrictForeignKeys.

public boolean
supportsSequences()

Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences.

Implements liquibase.database.Database.supportsSequences.

Does the database type support sequence.

public boolean
supportsTablespaces()

Implements liquibase.database.Database.supportsTablespaces.

Inherited from liquibase.database.AbstractJdbcDatabase:
addReservedWordscanCreateChangeLogTableclosecommitcorrectObjectNamecorrectSchemacorrectSchemacreatesIndexesForForeignKeysdataTypeIsNotModifiabledisableForeignKeyChecksdoesTagExistdropDatabaseObjectsenableForeignKeyChecksequalsescapeColumnNameescapeColumnNameescapeColumnNameListescapeConstraintNameescapeDataTypeNameescapeIndexNameescapeObjectNameescapeObjectNameescapeSequenceNameescapeStringForDatabaseescapeTableNameescapeViewNameexecuteexecuteRollbackStatementsexecuteRollbackStatementsexecuteStatementsfilterRollbackVisitorsgenerateDatabaseFunctionValuegeneratePrimaryKeyNamegetgetAutoCommitModegetAutoIncrementClausegetAutoIncrementClausegetAutoIncrementClosinggetAutoIncrementOpeninggetConcatSqlgetConnectiongetConnectionCatalogNamegetConnectionSchemaNameCallStatementgetContainingObjectsgetCurrentDateTimeFunctiongetDatabaseChangeLogLockTableNamegetDatabaseChangeLogTableNamegetDatabaseMajorVersiongetDatabaseMinorVersiongetDatabaseProductNamegetDatabaseProductVersiongetDataTypeMaxParametersgetDateFunctionsgetDateLiteralgetDateLiteralgetDateLiteralgetDateTimeLiteralgetDefaultCatalogNamegetDefaultFractionalDigitsForTimestampgetDefaultScaleForNativeDataTypegetDefaultSchemagetDefaultSchemaNamegetFetchSizegetJdbcCatalogNamegetJdbcCatalogNamegetJdbcSchemaNamegetJdbcSchemaNamegetLineCommentgetLiquibaseCatalogNamegetLiquibaseSchemaNamegetLiquibaseTablespaceNamegetMaxFractionalDigitsForTimestampgetNamegetObjectQuotingStrategygetOutputDefaultCataloggetOutputDefaultSchemagetQuotingEndCharactergetQuotingEndReplacementgetQuotingStartCharactergetRanChangeSetgetRanChangeSetListgetRanDategetRawDatabaseChangeLogLockTableNamegetRawDatabaseChangeLogTableNamegetRunStatusgetSchemaAndCatalogCasegetSchemaFromJdbcInfogetSystemSchemagetTimeLiteralhashCodeisAutoCommitisCaseSensitiveisCatalogOrSchemaTypeisCurrentTimeFunctionisDateOnlyisDateTimeisDefaultCatalogisDefaultSchemaisFunctionisLiquibaseObjectisReservedWordisSafeToRunUpdateisSystemObjectisSystemViewisTimeOnlyisTimestampjdbcCallsCatalogsSchemasmarkChangeSetExecStatusmustQuoteObjectNameparseDatequoteObjectremoveRanStatusrequiresExplicitNullForColumnsrequiresPasswordrequiresUsernameresetInternalStatesaveRollbackStatementsaveStatementssetsetAutoCommitsetCanCacheLiquibaseTableInfosetCaseSensitivesetCurrentDateTimeFunctionsetDatabaseChangeLogLockTableNamesetDatabaseChangeLogTableNamesetDefaultCatalogNamesetDefaultSchemaNamesetLiquibaseCatalogNamesetLiquibaseSchemaNamesetLiquibaseTablespaceNamesetObjectQuotingStrategysetOutputDefaultCatalogsetOutputDefaultSchemastartsWithNumericsupportsBatchUpdatessupportsDDLInTransactionsupportsForeignKeyDisablesupportsNotNullConstraintNamessupportsPrimaryKeyNamessupportsSchemastagtoStringunescapeDataTypeNameunescapeDataTypeStringvalidate

Field Detail

CREATE_VIEW_AS_PATTERNback to summary
private static final Pattern CREATE_VIEW_AS_PATTERN

Hides liquibase.database.AbstractJdbcDatabase.CREATE_VIEW_AS_PATTERN.

PRODUCT_NAMEback to summary
public static final String PRODUCT_NAME
systemTablesback to summary
private final Set<String> systemTables
systemViewsback to summary
private final Set<String> systemViews

Constructor Detail

SnowflakeDatabaseback to summary
public SnowflakeDatabase()

Method Detail

configureSessionback to summary
protected void configureSession()
generateAutoIncrementByback to summary
public boolean generateAutoIncrementBy(BigInteger incrementBy)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementBy.

Annotations
@Override
generateAutoIncrementStartWithback to summary
public boolean generateAutoIncrementStartWith(BigInteger startWith)

Overrides liquibase.database.AbstractJdbcDatabase.generateAutoIncrementStartWith.

Annotations
@Override
getAutoIncrementByClauseback to summary
protected String getAutoIncrementByClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementByClause.

Annotations
@Override
getAutoIncrementClauseback to summary
public String getAutoIncrementClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementClause.

Annotations
@Override
getAutoIncrementStartWithClauseback to summary
protected String getAutoIncrementStartWithClause()

Overrides liquibase.database.AbstractJdbcDatabase.getAutoIncrementStartWithClause.

Annotations
@Override
getConnectionSchemaNameback to summary
protected String getConnectionSchemaName()

Overrides liquibase.database.AbstractJdbcDatabase.getConnectionSchemaName.

Doc from liquibase.database.AbstractJdbcDatabase.getConnectionSchemaName.

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

Annotations
@Override
getDefaultDatabaseProductNameback to summary
protected String getDefaultDatabaseProductName()

Implements abstract liquibase.database.AbstractJdbcDatabase.getDefaultDatabaseProductName.

Annotations
@Override
getDefaultDriverback to summary
public String getDefaultDriver(String url)

Implements liquibase.database.Database.getDefaultDriver.

Doc from liquibase.database.Database.getDefaultDriver.

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

Annotations
@Override
getDefaultPortback to summary
public Integer getDefaultPort()

Implements liquibase.database.Database.getDefaultPort.

Annotations
@Override
getDefaultReservedWordsback to summary
private Set<String> getDefaultReservedWords()
getDisplayNameback to summary
public String getDisplayName()

Overrides default liquibase.database.Database.getDisplayName.

Returns:String

Doc from liquibase.database.Database.getDisplayName.

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

Annotations
@Override
getPriorityback to summary
public int getPriority()

Implements liquibase.servicelocator.PrioritizedService.getPriority.

Annotations
@Override
getShortNameback to summary
public String getShortName()

Implements liquibase.database.Database.getShortName.

Doc from liquibase.database.Database.getShortName.

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

Annotations
@Override
getSystemTablesback to summary
public Set<String> getSystemTables()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemTables.

Doc from liquibase.database.AbstractJdbcDatabase.getSystemTables.

Returns system (undroppable) views.

Annotations
@Override
getSystemViewsback to summary
public Set<String> getSystemViews()

Overrides liquibase.database.AbstractJdbcDatabase.getSystemViews.

Doc from liquibase.database.AbstractJdbcDatabase.getSystemViews.

Returns system (undroppable) views.

Annotations
@Override
getViewDefinitionback to summary
public String getViewDefinition(CatalogAndSchema schema, String viewName) throws DatabaseException

Overrides liquibase.database.AbstractJdbcDatabase.getViewDefinition.

Implements liquibase.database.Database.getViewDefinition.

isCorrectDatabaseImplementationback to summary
public boolean isCorrectDatabaseImplementation(DatabaseConnection conn) throws DatabaseException

Implements liquibase.database.Database.isCorrectDatabaseImplementation.

Doc from liquibase.database.Database.isCorrectDatabaseImplementation.

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

Annotations
@Override
rollbackback to summary
public void rollback() throws DatabaseException

Overrides liquibase.database.AbstractJdbcDatabase.rollback.

Implements liquibase.database.Database.rollback.

Annotations
@Override
setConnectionback to summary
public void setConnection(DatabaseConnection conn)

Overrides liquibase.database.AbstractJdbcDatabase.setConnection.

Implements liquibase.database.Database.setConnection.

Annotations
@Override
supportsAutoIncrementback to summary
public boolean supportsAutoIncrement()

Overrides liquibase.database.AbstractJdbcDatabase.supportsAutoIncrement.

Implements liquibase.database.Database.supportsAutoIncrement.

Annotations
@Override
supportsCatalogInObjectNameback to summary
public boolean supportsCatalogInObjectName(Class<? extends DatabaseObject> type)

Overrides liquibase.database.AbstractJdbcDatabase.supportsCatalogInObjectName.

Implements liquibase.database.Database.supportsCatalogInObjectName.

Annotations
@Override
supportsCatalogsback to summary
public boolean supportsCatalogs()

Overrides liquibase.database.AbstractJdbcDatabase.supportsCatalogs.

Implements liquibase.database.Database.supportsCatalogs.

Annotations
@Override
supportsDropTableCascadeConstraintsback to summary
public boolean supportsDropTableCascadeConstraints()

Overrides liquibase.database.AbstractJdbcDatabase.supportsDropTableCascadeConstraints.

Implements liquibase.database.Database.supportsDropTableCascadeConstraints.

Annotations
@Override
supportsInitiallyDeferrableColumnsback to summary
public boolean supportsInitiallyDeferrableColumns()

Implements liquibase.database.Database.supportsInitiallyDeferrableColumns.

Doc from liquibase.database.Database.supportsInitiallyDeferrableColumns.

Returns whether this database support initially deferrable columns.

Annotations
@Override
supportsRestrictForeignKeysback to summary
public boolean supportsRestrictForeignKeys()

Overrides liquibase.database.AbstractJdbcDatabase.supportsRestrictForeignKeys.

Implements liquibase.database.Database.supportsRestrictForeignKeys.

Annotations
@Override
supportsSequencesback to summary
public boolean supportsSequences()

Overrides liquibase.database.AbstractJdbcDatabase.supportsSequences.

Implements liquibase.database.Database.supportsSequences.

Doc from liquibase.database.AbstractJdbcDatabase.supportsSequences.

Does the database type support sequence.

Annotations
@Override
supportsTablespacesback to summary
public boolean supportsTablespaces()

Implements liquibase.database.Database.supportsTablespaces.

Annotations
@Override