# ADO.NET Provider for Snowflake does not show tables/views in Analysis Services Data Source View dialog **URL:** \ **Category:** CData Drivers\ **Tags:** sql-server-analysis-services, question, snowflake, ado.net\ **Created:** [October 15, 2025, 4:25pm UTC](https://community.cdata.com/t/ado-net-provider-for-snowflake-does-not-show-tables-views-in-analysis-services-data-source-view-dialog/1219 "2025-10-15T16:25:10Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![kde84](https://avatars.discourse-cdn.com/v4/letter/k/e5b9ba/32.png) [@kde84](https://community.cdata.com/u/kde84)\ **Post date:** [October 15, 2025, 4:25pm UTC](https://community.cdata.com/t/ado-net-provider-for-snowflake-does-not-show-tables-views-in-analysis-services-data-source-view-dialog/1219/1 "2025-10-15T16:25:12Z")
I am test driving the [ADO.NET](http://ADO.NET) provider for Snowflake to connect to data in Snowflake from Analysis Services in Multidimensional Mode.  I follow the descriptions in the article. > **[Build an OLAP Cube in SSAS from Snowflake Data](https://www.cdata.com/kb/tech/snowflake-ado-ssas.rst)** > > Establish a connection to Snowflake data data from SQL Server Analysis Services, and use the Snowflake Data Provider to build OLAP cubes for use in analytics and reporting. 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:00 5 [  29|    0|    1] [META|Schema] ADOConnectionImpl.GetDataSourceInformation()2025-10-15T17:50:11.184+02:00 2 [  29| Q-Id|    1] [EXEC|Parsed] Executing query: [SELECT VALUE FROM sys\_sqlinfo WHERE NAME = ‘IDENTIFIER\_QUOTE\_OPEN\_CHAR’]2025-10-15T17:50:11.184+02:00 2 [  29|    0|    1] [EXEC|Normlz] Normalized query: [SELECT [VALUE] FROM [sys\_sqlinfo] WHERE [NAME] = ‘IDENTIFIER\_QUOTE\_OPEN\_CHAR’]2025-10-15T17:50:11.184+02:00 2 [  29|    0|    1] [EXEC|Normlz] Normalized query: [SELECT [sys\_sqlinfo].[VALUE], [sys\_sqlinfo].[NAME] FROM [sys\_sqlinfo] WHERE [NAME] = ‘IDENTIFIER\_QUOTE\_OPEN\_CHAR’]2025-10-15T17:50:11.184+02:00 5 [  29|    0|    1] [META|Schema] Engine Invalid object name 'sys\_sqlinfo’2025-10-15T17:50:11.184+02:00 3 [  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:00 2 [  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:00 2 [  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:00 2 [  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:00 2 [  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:00 5 [  29|    0|    1] [META|Schema] Engine Invalid object name 'sys\_sqlinfo’2025-10-15T17:50:11.184+02:00 3 [  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:00 2 [  29| Q-Id|    1] [EXEC|Messag] Executed query: [SELECT VALUE FROM sys\_sqlinfo WHERE NAME = ‘IDENTIFIER\_QUOTE\_CLOSE\_CHAR’] Success: (0 ms)2025-10-15T17:50:14.684+02:00 5 [  29|    0|    1] [META|Schema] Engine Invalid object name 'sys\_disconnect’2025-10-15T17:50:14.684+02:00 4 [  29| Q-Id|    1] [INFO|Connec] Executed sys\_disconnect: Success: (0 ms)2025-10-15T17:50:14.684+02:00 1 [  29| Q-Id|    1] [INFO|Connec] Closed Snowflake connection2025-10-15T18:07:35.367+02:00 5 [  21|    0|    2] [META|Schema] Engine Invalid object name 'sys\_disconnect’2025-10-15T18:07:35.367+02:00 4 [  21| Q-Id|    2] [INFO|Connec] Executed sys\_disconnect: Success: (0 ms)2025-10-15T18:07:35.367+02:00 1 [  21| Q-Id|    2] [INFO|Connec] Closed Snowflake connection ---
**Author:** ![Ethem\_Q](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ethem_q/32/1997_2.png) [@Ethem\_Q](https://community.cdata.com/u/Ethem_Q)\ **Post date:** [October 21, 2025, 1:45pm UTC](https://community.cdata.com/t/ado-net-provider-for-snowflake-does-not-show-tables-views-in-analysis-services-data-source-view-dialog/1219/2 "2025-10-21T13:45:40Z")
Hi ​ @kde84 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](https://portal.cdata.com/support/submit-ticket) and including the full log file so one of our support specialists can help you troubleshoot further .