Is it possible to run get_* and specify a subscription id instead of using what is defined for the stack?

Exception: invoke of azure-native:network:getSubnet failed: invocation of azure-native:network:getSubnet returned an error: request failed /subscriptions

Get* methods can take their own provider with InvokeOptions so you should be able to call a Get* method with a specific subscription.

When I run this

env_provider = azure.Provider(
        "alt_subscription_provider",
        subscription_id=env_subscription_id
    )

    sql = get_server(
        resource_group_name=sql_role_config['sql_rsg'],
        server_name=sql_role_config['sql_name'],
        opts=InvokeOptions(provider=env_provider)
    )