Forum Discussion

etane's avatar
etane
Helper V
9 months ago
Solved

Snowflake Tables Not Merging in Service

Hello.   The company I work for recently started a SaaS subscription.  This vendor provided us with a Snowflake connection.  And, I am using this connection to pull tables into PBI Service through ...
Need Help
  • mohitkumawat's avatar
    mohitkumawat
    9 months ago

    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 

mohitkumawat's avatar
mohitkumawat
Impactful Individual
9 months ago

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 

  • etane's avatar
    etane
    Helper V
    9 months ago

    Thank you for your feedback.  I will ask our IT to look into whitelisting Azure Service Tags. 

     

    Unforntunately, our vendor refuses to do the whitelisting and asked our IT to do it.  And, vendor will then authorize the connections we create.

  • etane's avatar
    etane
    Helper V
    9 months ago

    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