Supported Source Node Object Types

According to the documentation... "Source nodes represent the tables or views where raw data is queried to be processed by subsequent nodes. They are not manually editable other than to change their location or add a description." However I don't see my external tables as available sources which I logically expect them to be, I don't want to have to put a table or a view on top of this object to be able to source from it. This could of course be because I've done something wrong in the unnecessarily complex Snowflake security setup but it would be great if you could confirm exactly which table/view types are supported for use as source nodes please? A quick update to the documentation would be hugely appreciated as well. Cheers, Paul.
ANSWERED

Renaming a node

Attempted to rename a node (after creating the table) and when I hit the Create button I was expecting either that the underlying table with the original name would be dropped and the newly named one created or that a rename command would be issued to rename the table. However when I looked at my database I had both objects in there. Have I done something wrong? or is this the expected behaviour? Cheers, Paul.
ANSWERED

Creating outside of the interface

Is it possible for me to configure a .yml file for a new node outside of the interface, in VSCode for example, then push that up to my Git repo and resync in coalesce to have that new node available? I've had a look at the .yml files and there seem to be some system generated things in there that I'm not sure you can create outside of the tool itself. If the answer is RTFM then please tell me to RTFM! (Although a hint of where to look would be appreciated) Cheers, Paul.
ANSWERED

DISTINCT option

Could be that I'm missing something having only started using coalesce this morning but I couldn't see an option for a DISTINCT select on the OOTB nodes. Is this something that I would be expected to configure a custom node for? Or is it there but I just haven't spotted it? Cheers, Paul.
ANSWERED
ANSWERED

Database Engines

Does Coalesce work with any other database engines besides snowflake?
ANSWERED

hi

Hi, this is a pretty cool forum. Catching up interesting stuff about coalesce.
ANSWERED

does coalesce use dbt Core in the backend?

I see lots of dbt-jinja being used in the editor, does this mean dbt-core is being used in the backend?
ANSWERED

Am I able to write & run custom scriptz within Coalesce to clone Snowflake environments (e.g. Prod to Test/Dev)?

If so, what languages are available (e.g. Python or PowerShell)? Is there a scheduler we could use for this task?