Hello guys, I am having an issue when extracting JIRA data into Snowflake database:

> meltano --log-level=debug run tap-jira target-snowflake                                                                                                                         py meltano at 11:06:36
Need help fixing this problem? Visit <http://melta.no/> for troubleshooting steps, or to
join our friendly Slack community.

while constructing a mapping
  in "/Users/tien.phan/Documents/hackathon/meltano/my-meltano-project-dev/meltano.yml", line 1, column 1
found duplicate key "name" with value "staging" (original value: "dev")
  in "/Users/tien.phan/Documents/hackathon/meltano/my-meltano-project-dev/meltano.yml", line 8, column 1

To suppress this check see:
    <http://yaml.readthedocs.io/en/latest/api.html#duplicate-keys>

meltano.yml

~/Documents/hackathon/meltano/my-meltano-project-dev > cat meltano.yml                                                                                                                                                        
version: 1
default_environment: dev
project_id: 509f9c58-*** 
environments:

name: dev

name: staging

name: prod
plugins:
extractors:

name: tap-jira
variant: singer-io
pip_url: git+<https://github.com/singer-io/tap-jira.git>
config:
  username: <mailto:name@email.com|name@email.com> # your JIRA username
  password: ${TAP_JIRA_PASSWORD} # reference to .env file : TAP_JIRA_PASSWORD="<your_API_key>", generated in JIRA
  base_url: JIRA_URL
  cloud_id: data
  start_date: '2023-05-20'
  user_agent: tap-jira via Meltano
select:

name: target-snowflake
variant: transferwise
pip_url: git+<https://github.com/jaceksan/pipelinewise-target-snowflake.git>
config:
  account: us-east-1.aws
  dbname: PT_DEV #your db name here
  user: demo # shared in 1Password
  password: ${SNOWFLAKE_PASS} # reference to .env file : SNOWFLAKE_PASS="<your_snowflake_pass>", shared in 1Password
  warehouse: COMPUTE_WH
  primary_key_required: true
  file_format: PUBLIC.MELTANO_FORMAT
  add_metadata_columns: true

I am questioning where I will delete the duplicated key? Can you please show me how to fix it? Thanks a lot 🙏

Your indentation isn't quite right. Take a look at the examples here: https://github.com/search?q=meltano+environments%3A+language%3AYAML&type=code&l=YAML The warning is referring to

name: staging

because environments should look like this:

environments:
- name: dev
- name: staging
- name: prod

ouch … I am copying from one example configuration. Let me check your yaml