Forum Discussion
jamesgiop
Jan 19, 2025Brass Contributor
Failed to ingest relationship with type dataset_process_inputs (Snowflake)
Hi All, Having the above issue when scanning snowflake but A - Only recently (perhaps since the start of the year) B - Only for around 5/2000 objects within snowflake. From the database side,...
AS1522
Microsoft
Apr 23, 2025Hey,
Are you still facing similar issue:
- Check that the scanning configuration is set up to dynamically insert table names.
- Verify that the account used for scanning has the required permissions.
- Review the logs for additional error messages and manually adjust the query if needed as many as times required
To fix this problem, manually adjust the query to include the correct table name. For example, if your table name is TEST_TABLE, the query should look like this:SELECT T.TABLE_CATALOG, T.TABLE_SCHEMA, T.TABLE_NAME, T.TABLE_TYPE, T.COMMENT, V.IS_SECURE, T.LAST_ALTERED
FROM INFORMATION_SCHEMA.TABLES T
LEFT OUTER JOIN INFORMATION_SCHEMA.VIEWS V
ON (T.TABLE_CATALOG=V.TABLE_CATALOG AND T.TABLE_SCHEMA=V.TABLE_SCHEMA AND T.TABLE_NAME=V.TABLE_NAME)
WHERE T.TABLE_TYPE IN ('BASE TABLE') AND T.TABLE_NAME = 'TEST_TABLE' AND T.TABLE_SCHEMA = 'TEST';
``` [2](https://learn.microsoft.com/en-us/answers/questions/2125438/invalidoperation-getmetadata-error-while-scanning)