How do I find records by their 15-character Salesforce ID?

Issue

You want to find certain records by their 15-character Salesforce ID

Resolution

Heroku Connect uses 18-character Salesforce IDs (or sfids). You may occasionally encounter Salesforce IDs outside of Heroku Connect that are 15 characters long. If you need to search for the corresponding record in your database, use a wildcard search, like this:

SELECT * FROM salesforce.contact WHERE sfid LIKE '0030P00001yr8Fq%';