Passing Runtime Variables to Native SQL files

General Discussion
1

Hello All,
We have recently started using Liquibase, I would like to know if it is possible to pass runtime variables to SQL scripts in Liquibase. For examples I have &schema_name in my native sql script.
In Liquibase for Variable Substitution we have to use ${schema_name} but since we are dependent on our native sql script, We can’t replace &schema_name with ${schema_name}.
In liquibase is there any hookup available during runtime to replace &schema_name with ${schema_name}.

1 Like
2

&schema_name is a sqlplus substitution variable. If you have Liquibase Pro you could use the sqlplus integration: