I am test driving the ADO.NET provider for Snowflake to connect to data in Snowflake from Analysis Services in Multidimensional Mode. I follow the descriptions in the article.
Connection to Snowflake succeeds but when I try to add tables to the Data Source View there are no tables/views shown. The dialog is completely empty. Compare section “Creating a Data Source View” point 4 in the article where tables are visible. (Remark: I am also sure that tables are available in my Snowflake database)
I have set logging level to 5 and inspected the logs. The connection requests seem to work fine. But when calling ADOConnectionImpl.GetDataSourceInformation() it seems not to find the system table sys_sqlinfo.
What am I doing wrong? What is the root cause for not seeing any tables/views?
2025-10-15T17:50:11.184+02:003 [ 29| 38| 1] [EXEC|Normlz] Executing query: [SELECT [sys_sqlinfo].[VALUE], [sys_sqlinfo].[NAME] FROM [sys_sqlinfo] AS [sys_sqlinfo] WHERE [NAME] = 'IDENTIFIER_QUOTE_OPEN_CHAR']
2025-10-15T17:50:11.184+02:002 [ 29| Q-Id| 1] [EXEC|Messag] Executed query: [SELECT VALUE FROM sys_sqlinfo WHERE NAME = 'IDENTIFIER_QUOTE_OPEN_CHAR'] Success: (0 ms)
2025-10-15T17:50:11.184+02:002 [ 29| Q-Id| 1] [EXEC|Parsed] Executing query: [SELECT VALUE FROM sys_sqlinfo WHERE NAME = 'IDENTIFIER_QUOTE_CLOSE_CHAR']
2025-10-15T17:50:11.184+02:002 [ 29| 0| 1] [EXEC|Normlz] Normalized query: [SELECT [VALUE] FROM [sys_sqlinfo] WHERE [NAME] = 'IDENTIFIER_QUOTE_CLOSE_CHAR']
2025-10-15T17:50:11.184+02:002 [ 29| 0| 1] [EXEC|Normlz] Normalized query: [SELECT [sys_sqlinfo].[VALUE], [sys_sqlinfo].[NAME] FROM [sys_sqlinfo] WHERE [NAME] = 'IDENTIFIER_QUOTE_CLOSE_CHAR']
2025-10-15T17:50:11.184+02:003 [ 29| 39| 1] [EXEC|Normlz] Executing query: [SELECT [sys_sqlinfo].[VALUE], [sys_sqlinfo].[NAME] FROM [sys_sqlinfo] AS [sys_sqlinfo] WHERE [NAME] = 'IDENTIFIER_QUOTE_CLOSE_CHAR']
2025-10-15T17:50:11.184+02:002 [ 29| Q-Id| 1] [EXEC|Messag] Executed query: [SELECT VALUE FROM sys_sqlinfo WHERE NAME = 'IDENTIFIER_QUOTE_CLOSE_CHAR'] Success: (0 ms)
The portion of the log file you shared doesn't provide enough information for us to confirm whether the Database and Schema connection settings are configured properly. Can you confirm you have set these properties in the connection configuration?
Also, note that Snowflake is case-sensitive, so please ensure you're using the correct casing for the Database and Schema connection properties, as incorrect casing can cause similar issues.
Please check the above, and if you're still experiencing issues, I'd recommend raising a support ticket here and including the full log file so one of our support specialists can help you troubleshoot further .
The portion of the log file you shared doesn't provide enough information for us to confirm whether the Database and Schema connection settings are configured properly. Can you confirm you have set these properties in the connection configuration?
Also, note that Snowflake is case-sensitive, so please ensure you're using the correct casing for the Database and Schema connection properties, as incorrect casing can cause similar issues.
Please check the above, and if you're still experiencing issues, I'd recommend raising a support ticket here and including the full log file so one of our support specialists can help you troubleshoot further .
