Comments
-
To be clear, this doesn't solve my issue, as my connector is JSON, not Redshift. Is there a way of achieving something similar with JSON?
-
I've just noticed in the Redshift Advanced connector, there's the ability to pass parameters into your SQL, including: Enter the query parameter value, it is the initial value for query parameter. The last run date is optional by default it is '02/01/1700' if is not provided. For…
-
No probs. It's a Beta feature, so you will need to ask DomoSupport to turn it on. It appears as a choice when you press "SQL" type connector.
-
I was very excited to see beast mode window functions in the #DP18 videos, so hopefully it is now enabled. But if not, the best way I’ve found for doing table calculations is a redshift sql DataFlow. The syntax for window functions is actually very readable and straightforward. Much simpler than trying to get head round…
-
Announced at domopalooza ‘18 is the support for window functions in beast mode. Sum(sum(x)) over () etc
-
I agree. Even if I wanted to only show NULLS in my report, I cannot. There's no way to recreate the "is null" and "is not null" from SQL.
