Questions tagged [liquibase-sql]
113 questions
0
votes
1 answer
How to properly delete the schema in database which uses Liquibase?
I have a Postgres DB with a foreign schema from another DWH, but recently this original schema was deleted from there. We have the init.sql file with contents like this (edited to remove specifics):
--liquibase formatted sql
--changeset…
Dmitry Polovinkin
- 148
- 2
- 13
0
votes
0 answers
Create Table fails because it is being used by active queries in this session
I am trying to implement dynamic partitioning on a table by using triggers on insert of data.
Table:
property(record_uuid uuid NOT NULL, change timestamp NOT NULL, value VARCHAR(50), PRIMARY KEY(property_id, record_uuid, change)) PARTITION BY…
0
votes
0 answers
LIQUIBASE: CREATE EXTERNAL TABLE cannot run inside a multiple commands statement;
I have a sql file that has multiple CREATE EXTERNAL SCHEMA and CREATE EXTERNAL TABLE statements in it, that I'm trying to execute through Liquibase. This is running against a Redshift database. I'm getting the following error:
CREATE EXTERNAL…
Victor Rodriguez
- 11
- 2
0
votes
0 answers
Rollback using Spring Boot Application in Liquibase
I have a module in my project which contains Liquibase Changelogs and Changesets
The module contains one simple java class which calls Liquibase and executes all the changesets present in the changelog:
The java file is something like this:
package…
Harsh
- 11
- 1
0
votes
0 answers
Prevent Liquibase to read entire change log file
Our spring boot application uses a databaseChangeLog as xml with multiple
htmoia
- 429
- 4
- 9
0
votes
1 answer
How to specify tag values in Liquibase changelog/changeset XML?
I have a changelog file which contains multiple changesets like this:
Harsh
- 11
- 1
0
votes
1 answer
Liquibase - Use property value in changeset
I have this changeset
Fábio Pires
- 89
- 1
- 2
- 10
0
votes
0 answers
DATABASECHANGELOG file exists in pipeline
While running the liquibase update command I'm getting the below error. Especially subsequential runs from 2nd run onward.(Azure DevOps pipeline & target is Snowflake)
Unexpected error running Liquibase: SQL compilation error:
Object…
Awara
- 1
- 4
0
votes
1 answer
How to deploy stored procedures in SNowflake using liquibase
I am deploying tables, views, procedures to Snowflake DB using liquibase in gitlab. I am able to deploy tables, views but procedures are not getting deployed even after everything runs successfully.
My master.xml looks like this:
Laster
- 388
- 5
- 18
0
votes
0 answers
How to validate precondition of sql before submit for liquibase
Our SQL script gets failed in Liquibase if the SQL script contains a "GO" statement. We deploy 30 to 50 SQL scripts on every release.
How does everyone check the preconditions of the sql file before submitting it for the Liquibase build? I am…
John Scott
- 119
- 5
0
votes
0 answers
Liquibase changeset failing for SET data type
I have spring boot with liquibase changeset in my system.
below is my changeset which I am running
EV Experience
- 11
- 4
0
votes
2 answers
How to Update a Database table column to constraint nullable='true' | Liquibase
In liquibase, I created a table, one of column is like below
This changeset is already executed
Now I need to set this column as
gourav
- 33
- 7
0
votes
0 answers
How to use liquibase rollback for drop statements
I am using liquibase version-4.11 connected with snowflake and i have two pipelines for database automation using liquibase one is for DB Deploy and another one is DB Rollback. We are using this pipeline for the schema updation in snowflake. The DB…
0
votes
1 answer
In Liquibase, how can I rollback changes made to "rerunnable" (runOnChange=true) changesets?
In my liquibase project, I have an sql view that is defined within a file called create_myview.sql.
Each time a change is made to the view, i.e. a column is dropped or renamed, instead of creating a new changeset that contains an ALTER statement,…
Ivan Lendl
- 125
- 9
0
votes
1 answer
Liquibase is not taking the configurations from application.yml
I have a spring boot application. And I have configured liquibase to create tables. I have few issues though. The tables are not getting created inside the schema and in the location provided in application.yml. Also, if i change the username from…
Sharvari Nagesh
- 293
- 3
- 17