---
- hosts: all
  sudo: yes
  remote_user: ubuntu

  vars:
    region: "us-east-1"
    aws_key: xx
    aws_sert: xx


  tasks:
    - name: gather cloudformation stacks
      set_fact:
        stack_name: uat-stack

    - name: gather cloudformation stacks2
      cloudformation_facts:
        stack_name: "{{ stack_name }}"
        region: "{{ region }}"
        aws_access_key: "{{ aws_key }}"
        aws_secret_key: "{{ aws_sert }}"

      register: my_stack

    - name: gather cloudformation stacks3
      debug:
         db_endpoint: "{{ my_stack.ansible_facts.cloudformation[stack_name].stack_outputs.DatabaseEndPoint }}"
         db_name: "{{ my_stack.ansible_facts.cloudformation[stack_name].stack_outputs.DatabaseName }}"
         db_password: "{{ my_stack.ansible_facts.cloudformation[stack_name].stack_outputs.DatabasePassword }}"
         db_user: "{{ my_stack.ansible_facts.cloudformation[stack_name].stack_outputs.DatabaseUsername }}"