How to get RedGate Sql Prompt to work in SSDT project?

Question

I am working on a SSDT project and I would like to use intellisense and snippet support of RedGate Sql Prompt, but I am unable to get that working. All I get from SqlPrompt is the name of the database and my snippets, nothing about the tables.

What I've tried so far without getting it to work:

• disabled VS's built in intellisense for sql
• added connection in sql server object explorer and server explorer

I am using VS2017 and SQL RedGate 8.0.

Answer 1

Apparently it doesn't support table/column/parameter expansion.