[Snowflake Connector] Snowflake connector

Back to Forums

Phani M

Question

Forge

Service

Application Type

Service

My current database is in SQL Server and we are moving to snowflake. Can I use this connector to fetch data and fill detail screen to do necessary operations like save, update and delete records through detail and list screens

23 Jun 2023

Daniël Kuhlmann

MVP

Hi Phani,

If you want to extract data from your SQL Server database to a Snowflake, consider the following:

If your SQL Server database is an external database, you first need to set up the integration, either with Integration Studio or Integration Builder.
Create a timer in OutSystems and query the data from the database either using an aggregate or an Advanced SQL.
Transform the data to the document model you want to use in Snowflake.
Use the Snowflake connector to store the data you transformed in Snowflake.

The Snowflake component has an extensive documentation page, you can see there it supports inserting data into Snowflake:

Be aware you need to do some transformations, SQL Server is a relational database Snowflake is a Non-SQL database.

Regards,

Daniel

24 Jun 2023

Phani M

My current database is SQL Server and it will be migrateing to Snowflake, so no sql server interaction needed.

I am preparing a POC to check the Outsystems to Snowflake connectivity. Can you please help me with creating a solution.

Thanks

Phani

27 Jun 2023

1 reply

27 Jun 2023

Show thread

Hide thread

Daniël Kuhlmann

MVP

The Snowflake connector is well-connected, following the instructions on the Documentation tab of the Forge component should be enough to get it working. There is also the demo app from which you can inspect how to use the connector.

There is really nothing else one can help you with, there is documentation and working sample application

27 Jun 2023

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines