Check the
documentation
Ask the
Community
Take a look
at
Academy
Cognite
Status
Page
Contact
Cognite Support
Hi,
Is possible to make a sql query to an external SQL server from a Cognite Function?
Solved
SQL query from Cognit Function?
Best answer by vwrocks8
Ben Brandt wrote:
I am not aware of what infrastructure you are running on. For example, this is how the firewall rules work with Azure SQL:
IP firewall rules - Azure SQL Database and Azure Synapse Analytics | Microsoft Docs
Cognite Functions is primarily designed to operate on data in CDF, and at the moment it’s not possible for us to provide a list or a range of ip addresses that a function can use.
Yes, all outgoing traffic is allowed. However your SQL server needs to be publicly available for this to work.
I am not aware of what infrastructure you are running on. For example, this is how the firewall rules work with Azure SQL:
IP firewall rules - Azure SQL Database and Azure Synapse Analytics | Microsoft Docs
It would be great to know IP adress or IP range that Cognite Functions use.
We are using pyodbc but I could not get that to work with Functions. Any tips or alternatives?
Ben Brandt wrote:
I am not aware of what infrastructure you are running on. For example, this is how the firewall rules work with Azure SQL:
IP firewall rules - Azure SQL Database and Azure Synapse Analytics | Microsoft Docs
Cognite Functions is primarily designed to operate on data in CDF, and at the moment it’s not possible for us to provide a list or a range of ip addresses that a function can use.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.