Macro databricks__get_columns_from_information_schema is not working as expected about elementary HOT 4 CLOSED

@hamzamazhar - thanks, that's actually very helpful, so it's a pretty simple fix.

from elementary.

Hi all -
We have a PR for the bugfix to the macro - https://github.com/elementary-data/dbt-data-reliability/pull/722/files

That being said, the information_schema_columns model was actually removed in the recent versions of the package - so practically this issue is already resolved.

So I'm going ahead and closing this issue - please upgrade to the new version! (and feel free to re-open if you feel the issue persists even after upgrading, it shouldn't)

from elementary.

Hi @HantonMing ,
Thank you for opening this issue and sorry for such a long delay in our reply.

I'm not sure if this is still relevant to you, but actually would love to know - you mentioned the condition target.catalog is none is never met.
Do you manage to see what value does it contain? Does it contain a legitimate value even though you are not using Unity Catalog?

from elementary.

@haritamar Thanks a lot for getting back to me. To answer your question, in my case, the target.catalog is hive_metastore. As mentioned in my original ticket, I am not specifying the field catalog in the profiles.yaml or anywhere else in the project.

from elementary.