https://community.databricks.com/t5/data-engineering/information-schema-appears-empty/m-p/72804#M34609 <P>Hi,</P><P>We've encountered a problem with the information schema for one of our catalogs. For context: we're using dbt to implement our logic. We noticed this issue because dbt queries the <FONT face="courier new,courier">information_schema.tables </FONT>view to check which tables should be dropped first before running models. It became apparent that no tables were being dropped because the information schema for our catalog is empty.</P><P>After some digging, I came across <A href="https://community.databricks.com/t5/machine-learning/information-schema-is-not-populated-with-table-information/td-p/3524" target="_self">this thread</A>, which seems to describe the exact problem we're having. Early on in the project we renamed the catalog, unknowingly invalidating every view in its information schema.</P><P>This is a bother because we're not in a position to drop and rebuild the entire catalog. Currently, we're working around this issue with some manual actions, but I was hoping for a more permanent or elegant solution. This discussion also serves as a bug report/reminder that this problem is still occurring, I hope this is the right place for it.</P><P>Thanks in advance for any assistance!</P> Wed, 12 Jun 2024 15:10:17 GMT JonM 2024-06-12T15:10:17Z https://community.databricks.com/t5/data-engineering/information-schema-appears-empty/m-p/72804#M34609 <P>Hi,</P><P>We've encountered a problem with the information schema for one of our catalogs. For context: we're using dbt to implement our logic. We noticed this issue because dbt queries the <FONT face="courier new,courier">information_schema.tables </FONT>view to check which tables should be dropped first before running models. It became apparent that no tables were being dropped because the information schema for our catalog is empty.</P><P>After some digging, I came across <A href="https://community.databricks.com/t5/machine-learning/information-schema-is-not-populated-with-table-information/td-p/3524" target="_self">this thread</A>, which seems to describe the exact problem we're having. Early on in the project we renamed the catalog, unknowingly invalidating every view in its information schema.</P><P>This is a bother because we're not in a position to drop and rebuild the entire catalog. Currently, we're working around this issue with some manual actions, but I was hoping for a more permanent or elegant solution. This discussion also serves as a bug report/reminder that this problem is still occurring, I hope this is the right place for it.</P><P>Thanks in advance for any assistance!</P> Wed, 12 Jun 2024 15:10:17 GMT https://community.databricks.com/t5/data-engineering/information-schema-appears-empty/m-p/72804#M34609 JonM 2024-06-12T15:10:17Z