Data & Schema Discussions

Pull Dataset Information from IncortaMeta Data

Hi,I'm interested in retrieving comprehensive information regarding the data sources and their associated queries for all tables across various schemas. Could you assist me in extracting this data from Incorta's metadata or suggest an alternative app...

Dynamic SQL to union current and future tables

Hello, I am trying to union 36 tables together. The challenge comes in because there is another table that I need to union each month. So next month ill have 37 tables and the following ill have 38. Is that something we can do within Incorta? Tryi...

SQL Server DB Connection

Hi,I'm unable to access SQL server from Incorta error message from SQL server log ""Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client librar...

SQL Server Connector

I am unable to connect to SQL server, SQL servers Encryption is enabled and bind with a server certificate The error message I am getting from SQL server log is Encryption is required to connect to this server but the client library does not support...

Session Variable Query Filter Not Working

I am trying to create a session variable that returns a specific column value (say column X) from the row with the most recent date value. However the filter expression in my query does not work at all and I am returning all X column values.Why is my...