I have a database which - for some reason outside of my control - is set up bounded by speech marks. When trying to access the schema, it fails as the JSON ---- "database": "\"ProdDB\"", ---- seems to be resolving to ProdDB.INFORMATION_SCHEMA and not "ProdDB".INFORMATION_SCHEMA. The data warehouse is held on Snowflake.
I have a database which - for some reason outside of my control - is set up bounded by speech marks. When trying to access the schema, it fails as the JSON ---- "database": "\"ProdDB\"", ---- seems to be resolving to ProdDB.INFORMATION_SCHEMA and not "ProdDB".INFORMATION_SCHEMA. The data warehouse is held on Snowflake.