CODEWITHSUNDEEP
liquibasesnowflake-cloud-data-platform
PeterG
PeterG

Reputation: 21

Liquibase Snowflake integration - specifically: generateChangeLog

When invoking:mvn liquibase:generateChangeLog I get this error:

*Object 'DATAWAREHOUSE_DB_DEV.INFORMATION_SCHEMA.CONSTRAINTS' does not exist or not authorized.*

Has anyone found a workaround for this issue? It seems Snowflake has a view DATAWAREHOUSE_DB_DEV.INFORMATION_SCHEMA.TABLE_CONSTRAINTS but Snowflake does not support synonyms and you can't create any new views in the INFORMATION_SCHEMA (to match what liquibase is looking for).

Upvotes: 2

Views: 241

Answers (1)

David Garrison
David Garrison

Reputation: 2880

This seems to me like a Liquibase version issue or something similar.

If you do need a workaround, can you create a view in a different schema that would work with your solution?

Akin to this:

create view public.constraints(constraint_catalog, constraint_schema, constraint_name) as (
      -- Start at the top of the hierarchy ...
      select constraint_catalog, constraint_schema, constraint_name
        from information_schema.table_constraints
  );

select * from public.constraints;

Upvotes: 2

Related Questions