Hello, you need to first get coordinate/position of the promoter region from
gff/gtf file on Ensembl. Then you need to extract all
SNPs on that region from dbSNP with tool
tabix. I hope this can help you. Last, you need to ask question with more detials, your question is too broad.