Administrative Discussions

SQLi ( via Postgres data connection ) UNION supported?

Setup: I need to union two Incorta tables. I also need to add formula columns so not an Incorta SQL derived table. This *has* to be done in Incorta because half of the UNION is an Incorta snapshot table the contents of which do not persist in the...

Resolved! Stitch queries - requirements and troubleshooting

I have two "fact" tables ( one is actually a snapshot table so I'm not trying to get measures from it so much as I'm trying to get point in time attributes from it ) both joined to a date and a customer table where the "fact" is the child.In DW term...

Resolved! Where is the configuration for the cluster email URL ?

I sent a security reset to a user and when they click on the link they are direct to an old ( source for the clone ) URL.Where is the config setting for this in the CMC? Community v Support - who's quicker I'll post the answer here if I get it f...

Resolved! Incorta Metadata DB and credentials

I have a cluster which was cloned from another. I now need to update from <clustername>dev to <clustername> for the _incortametadata connection. However, deleting 'dev' leaves me with an unknown username and using my creds gives me a connection ...

Incorta datatype for a binary data type column?

Had the goofiest thing happen.We have series of MVs consolidating result sets. The origin is SQL against a SQLAnywhere DB. One of the columns is datatype "binary." All was well up until .... yesterday.Yesterday the last build in the sequence fai...