Forum Discussion
Snowflake Tables Not Merging in Service
Hi etane ,
Adjust the Data Privacy Level of the Snowflake data source to Organizational or Public under Gateway connection settings. moving file of IPs, so then the most dynamic way I’ve found to manage this is with whitelisting the Azure Services Tags in Snowflake. The best place for your vendor to get this list from is Microsoft's public documentation, which can be scripted by them into a process to update a Snowflake Network Policy.
If you are still facing this issue you can rasie ticket for immediate support.
https://go.microsoft.com/fwlink/?linkid=2230908
Hi etane ,
Adjust the Data Privacy Level of the Snowflake data source to Organizational or Public under Gateway connection settings. moving file of IPs, so then the most dynamic way I’ve found to manage this is with whitelisting the Azure Services Tags in Snowflake. The best place for your vendor to get this list from is Microsoft's public documentation, which can be scripted by them into a process to update a Snowflake Network Policy.
If you are still facing this issue you can rasie ticket for immediate support.
https://go.microsoft.com/fwlink/?linkid=2230908
So, I am rummaging through the ips in the json file found in this link:
https://www.microsoft.com/en-us/download/details.aspx?id=56519
My tenant is in West US.
Which group of IPs should I ask our vendor's SF admin to whitelist?
We already did these:
PowerBI.WestUS
PowerPlatformInfra.WestUS
PowerQueryOnline.WestUS
and according to the SF admin:
global ranges for systemService=PowerBI and systemService=Fabric
What other service tags could we try to whitelist?
| ActionGroup.WestUS |
| ApiManagement.WestUS |
| AppService.WestUS |
| AppServiceManagement.WestUS |
| AzureArcInfrastructure.WestUS |
| AzureAttestation.WestUS |
| AzureBackup.WestUS |
| AzureBotService.WestUS |
| AzureCognitiveSearch.WestUS |
| AzureConnectors.WestUS |
| AzureContainerRegistry.WestUS |
| AzureCosmosDB.WestUS |
| AzureDataExplorerManagement.WestUS |
| AzureDevOps.WestUS |
| AzureDevSpaces.WestUS |
| AzureDigitalTwins.WestUS |
| AzureEventGrid.WestUS |
| EventHub.WestUS |
| AzureIoTHub.WestUS |
| AzureKeyVault.WestUS |
| AzureMachineLearning.WestUS |
| AzureMonitor.WestUS |
| AzureOpenDatasets.WestUS |
| AzurePortal.WestUS |
| AzureResourceManager.WestUS |
| Sql.WestUS |
| AzureSecurityCenter.WestUS |
| ServiceBus.WestUS |
| AzureSignalR.WestUS |
| Storage.WestUS |
| BatchNodeManagement.WestUS |
| DataFactory.WestUS |
| GatewayManager.WestUS |
| HDInsight.WestUS |
| LogicApps.WestUS |
| MicrosoftCloudAppSecurity.WestUS |
| MicrosoftContainerRegistry.WestUS |
| PowerBI.WestUS |
| PowerPlatformInfra.WestUS |
| PowerPlatformPlex.WestUS |
| PowerQueryOnline.WestUS |
| SCCservice.WestUS |
| ServiceFabric.WestUS |
| StorageSyncService.WestUS |
| WindowsVirtualDesktop.WestUS |
| AzureCloud.westus |