Export route53 records to CSV

dump_route53_records.md

Retrieve hosted zones with aws route53 list-hosted-zones then enter the zone Id below:

aws route53 list-resource-record-sets --hosted-zone-id "/hostedzone/xxxxxxxxxxx" | \
   jq -r '.ResourceRecordSets[] | [.Name, .Type, (.ResourceRecords[]? | .Value), .AliasTarget.DNSName?]  | @tsv'

this solution handles ALIAS records which are exported as A records but invalid to import anywhere but AWS

• also replaces extraordinarily high TTL values with 86400 which is the highest possible, and null TTL values with 300
• any other null values are exported as "unknown" for troubleshooting later
• exports as tab separated for BIND format that can be imported elsewhere

profile=example
hosted_zone="HOSTEDZONEID"

aws route53 list-resource-record-sets --profile $profile --hosted-zone-id $hosted_zone --output json | \
jq -r '.ResourceRecordSets[] | "\(.Name // "unknown")\t\((if .TTL > 86400 then 86400 else .TTL // 300 end))\tIN\t\((if .AliasTarget.DNSName then "CNAME" else .Type // "unknown" end))\t\(.ResourceRecords[]?.Value // .AliasTarget.DNSName // "unknown")"'

Thank you!

Note: I ran a few of these aws/jq commands in a Microsoft Windows shell and got errors like

'[.Name' is not recognized as an internal or external command, operable program or batch file.

Using double quotes makes it work.

list-resource-record-sets --hosted-zone-id "/hostedzone/ZXXXXXXXXXXXXX" | jq -r ".ResourceRecordSets[] | [.Name, .Type, (.ResourceRecords[]? | .Value), .AliasTarget.DNSName?] | @tsv" > abc.tsv