Data & Schema Discussions
The dataverse runs deep. Get help with connections, loading, schema development, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Incorta Regex formula

Hi,  I am trying to get regex to work in a materialized view but keep running into "undefined function" errors Is there something wrong with my format? SELECT Name,                  UniversalId,                  Item_Description,                 REG...

Resolved! Why are primary keys important?

We noticed that starting in 2023.7 we are getting error messages in the loader status, if the Enforce Primary Key Constraint option isn't selected with Primary keys setup in the table.  Screenshot below. Someone on our team asked why we even need pri...

JC_Data_Wizard_0-1696883505198.png

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...

TCoomes by Partner
  • 536 Views
  • 1 replies
  • 0 kudos

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...

Naruto by Cosmonaut
  • 346 Views
  • 0 replies
  • 0 kudos