Community
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?
Posted by Anders Swanson about 1 year ago
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?
Posted by Alan Rowberry over 1 year ago
Data Vault 2 node types
I had hoped Coalesce would provide DV2 node types (hub, link, satellite, etc.) out of the box, but it doesn't appear to do so. Is there a plan to do so, or does everyone using DV2 need to create their own user-defined nodes?
Posted by Chris Johnson 8 months ago
hi
Hi, this is a pretty cool forum. Catching up interesting stuff about coalesce.
Posted by rp about 1 year ago
Database Engines
Does Coalesce work with any other database engines besides snowflake?
Posted by Treva Waltz 10 months ago
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.
Posted by [email protected] 8 months ago
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.
Posted by [email protected] 8 months ago
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.
Posted by [email protected] 8 months ago
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.
Posted by [email protected] 6 months ago
Are there more options for UDN Mapping Columns?
currently the only option is type: textBox.
I'd like to have a drop-down list of values that are pre-defined.
context: UDN for Advanced filtering where you can specify the operator (=, <, >, LIKE, etc) for a column
then another mapped column for the value and another mapped column for the condition grouping { AND, OR, (AND, (OR, AND), OR) }
Posted by Susan Kolesnikov 5 months ago