Ask a Question

Connect Snowflake DB to TestComplete

Occasional Contributor

Connect Snowflake DB to TestComplete

How can we execute query through snowflake on testcomplete using javascript and verify the data in testcomplete itself?

Champion Level 3

I've never heard of Snowflake DB before! 


If Snowflake DB has an ODBC Driver, then refer to Working With Databases and see the example for Connecting to a Microsoft SQL Server Database Using ADO. You need to use the correct Connection String for Snowflake DB. 


Ensure you use the correct architecture for your ODBC Driver, either 32-bit or 64-bit.

Champion Level 3



Access to database data in TestComplete uses the same approach for any database.

Primary option is ADO-based (Access Data Objects in the form of either native ADO COM objects or ADO Support extension provided by TestComplete. The latter is just a wrapper around native ADO). ADO requires either database-specific OE DB provider or ODBC driver. The bitness of OLE DB provider or ODBC driver must match TestComplete's bitness (or vise versa) and not necessarily must match the bitness of the database engine,

To use this option you must find either OLE DB provider or ODBC driver for Snowflake and then follow help section.


Secondary option is when/if the database does not provide any OLE DB/ODBC access but instead provides some DLL that makes it possible to access database data. In this case one can access database data by utilizing this DLL as per help section.


  /Alex [Community Champion]
[Community Champions] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Champions]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.
Showing results for 
Search instead for 
Did you mean: